Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2009, 12:03 AM
TimberFloorAu's Avatar
TimberFloorAu TimberFloorAu is offline
 
Join Date: May 2008
Location: Brisbane
Posts: 2,264
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vbToplist mysql error

Ok I know I should approach the coder, but he seems to have disappeared into thin air.

We have a repetitive error in our sql.

The error returns this

Code:
Database error in vBulletin 3.8.0:

Invalid SQL:
SELECT * FROM oursitetoplist_sites WHERE `id` = '3' LIMIT 1;

MySQL Error   : Table 'oursite_forum.oursitetoplist_sites' doesn't exist
Error Number  : 1146
Request Date  : Sunday, April 5th 2009 @ 10:14:10 AM
Error Date    : Sunday, April 5th 2009 @ 10:14:10 AM
Script        : http://www.oursite.com/forum/images/toplist/buttons/dynamic/image.png?id=3
Referrer      :
IP Address    : xx.xxx.xxx.xxx
Username      : TimberFloorAu
Classname     : vB_Database
MySQL Version : 4.1.22-standard
The issue is, the product has been totally ( i thought ) removed.

Also this table doesnt exist.
So what is spewing out this error.

Any suggestions please
Reply With Quote
  #2  
Old 04-05-2009, 12:09 AM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

is vbtoplist a mod released here?
if so, it's best if you ask in that thread
you can try installing and un-installing it again, see if that helps

cheers
Reply With Quote
  #3  
Old 04-05-2009, 12:39 AM
TimberFloorAu's Avatar
TimberFloorAu TimberFloorAu is offline
 
Join Date: May 2008
Location: Brisbane
Posts: 2,264
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes its a product, and as stated in the very first line, he seems to have disappeared.

https://vborg.vbsupport.ru/showthrea...hlight=toplist

Uninstalling it, does not seem to work. Its leaving behind false tables, if thats correct terminology.

The table is not in the database, but it would appear it must be calling it from somewhere within another table, as it is spewing out this error.

There are no crons running neither for this , that i can determine
Reply With Quote
  #4  
Old 04-05-2009, 12:59 AM
Brandon Sheley's Avatar
Brandon Sheley Brandon Sheley is offline
 
Join Date: Mar 2005
Location: Google Kansas
Posts: 4,678
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TimberFloorAu View Post
Yes its a product, and as stated in the very first line, he seems to have disappeared.

https://vborg.vbsupport.ru/showthrea...hlight=toplist

Uninstalling it, does not seem to work. Its leaving behind false tables, if thats correct terminology.

The table is not in the database, but it would appear it must be calling it from somewhere within another table, as it is spewing out this error.

There are no crons running neither for this , that i can determine
that thread is the best to ask than
and did you try installing, and removing like my suggestion?
It's worked for me in the past with some error messages like the above
Reply With Quote
  #5  
Old 04-05-2009, 01:01 AM
TimberFloorAu's Avatar
TimberFloorAu TimberFloorAu is offline
 
Join Date: May 2008
Location: Brisbane
Posts: 2,264
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Will give it a go, we also had similar issues for iTrader, but that fella never responded neither lol

Ste
Reply With Quote
  #6  
Old 04-05-2009, 02:18 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Make sure you remove any files you uploaded for that modification also.
Reply With Quote
  #7  
Old 04-05-2009, 04:56 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Lynne View Post
Make sure you remove any files you uploaded for that modification also.
Especially those that reside in /includes/xml.
Reply With Quote
  #8  
Old 04-05-2009, 09:11 AM
TimberFloorAu's Avatar
TimberFloorAu TimberFloorAu is offline
 
Join Date: May 2008
Location: Brisbane
Posts: 2,264
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Pretty sure I got all the files, will go back and recheck.

Appreciate your replies :up:
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:37 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08218 seconds
  • Memory Usage 2,231KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete