[Forum] Unknown column 'language.phrasegroupinfo' in 'field list' (Database error 4.0.6)

[NeilFawcett]

After an upgrade, we're getting this problem?

Anyone able to shed any light on the what might be the cause?

Thanks!

ps: The upgrade was post a hack to the forum where someone managed to obtain dozens of users' emails,username,passwords, and post them as a new thread on the forum!!! So we've re-installed the entire forum, and patching it upto the latest version.

<!-- 
Database error in vBulletin 4.0.6: 

Invalid SQL: 

        SELECT  
            userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, 
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, 
            language.phrasegroup_global AS phrasegroup_global, 
            language.phrasegroup_holiday AS phrasegroup_holiday, 
            language.phrasegroup_v3arcade AS phrasegroup_v3arcade, 
            language.phrasegroupinfo AS lang_phrasegroupinfo, 
            language.options AS lang_options, 
            language.languagecode AS lang_code, 
            language.charset AS lang_charset, 
            language.locale AS lang_locale, 
            language.imagesoverride AS lang_imagesoverride, 
            language.dateoverride AS lang_dateoverride, 
            language.timeoverride AS lang_timeoverride, 
            language.registereddateoverride AS lang_registereddateoverride, 
            language.calformat1override AS lang_calformat1override, 
            language.calformat2override AS lang_calformat2override, 
            language.logdateoverride AS lang_logdateoverride, 
            language.decimalsep AS lang_decimalsep, 
            language.thousandsep AS lang_thousandsep 
             
        FROM user AS user 

        LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) 
        LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))  
         
        WHERE user.userid = 2; 

MySQL Error   : Unknown column 'language.phrasegroupinfo' in 'field list' 
Error Number  : 1054 
Request Date  : Saturday, June 11th 2011 @ 03:26:56 PM 
Error Date    : Saturday, June 11th 2011 @ 03:26:56 PM 
Script        : http://forum.XXXXXXXXXXXXXXXXX.com/ 
Referrer      :  
IP Address    : XXX.XXX.XXX.XXX
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

[NeilFawcett]

Anyone? Please?

[Abhik]

Did you run the upgrade script?

domain/install/upgrade.php

[NeilFawcett]

Yes...

There is no phrasegroupinfo in language?

Is it a new'ish field?

[Paul M]

Yes, its a new field in 4.1.4 - actually added by the 4.1.4 Beta 1 Step.

Since your database error says 4.0.6, you have not (sucessfully) upgraded.

[NeilFawcett]

Yes, its a new field in 4.1.4 - actually added by the 4.1.4 Beta 1 Step.

Since your database error says 4.0.6, you have not (sucessfully) upgraded.

OK! Re-run the install... And now everything says 4.1.4, and the forum is working. But I had to manually create that field in LANGUAGE to be able to re-run the Install.

Can someone do me three favours:-

1) Look at their language table and tell me the definition for the field "phrasegroupinfo"?
Type?
Collation?
Attributes?
Null?
Default?
Extra?

2) My "phrasegroupinfo" field is the last field on the table, after "phrasegroup_ckeditor"...

3) Also do you have a field called "phrasegroup_"? I have one between "phrasegroup_plugins" & "phrasegroup_cprofilefield"

[fwulfers]

I just got the same error shortly after upgrading from 4.1.3 to 4.1.4. The upgrade script finished without any errors.

It shows 4.1.4 on my site: Powered by vBulletin® Version 4.1.4

Why would it show 4.1.3 in the error message?

Database error in vBulletin 4.1.3:

Invalid SQL:

                    SELECT languageid,
            phrasegroup_global AS phrasegroup_global,
            phrasegroup_posting AS phrasegroup_posting,
            phrasegroup_search AS phrasegroup_search,
            phrasegroup_socialgroups AS phrasegroup_socialgroups,
            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, June 15th 2011 @ 04:10:29 AM
Error Date    : Wednesday, June 15th 2011 @ 04:10:29 AM
Script        : http://saabworld.net/ajax.php
Referrer      : http://saabworld.net/content/
IP Address    : 66.249.71.80
Username      : 
Classname     : vB_Database
MySQL Version :

[ouranos43]

I have the same error after upgrading from 4.1.3 to 4.1.4. The upgrade script finished without any errors.

Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_postbit AS phrasegroup_postbit,
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 = 2;

MySQL Error   : Unknown column 'phrasegroupinfo' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, June 15th 2011 @ 02:33:10 AM
Error Date    : Wednesday, June 15th 2011 @ 02:33:10 AM
Script        : 
Referrer      : 
IP Address    : 72.14.199.132
Username      : 
Classname     : vB_Database
MySQL Version :

[MEsh3L85]

I upgraded from 4.1.3 to 4.1.4 without any problem .

did you disable Plugin/Hook System before upgrading ?

[ouranos43]

yes i disable Plugin/Hook

[Paul M]

Why would it show 4.1.3 in the error message?

Because the 414 beta 1 & main steps have not run, which is why you also get the database error, that field is added by the b1 step.

[fwulfers]

It sounds like it's nothing to be concerned about then. During the upgrade, I was actually getting a lot of other database errors when I was uploading the new 4.1.4 files. The site showed the Database Error messages instead of the usual "Site is unavailable" message after I closed the forum. But all was good after I ran the upgrade.php script.

[dbetanco]

It sounds like it's nothing to be concerned about then. During the upgrade, I was actually getting a lot of other database errors when I was uploading the new 4.1.4 files. The site showed the Database Error messages instead of the usual "Site is unavailable" message after I closed the forum. But all was good after I ran the upgrade.php script.

I just have the same problem. Downloaded the full package, rename the UPLOAD folder to the folder on my web (forum for example), zip the renamed folder and upload to the hosting. Extract and then domain/forum/install/upgrade.php

after perform steps required and some minuts everything works fine and upgrade complete