Error displayed on CP homepage....

[Tim Mousel]

Hi,

Here is my error:

Database error in vBulletin 3.7.0 Beta 3:
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 forum.moderation.postid' in 'on clause'
Error Number : 1054
Date : Friday, January 11th 2008 @ 03:31:36 PM
Script : http://www.defend.net/deluxeforums/cpad/index.php?do=home
Referrer : http://www.defend.net/deluxeforums/cpad/index.php?do=nav
IP Address : 98.201.11.209
Username : Tim Mousel
Classname : vb_database
MySQL Version : 4.0.24

Please advise.

Thanks,

Tim

[Tim Mousel]

Please disregard as I no longer have this issue.

Tim

[Stevo]

That's great Tim, I have the same problem, could you help me or could anyone else help me with this error/problem.
Thanks

[Tim Mousel]

Hi,

Sorry, I'm just seeing this now. I can't remember exactly but I think it had to do with uninstalling zoints from the products. If that isn't it, I used to have my admin cp at /forums/cpad and I had changed it to /forums/admincp/. I think the old url was giving that error but not the new one with the new updated files.

Hope that helps!!

Tim