MYSQL Error?

[kingrellik]

I got this right after i did the upgrade...

Database error in vBulletin 3.7.0:
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 : Sunday, May 4th 2008 @ 03:40:54 PM
Script : http://www.maskedmurdererz.com/admin...ex.php?do=home
Referrer : http://www.maskedmurdererz.com/admincp/index.php
IP Address : 68.47.216.250
Username : xKRAZYRELLIKx
Classname : vB_Database

Does anyone have a clue as to what i did wrong?

[kingrellik]

also when i go to see what someone has posted i get this error...

Fatal error: Call to undefined function fetch_tagbits() in /home/content/k/i/n/kingrellik/html/showthread.php on line 1698

thanks in advance for any help you all give me

[Jake Bunce]

MySQL Error : Unknown column 'postid' in 'from clause'

The moderation table has no postid field in 3.7.x. That reference must be from custom code. Try disabling your plugins:

Admin CP -> vBulletin Options -> Plugin/Hook System

Also run a file check to look for customized files:

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

Fatal error: Call to undefined function fetch_tagbits() in /home/content/k/i/n/kingrellik/html/showthread.php on line 1698

Code errors like that are also usually caused by custom code. I suspect the above instructions will fix that too.

[kingrellik]

i have a bunch of file mismatch: Found 3.7, expected 3.6.9. Could this be the problem and after disabling the plugins i still get the same errors

[kingrellik]

will i have to re-upload 3.7 and run the update again or install a new 3.7 to fix this problem?

[Jake Bunce]

It looks like the upgrade wasn't complete. Make sure you ran the full upgrade:

1) Upload the new files, overwriting the old ones.

2) Run the install/upgrade.php script in your browser.