[Forum] Database errors

[M3xital]

After upgrading, I'm receiving this database errors:

Database error in vBulletin 4.0.0:

Invalid SQL:

                    SELECT languageid,
            phrasegroup_global AS phrasegroup_global,
            phrasegroup_video AS phrasegroup_video,
            phrasegroup_posting AS phrasegroup_posting,
            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 'phrasegroup_video' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, December 23rd 2009 @ 06:45:23 AM
Error Date    : Wednesday, December 23rd 2009 @ 06:45:23 AM
Script        : [URL]http://www.m3xital.com/forum/video.php[/URL]?
Referrer      : 
IP Address    : 67.218.116.164
Username      : 
Classname     : vB_Database
MySQL Version :

Database error in vBulletin 4.0.0:

Invalid SQL:

                    SELECT languageid,
            phrasegroup_global AS phrasegroup_global,
            phrasegroup_ecdownloads AS phrasegroup_ecdownloads,
            phrasegroup_posting AS phrasegroup_posting,
            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 'phrasegroup_ecdownloads' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, December 23rd 2009 @ 06:14:29 AM
Error Date    : Wednesday, December 23rd 2009 @ 06:14:29 AM
Script        : [URL]http://www.m3xital.com/forum/downloads.php[/URL]?
Referrer      : 
IP Address    : 67.218.116.164
Username      : 
Classname     : vB_Database
MySQL Version :

[Lynne]

Those are from a modification as there is no field phrasegroup_video or phrasegroup_ecdownloads in the language table in default vbulletin.

[M3xital]

Those are from a modification as there is no field phrasegroup_video or phrasegroup_ecdownloads in the language table in default vbulletin.

Thanks Lynne for your help,
I know the are from modifications, but how can i fix this.
Before upgrading i unistalled all the mods i had on 3.8.4., but didn't deleted files on server.

[ChopSuey]

Disable all hooks via config.php

[Lynne]

Check your includes/xml directory for extra files from modification. Uninstalling modifications means uninstalling the product AND removing all files that you had to upload for the modification.

[M3xital]

Check your includes/xml directory for extra files from modification. Uninstalling modifications means uninstalling the product AND removing all files that you had to upload for the modification.

Thanks Lynne!!

It worked, i deleted all files, in includes/xml, from old modifications. It also solved another problem i had here

[Lynne]

Glad it's fixed.