Database Error - regimage

[SVTCobraLTD]

Anyone know how to resolve this?

Database error in vBulletin 3.8.6:

Invalid SQL:

DELETE FROM regimage
WHERE dateline < 1293326765;

MySQL Error : Table 'database_name.regimage' doesn't exist
Error Number : 1146
Date : Saturday, December 25th 2010 @ 08:26:05 PM
Script : http://www.xxxxxxxxxx.com/forums/cro...and=1293330364
Referrer : http://www.xxxxxx.com/forums/
IP Address :
Username : Unregistered
Classname : vB_Database

The issue may be that I am running vb 3.6.11 even though it says 3.8.6. I think I did the update on the wrong database and that might be part of the issue. Not sure how to revert with without loosing new posts.

[BirdOPrey5]

"regimage" isn't a table in vb 3.8.6, I'm not sure if it was ever part of "3.6" either- it might be a broke mod... do you know which cron job is causing the error?

[SVTCobraLTD]

Originally Posted by BirdOPrey5

do you know which cron job is causing the error?

How can I check this?

[BirdOPrey5]

In Admin CP -> Statistics & Logs -> Scheduled Task Log... See what was running at the time specified in the error.

[SVTCobraLTD]

Originally Posted by BirdOPrey5

In Admin CP -> Statistics & Logs -> Scheduled Task Log... See what was running at the time specified in the error.

Error happened at 3:20pm and 4:20pm but the log only shows this below:

127753 Process Mail Queue 17:30, 27th Dec 2010 Processed Mail Queue
127752 Process Mail Queue 17:22, 27th Dec 2010 Processed Mail Queue
127751 Process Mail Queue 17:13, 27th Dec 2010 Processed Mail Queue
127750 Process Mail Queue 17:00, 27th Dec 2010 Processed Mail Queue
127749 Process Mail Queue 16:54, 27th Dec 2010 Processed Mail Queue
127748 Process Mail Queue 16:47, 27th Dec 2010 Processed Mail Queue
127747 Process Mail Queue 16:35, 27th Dec 2010 Processed Mail Queue
127746 Process Mail Queue 16:21, 27th Dec 2010 Processed Mail Queue
127745 Process Mail Queue 16:15, 27th Dec 2010 Processed Mail Queue
127744 Process Mail Queue 16:02, 27th Dec 2010 Processed Mail Queue
127743 Process Mail Queue 15:51, 27th Dec 2010 Processed Mail Queue
127742 Process Mail Queue 15:47, 27th Dec 2010 Processed Mail Queue
127741 Process Mail Queue 15:32, 27th Dec 2010 Processed Mail Queue
127740 Process Mail Queue 15:22, 27th Dec 2010 Processed Mail Queue
127739 Process Mail Queue 15:13, 27th Dec 2010 Processed Mail Queue

There is no 15:20 or 16:20 to match those times. And if this was the error, I should be getting lots of errors sent to me, not just 1 an hour.

[BirdOPrey5]

Hmmm... the only scheduled task that runs on the 20 after of every hour by default is called Hourly Cleanup #2. which is the file ./includes/cron/cleanup2.php.

Whatever is causing your error is in that file... The fact this is a default vbulletin scheduled task strongly suggests the problem is related to your failed upgrade.

Further investigation I confirm the table "repimage" was removed from vBulletin starting in 3.7.0 so you have code from 3.6 and code from 3.8 conflicting.
Some details here. (In the quote.)

Basically you're going to probably need to do a complete/full upgrade to fix this.

If you wanted to simply get rid of the error without fixing the problem go to your phpmyadmin and try creating a new table called PREFIX_repimage where PREFIX is your table prefix you set on config.php. This *may* work but isn't a good long term solution.

[preemz10314]

probably a plug in you recently installed. go down the line and disable/uninstall all new plugins you may have installed.

[ccp77]

yup this is a MOD issue try disabling a mod that yu recently installed remmeber if its a mod that yu installed through FTP remove it from there,...

[Digital Jedi]

Originally Posted by preemz10314

probably a plug in you recently installed. go down the line and disable/uninstall all new plugins you may have installed.

Originally Posted by ccp77

yup this is a MOD issue try disabling a mod that yu recently installed remmeber if its a mod that yu installed through FTP remove it from there,...

Guys, try reading BirdOPrey's post before jumping in definitively.

[BirdOPrey5]

They might be right... It's possible a mod installed a scheduled task to run every hour at 20 after, the same as HourlyCleanup 2... I hope the OP figures it out either way and returns to post whatever worked.