I'm getting an SQL Error after upgrading
 

Hi! I did an upgrade from 3.6.8 to 3.8.0. (Later I'm planning on going from 3.8.0 to the latest 4.x, but the instructions said to do it gradually.)

After the 3.8.0 upgrade, (without showing any errors in the upgrade process) I got this error in my Admin Control Panel Home Page:

Quote:
Database error in vBulletin 3.8.0:

Invalid SQL: SELECT COUNT(*) AS count FROM vb_moderation AS moderation INNER JOIN vb_post AS post USING (postid) WHERE moderation.type='reply'; MySQL Error : Unknown column 'postid' in 'from clause' Error Number : 1054 Request Date : Sunday, August 8th 2010 @ 03:49:01 PM Error Date : Sunday, August 8th 2010 @ 03:49:03 PM Script : http://www.sissykiss.com/sk2/adminba...ex.php?do=home Referrer : http://www.sissykiss.com/sk2/adminbabe/index.php IP Address : 64.40.155.10 Username : ~*Christie Luv*~ Classname : vB_Database MySQL Version : 5.0.81-community

__________________________________________


Database error in vBulletin 3.8.0:

Invalid SQL:

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

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Sunday, August 8th 2010 @ 03:49:01 PM
Error Date : Sunday, August 8th 2010 @ 03:49:03 PM
Script : http://www.sissykiss.com/sk2/adminba...ex.php?do=home
Referrer : http://www.sissykiss.com/sk2/adminbabe/index.php
IP Address : 64.40.155.10
Username : ~*Christie Luv*~
Classname : vB_Database
MySQL Version : 5.0.81-community