Database Error

[WFZ]

Hello,

When I go to my ACP I get this database error :

Database error in vBulletin 3.7.0 Beta 5:

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 : Friday, February 15th 2008 @ 07:08:43 PM
Script : http://www.wrestling-forums.net/admincp/index.php?do=home
Referrer : http://www.wrestling-forums.net/admincp/index.php?do=nav
IP Address : *********
Username : **********
Classname : vB_Database



Please help, thanks.

[Lynne]

Try turning off your plugins and see if the error goes away. This will help you find out if the error is caused by a modification you added.

[WFZ]

Just tried it, still not working :(

[Marco van Herwaarden]

Which MySQL version are you using?

[WFZ]

Version: MySQL v5

[Marco van Herwaarden]

Is this default vBulletin code? Seems odd as there is no 'postid' column in the moderation table.

[Opserty]

Did you upload all the files for vB 3.7 Beta 5 overwriting the old ones?

I checked the bug reports on vb.com about this error, they said just to upload the latest version of the file which is applicable to your installation. (i.e. vB 3.7 Beta 5). See if that resolves the issue, it may be that you have a few old files which weren't overwritten or something?

[WFZ]

Yeah, I think that is why, I have no idea how to fix it :(

[Opserty]

Check out Marco's post: https://vborg.vbsupport.ru/showthread.php?t=170681#13