Please a DB & VB rookie needs help: error 1054
 

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

Looks like the upgrade failed to either update or change all the tables when you ran the script.

I'd suggest issuing a support ticket at vb.com or if your feeling frisky, edit and find that in the upgrade scripts and run the query the installed failed and run it your self in PMA or the admincp.

Ok.... thanks... I'm checking with VB support