[Forum] Database error in vBulletin 4.1.12 Patch Level 2

[Uber_Tiny]

Ever since I tried updating to 4.2 (with horrible results thanks to the "improved" activity crap added to 4.2) I have been getting an SQL error report sent to me with the same information over and over. This doesn't make any sense being that I reverted back to known good working installations of both the files and the DB. I'm thinking this was added in to 4.1.12 path level 2. Either way, I would like it to be resolved, but I cannot seem to figure out what needs to be done to get rid of this error. I'm not even finding any information online about it. Hopefully one of you smarter individuals here can help me out, thank you.

Database error in vBulletin 4.1.12:

Invalid SQL:


                    SELECT languageid,
            phrasegroup_global AS phrasegroup_global,
            phrasegroup_activitystream AS phrasegroup_activitystream,
            phrasegroup_user AS phrasegroup_user,
            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 vb_g3dlanguage
                    WHERE languageid = 1;


MySQL Error   : Unknown column 'phrasegroup_activitystream' in 'field list'


Script: /activity.php?sortby=recent&show=all&time=anytime

[Wayne Luke]

This error would be caused by uploading vBulletin 4.2.0 files and not running the upgrade. You cannot mix and match files from different versions. Please upload all vBulletin 4.2.0 files and then go through the proper upgrade procedure.

[Uber_Tiny]

That's the issue. I reverted back to known working 4.10 saved files when I found major compatibility issues with my design and 4.2. The error I get didn't start happening till recently and it's been months since I reverted back to saved files. Why would I all of the sudden be getting these errors and how can I get rid of them without upgrading to 4.2?

EDIT: When running upgrade.php it is running the upgrade for 4.1.12, not 4.2. Should I just run this upgrade once more?

[Wayne Luke]

You have some file for 4.2.0 on your server. We don't support reverting back to an older version because issues like this will occur.

vBulletin 4.2.0 shouldn't create issues with your style that aren't also in 4.1.12. What were your issues?

[Uber_Tiny]

I will run a test installation/upgrade to show what happened. You can see my current site at geforce3d.net to see the extent of the style customization.

[Matthew Gordon]

"Script: /activity.php?sortby=recent&show=all&time=anytime"

Simple fix for this specific error: delete activity.php from your server as it is introduced in 4.2.0 and wasn't present in 4.1.12.