Invalid SQL Data Base error on Admincp and forum

[Naijasite]

I have data base error on my admin panel and my website homepage.

Though i mistakenly uninstall a product and it's script that i download.

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 do not really take note of the prouct i uninstalled. At moment i can't login to my admincp and the forum is showing Database error.

Ho do i fix this error?????

I have also disable all plugin using this procedure but my forum and cpanel is still not work.
To disable the plugin/hook system completely without accessing the Admin CP options, you need to edit includes/config.php and add the following code:
define('DISABLE_HOOKS', true);

[BirdOPrey5]

The error says phrasegroup_global is missing from the language table in your database.

If it was deleted by an uninstall that is a pretty major problem. If you have a database backup from before this happened this may be a time to use it.

[Naijasite]

I do not have my Database backup. Please how do i resolve this issue to enable my forum to start working.

[BirdOPrey5]

I would think maybe if you manually add the column phrasegroup_global back to the language table.

type: MEDIUMTEXT

Then maybe you can rebuild the language/phrases in admin cp- it may work- never tested.

[Naijasite]

I just done that the error is still the same.
I tried to run the upgrade script of 4.2.0 though am already using 4.2.0

But it was showing me that i have already upgraded . And i might need to delete the selected tables of Vbulletin.

But i do not proceed because i do not want it to affect my database post and registered user.

Please any other solution?????

[BirdOPrey5]

Do NOT DELETE ANY TABLES UNDER ANY CIRCUMSTANCES.

If you did add the column back to the table you could not possibly get the same error- so check/try again because if you have the same error something went wrong.

Upgrade will not help.

[Naijasite]

I have done that the error is still the same.
I jus Run SQL query for: Unknown column 'phrasegroup_global' in 'field list'

Result

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unknown column 'phrasegroup_global' in 'field list'' at line 1

Please regard to your previus post:
I would think maybe if you manually add the column phrasegroup_global back to the language table.

type: MEDIUMTEXT

Then maybe you can rebuild the language/phrases in admin cp- it may work- never tested.

I do not see any field to type in this :
type: MEDIUMTEXT

Please where do i insert it. Description please.

[borbole]

How exactly are you trying to run the query and what code are you using?

[Naijasite]

This is the new Database error am receiving on my email now
MySQL Error : Unknown column 'phrasegroup_posting' in 'field list'
Error Number : 1054

The code i use is: Unknown column 'phrasegroup_global' in 'field list'

[borbole]

Originally Posted by felixkomo

This is the new Database error am receiving on my email now
MySQL Error : Unknown column 'phrasegroup_posting' in 'field list'
Error Number : 1054

The code i use is: Unknown column 'phrasegroup_global' in 'field list'

You are using it wrong. You should run the following code. Copy/paste it in the sql box in the phpmyadmin at the db that your forum resides on.

 ALTER TABLE `language` ADD `phrasegroup_global` mediumtext;

If you use a custom prefix for your db tables, append it to the table name in the query above.