Please a DB & VB rookie needs help: error 1054

[sierruz]

Hi...

I just upgraded my VBulletin to 3.8.3 from 3.6.7, but I have MySql error somebody can help me? I'm a DataBases & Vbulletin Rookie... this is my error please help me...


Thanks & Regards...



Database error in vBulletin 3.8.3:

Invalid SQL:

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

MySQL Error : Unknown column 'moderation.primaryid' in 'on clause'
Error Number : 1054
Request Date : Wednesday, July 1st 2009 @ 11:07:48 PM
Error Date : Wednesday, July 1st 2009 @ 11:07:48 PM
Script : http://www.xxxxxxxxx.com/foro/admincp/index.php?do=home
Referrer : http://www.xxxxxxxxx.com/foro/admincp/index.php
IP Address : xxx.xxx.xxx.xxx
Username : Administrador
Classname : vb_database
MySQL Version : 5.0.67.d7-ourdelta-log