Invalid SQL database error
 

I successfully upgraded to the latest version of Vbulletin and the forum came up as a white background with no theme and no content. The I mistakenly imported imported a backup from a older SQL and thats when I received this error. I messed up bad and didn't backup the forum before upgrading thinking the content was stored in a folder automatically.

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_wol AS phrasegroup_wol,
phrasegroup_user AS phrasegroup_user,
phrasegroup_messaging AS phrasegroup_messaging,
phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroupinfo' in 'field list'
Error Number : 1054
Request Date : Wednesday, July 6th 2011 @ 08:53:22 AM
Error Date : Wednesday, July 6th 2011 @ 08:53:22 AM
Script : http://www.atlnightspots.com/forum/member.php?u=14
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

--------------- Added [DATE]1310138503[/DATE] at [TIME]1310138503[/TIME] ---------------

Before I imported the back sql this was the error I received when I 1st upgraded..

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_timezone AS phrasegroup_timezone,
phrasegroup_user AS phrasegroup_user,
phrasegroup_register AS phrasegroup_register,
phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroupinfo' in 'field list'
Error Number : 1054
Request Date : Monday, July 4th 2011 @ 10:13:33 AM
Error Date : Monday, July 4th 2011 @ 10:13:34 AM
Script : http://www.atlnightspots.com/forum/register.php
Referrer : http://www.atlnightspots.com/page/2
IP Address :
Username :
Classname : vB_Database
MySQL Version :

And if you look at your language table, do you see the field "phrasegroupinfo"? If not, you will need to add it.

From mysql-schema.php for 4.1.4:

Ok It was missing cause I read some where when the install is complete delete the install folder.

That would have nothing to do with a field missing since you don't delete the install.php file until the upgrade is complete. The upgrade is what adds the field.