Bug Data base error (MySQL Error : Unknown column 'phrasegroup_global' in 'field list')

I have data base error on my admincp and my website homepage.
my site is completely unaccessable

I do not know the plugin that i uninstalled

Please how do i fix this error some website can start working

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_showthread AS phrasegroup_showthread,
phrasegroup_inlinemod AS phrasegroup_inlinemod,
phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
phrasegroup_bop5iframer AS phrasegroup_bop5iframer,
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 language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
Error Number : 1054
Request Date : Saturday, July 28th 2012 @ 09:58:36 PM
Error Date : Saturday, July 28th 2012 @ 09:58:36 PM
Script : http://www.naijafinder.com/nigeria-u...ic-season.html
Referrer :
IP Address : 74.125.78.82
Username :
Classname : vB_Database
MySQL Version :


I have also follow the description below, on phrasetype table i see fildname global. there is no vbquize on the product filed. What is the Solution
Please help
Originally Posted by Dylan
Hi Jem,
Do you have mysql access through something like phpmyadmin or something like it?

It sounds like somehow your global phrase group got associated with the quiz mod.

You can verify it by logging into phpmyadmin and view the data in the phrasetype table.


In there is a row with the fieldname of global. The product for that row should be blank but it sounds like it might have dbtech_vbquiz in there. If it does you can clear that out and it should uninstall fine.

Here is how it probably looks

Attachment 1354

And here is how it should look

Attachment 1355

Looks to me like that error is from one of BirdOPrey5 mods, most lily this one, IFRAMEr (Free) by BOP5 - Easily create IFRAMEs in your forums to external pages - vBulletin.org Forum

I just uninstalled a mod Guest Warn and am now receiving database error, my site is not working again.

I can't access my admincp and site, am getting database error. MySQL Error : Unknown column 'phrasegroup_global' in 'field list'

I have also uploaded the default Vbulletin files and i have run the upgrade script.

I have added this define('DISABLE_HOOKS', true); line right under <?php .

But my forum is still not working am still getting database error. I can't access the forum and Admincp



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 = 1;

MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
Error Number : 1054
Request Date : Sunday, August 19th 2012 @ 05:13:10 PM
Error Date : Sunday, August 19th 2012 @ 05:13:10 PM


I believe you might be able to help me resolve the issue, because you seems to be the only hope to get my forum to start working.

Thanks in advance

Did you make a backup of your site before you uninstalled the mod?

Yes i made backup of my database and this is the backup path www.naijafinder.com/public_html/naijafinder.com
When you login to my cpanel you will see the backup database on this folder naijafinder.com.
I have pm my login details to you on Vbulletin.org

Thanks so much. I will be online to update you if you like i did before.

It is much easier to use the backup, last time you had this issue, it took over 2 hrs to resolve, a backup will take just a few minutes. This is something though I can not help with though.

I have my Backup available the Backup is on this www.naijafinder.com/public_html/naijafinder.com
Please just help me to fix it...

Thanks alot

please will the error be fix soon?

It will take hours to add fields 1 by 1 waiting for you to say what the next database error is.

I suggest you start doing them yourself, 1 by 1, it is not difficult.

Each time you get a new error you just replace the phrasegroup_XXXX from the error into the ALTER statement:


I tried a few different things but to no avail, so your only option is above.

Thanks alot am really seeing your effort in trying to fix it, you are 1 in a million

Unknown column 'phrasegroup_global' in 'field list'

If it doesn't work maybe i will just install fresh Vbulletin and start from scratch.
Vbulletin staff are not helping to resolve the issue at all. They rather keep asking question and nothing has been done.
Ozzy47 thanks for all your effort. Please let me know when you are done.

Thanks.