After the upgrade to VB3.7 I'm getting a database error. Can someone help me on how to fix this please.
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
Request Date : Wednesday, April 30th 2008 @ 11:35:39 AM
Error Date : Wednesday, April 30th 2008 @ 11:35:40 AM
Script : http://www.tmgrs.co.uk/forum/index.php
Referrer : http://www.tmgrs.co.uk/forum/index.php
IP Address : **.**.**.**
Username : Martin
Classname : vB_Database
MySQL Version : 5.1.22-rc-community
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
Request Date : Wednesday, April 30th 2008 @ 11:35:39 AM
Error Date : Wednesday, April 30th 2008 @ 11:35:40 AM
Script : http://www.tmgrs.co.uk/forum/index.php
Referrer : http://www.tmgrs.co.uk/forum/index.php
IP Address : **.**.**.**
Username : Martin
Classname : vB_Database
MySQL Version : 5.1.22-rc-community
Comment