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/cron.php?&rand=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]

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]

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 (https://vborg.vbsupport.ru/showpost.php?p=1489382&postcount=845). (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]

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

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.

[SVTCobraLTD]

I am thinking while trying to install a copy of 3.6 in another MySQL database the current sites database may have been affected somehow causing this issue. Since under Products it says vb 3.8.6. However AdminCP says 3.6.11 and the error says 3.8.6. So I believe the database got messed up while attempting to setup my temporary 3.8 board for testing.

[Digital Jedi]

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.
True. But ultimately it seems to stem from his failed upgrade. Correct me if I'm wrong, but wouldn't even some of the default scheduled tasks still trigger the error?

[SVTCobraLTD]

True. But ultimately it seems to stem from his failed upgrade.

It is, since I am getting this when opening AdminCP...

Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Date : Wednesday, December 29th 2010 @ 01:59:29 PM
Script : http://www.xxxxxxxxxx.com/forums/admincp/index.php?do=home
Referrer : http://www.xxxxxx.com/forums/admincp/
IP Address :
Username :
Classname : vB_Database