Database Error - regimage

[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]

Originally Posted by 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.

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]

Originally Posted by Digital Jedi

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/adm...ex.php?do=home
Referrer : http://www.xxxxxx.com/forums/admincp/
IP Address :
Username :
Classname : vB_Database