PDA

View Full Version : vbToplist mysql error


TimberFloorAu
04-05-2009, 12:03 AM
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


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/showthread.php?t=98646&highlight=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
Yes its a product, and as stated in the very first line, he seems to have disappeared.

https://vborg.vbsupport.ru/showthread.php?t=98646&highlight=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

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
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: