Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Jul 2011, 15:15
atlnightspots atlnightspots is offline
 
Join Date: Nov 2009
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 08 Jul 2011 at 15:21 ---------------

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 :

Last edited by atlnightspots : 08 Jul 2011 at 15:22.
Reply With Quote
  #2  
Old 08 Jul 2011, 16:58
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 08 Jul 2011, 17:54
atlnightspots atlnightspots is offline
 
Join Date: Nov 2009
Ok It was missing cause I read some where when the install is complete delete the install folder.
Reply With Quote
  #4  
Old 08 Jul 2011, 20:34
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 06:47.

Layout Options | Width: Wide Color: