vb.org Archive - vbToplist mysql error

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - vbToplist mysql error (https://vborg.vbsupport.ru/showthread.php?t=210337)

TimberFloorAu

04-05-2009 12:03 AM

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

Brandon Sheley

04-05-2009 12:09 AM

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

TimberFloorAu

04-05-2009 12:39 AM

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

Brandon Sheley

04-05-2009 12:59 AM

Quote:

Originally Posted by TimberFloorAu (Post 1784054)

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

TimberFloorAu

04-05-2009 01:01 AM

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

Ste

Lynne

04-05-2009 02:18 AM

Make sure you remove any files you uploaded for that modification also.

Dismounted

04-05-2009 04:56 AM

Quote:

Originally Posted by Lynne (Post 1784092)

Make sure you remove any files you uploaded for that modification also.

Especially those that reside in /includes/xml.

TimberFloorAu

04-05-2009 09:11 AM

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

Appreciate your replies :up:

All times are GMT. The time now is 02:22 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01061 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: