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]

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.

[BirdOPrey5]

You need to run this query:


ALTER TABLE `language` ADD `phrasegroup_global` MEDIUMTEXT NULL DEFAULT NULL AFTER `thousandsep`


EDIT- borbole beat me to it. :up:

I included the code to put it in the same location it used to be even though there is probably no reason that is necessary.

[Naijasite]

I just did that this the result i got:
#1060 - Duplicate column name 'phrasegroup_global'

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.

[BirdOPrey5]

Are you sure you are working the same database that your forum is running off of?

[Naijasite]

Yes is my forum Database.

--------------- Added 1343567383 at 1343567383 ---------------

any recommendation please...

[BirdOPrey5]

I'm stumped.

The error clearly says the column doesn't exist- at least from what vBulletin sees.

You MySQL error trying to run the ALTER command clearly says the column does exist.

And if you are sure it is the same database... I don't know what would cause this to happen.

[Naijasite]

thanks so much for trying to help. i have contacted vbulletin but no feedback from them yet.
Am stuck don't no what to do.

[borbole]

Indeed. The op is reporting conflicting messages. Make sure to run the query at the SQL box for the db that your forum with the db error resides on.

[ozzy47]

I can verify that it is indeed in there, here is a screenshot:

https://vborg.vbsupport.ru/

[Naijasite]

I just Run SQL query on SQL box, on my Forum SQL db where my forum reside.
ALTER TABLE `language` ADD `phrasegroup_global` mediumtext;

Result
#1060 - Duplicate column name 'phrasegroup_global'

Do you mind i pm you my login details so you could help resolve the problem?

--------------- Added 1343569371 at 1343569371 ---------------

wow thanks.. ok please help to correct the error.I can verify that it is indeed in there, here is a screenshot:

http://www.myfriendsspace.com/imagehosting/150153beed336c.png

[borbole]

I just Run SQL query on SQL box, on my Forum SQL db where my forum reside.
ALTER TABLE `language` ADD `phrasegroup_global` mediumtext;

Result
#1060 - Duplicate column name 'phrasegroup_global'



Then the db error you posted doesn''t make much sense if it is reporting that field missing when in fact that field exists. That is if it is indeed in the right db.

But if you submitted a ticket at your vb customer area then wait until the vb staff can have a look and see what is really going on.




Do you mind i pm you my login details so you could help resolve the problem?

You can pm me the details but I provide paid services only.

[BirdOPrey5]

Is there any content in the phrasegroup_global field if you browse the table?

[Naijasite]

remebered i said this is the error message that is been sent to me now on my email.

MySQL Error : Unknown column 'phrasegroup_posting' in 'field list'
Error Number : 1054

[BirdOPrey5]

OK well that is not the same error then. Do the same to put back phrasegoup_posting...


ALTER TABLE `language` ADD `phrasegroup_posting` MEDIUMTEXT NULL DEFAULT NULL

[ozzy47]

I did that Joe, but still a db error, I am waiting for him to tell me what the new error is now.

[Naijasite]

I just pm you login details now.
Attached is the screenshot of my phrasegroup

Thanks.

Is there any content in the phrasegroup_global field if you browse the table?

[BirdOPrey5]

I know it is for "security' purposes but it is really annoying that the database error doesn't show anymore. :(

[BirdOPrey5]

I just pm you login details now.
Attached is the screenshot of my phrasegroup

Thanks.

The attachment you sent is not from the language table...

Who else do you have in your Admin CP/Cpanel? I don't want to log in if other people are in there making changes.

[ozzy47]

Yeah it used to make things alot simpler.

--------------- Added 1343570585 at 1343570585 ---------------

I will not do anything Joe if you are going to log in and look.

[Naijasite]

The current DB error is

MySQL Error : Unknown column 'language.phrasegroup_holiday' in 'field list'
Error Number : 1054
Request Date : Sunday, July 29th 2012 @ 10:02:22 AM
Error Date : Sunday, July 29th 2012 @ 10:02:22 AM

Ozzy47 : is login to the cpanel. But he just said (I will not do anything Joe if you are going to log in and look.)

I did that Joe, but still a db error, I am waiting for him to tell me what the new error is now.

[BirdOPrey5]

From comparing it to my site there are literally dozens of phrase_groups missing.

[Naijasite]

current error:
MySQL Error : Unknown column 'phrasegroup_postbit' in 'field list'
Error Number : 1054
Request Date : Sunday, July 29th 2012 @ 10:07:17 AM
Error Date : Sunday, July 29th 2012 @ 10:07:17 AM

[ozzy47]

I don't see how that could have possibly happened from uninstalling any mod from his site.

Would it be possible to grab the phrase_groups from the vb install file and add all them back?

[BirdOPrey5]

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:


ALTER TABLE `language` ADD `phrasegroup_XXXXX` MEDIUMTEXT NULL DEFAULT NULL

[Naijasite]

Do you mean i should upload my vb 4.2.0 files to my server? I don't see how that could have possibly happened from uninstalling any mod from his site.

Would it be possible to grab the phrase_groups from the vb install file and add all them back?

[BirdOPrey5]

And in the future this is why you ALWAYS NEED BACKUPS.

[BirdOPrey5]

Do you mean i should upload my vb 4.2.0 files to my server?

No, not what I meant. Not what ozzy meant either.

[Naijasite]

Ok thanks
i will update this Post on every error i received
current error:

MySQL Error : Unknown column 'phrasegroup_postbit'' in 'field list'
Error Number : 1054

[BirdOPrey5]

Ozzy- short of doing them 1 by 1 my next guess would be to export the language table from a working vbulletin install (structure only),

then change the name of his language table to like language_temp

Import the new language table...

And then see if you can rebuild languages.

If so he should be OK except for 3rd party mods (like mine) that add their own phrase groups, those would have to be uninstalled and re-installed or their phrasegroups added back manually.

But that is a lot of effort for something that may not even work.

[ozzy47]

Check now

[Naijasite]

Current DB error:
Invalid SQL:
SELECT phrasegroup_contenttypes AS contenttypes,phrasegroup_global AS global,phrasegroup_vbcms AS vbcms,phrasegroup_search AS search
FROM language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_contenttypes' in 'field list'
Error Number : 1054

[ozzy47]

now?

[Naijasite]

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

[ozzy47]

and again

[Naijasite]

MySQL Error : Unknown column 'phrasegroup_inlinemod' in 'field list'
Error Number : 1054
Request Date : Sunday, July 29th 2012 @ 10:27:57 AM
Error Date : Sunday, July 29th 2012 @ 10:27:57 AM

[BirdOPrey5]

These are going to be all the phrasegroups you'll need to enter:

phrasegroup_cpglobal
phrasegroup_cppermission
phrasegroup_forum
phrasegroup_calendar
phrasegroup_attachment_image
phrasegroup_style
phrasegroup_logging
phrasegroup_cphome
phrasegroup_promotion
phrasegroup_user
phrasegroup_help_faq
phrasegroup_sql
phrasegroup_subscription
phrasegroup_language
phrasegroup_bbcode
phrasegroup_stats
phrasegroup_diagnostic
phrasegroup_maintenance
phrasegroup_profilefield
phrasegroup_thread
phrasegroup_timezone
phrasegroup_banning
phrasegroup_reputation
phrasegroup_wol
phrasegroup_threadmanage
phrasegroup_pm
phrasegroup_cpuser
phrasegroup_accessmask
phrasegroup_cron
phrasegroup_moderator
phrasegroup_cpoption
phrasegroup_cprank
phrasegroup_cpusergroup
phrasegroup_holiday
phrasegroup_posting
phrasegroup_poll
phrasegroup_fronthelp
phrasegroup_register
phrasegroup_search
phrasegroup_showthread
phrasegroup_postbit
phrasegroup_forumdisplay
phrasegroup_messaging
phrasegroup_inlinemod
phrasegroup_plugins
phrasegroup_cprofilefield
phrasegroup_reputationlevel
phrasegroup_infraction
phrasegroup_infractionlevel
phrasegroup_notice
phrasegroup_prefix
phrasegroup_prefixadmin
phrasegroup_album
phrasegroup_socialgroups
phrasegroup_advertising
phrasegroup_tagscategories
phrasegroup_contenttypes
phrasegroup_vbblock
phrasegroup_vbblocksettings
phrasegroup_ckeditor

[ozzy47]

Thanks Joe I will get going on that and see what happens

[Naijasite]

Current error:

MySQL Error : Unknown column 'phrasegroup_inlinemod' in 'field list'
Error Number : 1054
Request Date : Sunday, July 29th 2012 @ 10:47:57 AM
Error Date : Sunday, July 29th 2012 @ 10:47:57 AM

[BirdOPrey5]

I edited it to be line by line, may be easier on the eyes. :up:

[Naijasite]

current error Update;

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

[ozzy47]

Ok I added all of them, and it seems the forum is back up, go take a look

[Naijasite]

Yes the forum is running now, but no link on the forum are working...when you click on any link or tab its shows DB error

--------------- Added 1343574167 at 1343574167 ---------------

current error Update;
MySQL Error : Unknown column 'phrasegroup_prefix' in 'field list'

[ozzy47]

Anything further than that I don't know what to do, I tried going to language.php?do=rebuild&goto=language.php? but that of course is a db error

[Naijasite]

Anyway Thanks...that you were able to make the site to load.
But the form keep getting Database error when any link is click.

I will contact VB if there is anywah they could replace the files with their default setting.

Thanks alot

[BirdOPrey5]

What is the database error you get now? the one from language.php?

[ozzy47]

Can you load the tools.php file in you vBulletin download do_not_upload folder to your admincp folder, I can try something else possibly

[Naijasite]

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_ckeditor AS phrasegroup_ckeditor,
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 = 1;

MySQL Error : Unknown column 'language.phrasegroup_ckeditor' in 'field list'
Error Number : 1054

--------------- Added 1343575440 at 1343575440 ---------------

I just upload the Tools.php file to my admin CP now...alove

Can you load the tools.php file in you vBulletin download do_not_upload folder to your admincp folder, I can try something else possibly

[ozzy47]

Ok I added that, but I get a db error running language in tools.php also

[Naijasite]

Database error in vBulletin 4.2.0:

MySQL Error : Unknown column 'language.phrasegroup_language' in 'field list'
Error Number : 1054

[ozzy47]

I have no idea what that is, maybe Joe knows?

[BirdOPrey5]

Can you post the full error?

[Naijasite]

Current Error:

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_global = 'a:1227:{s:9:\"1_day_ago\";s:9:\"1 Day Ago\";s:10:\"1_hour_ago\";s:10:\"1 Hour Ago\";s:12:\"1_minute_ago\";s:12:\"1 Minute Ago\";s:7:\"1_reply\";s:7:\"1 reply\";s:10:\"1_week_ago\";s:10:\"1 Week Ago\";s:20:\"CurrentlyActiveUsers\";s:40:\"Currently Active Users Viewing this Page\";s:14:\"Edit_This_Page\";s:14:\"Edit This Page\";s:18:\"WT_EditWebtemplate\";s:16:\"Edit Webtemplate\";s:17:\"WT_Page_Visit_Log\";s:14:\"Page Visit Log\";s:14:\"a_closed_forum\";s:14:\"A Closed Forum\";s:6:\"accept\";s:6:\"Accept\";s:6:\"action\";s:6:\"Action\";s:14:\"active_members\";s:14:\"Active Members\";s:20:\"active_subscriptions\";s:20:\"Active Subscriptions\";s:14:\"add_as_contact\";s:14:\"Add as Contact\";s:13:\"add_as_friend\";s:13:\"Add as Friend\";s:15:\"add_new_folders\";s:15:\"Add New Folders\";s:16:\"add_subscription\";s:16:\"Add Subscription\";s:17:\"add_x_to_contacts\";s:25:\"Add %1$s to Your Contacts\";s:5:\"admin\";s:5:\"Admin\";s:19:\"admin_control_panel\";s:19:\"Admin Control Panel\";s:11:\"admin_login\";s:8:\"Admin CP\";s:23:\"admin_required_register\";s:129:\"The administrator may have required you to <a href=\"register.php?%1$s\" rel=\"nofollow\">register</a> before you can view this page.\";s:14:\"administrative\";s:14:\"Administrative\";s:29:\"administrator_decided_x_quiet\";s:85:\"The administrator

The error are too long to be posted...am still getting same error above but little diff.

--------------- Added 1343576635 at 1343576635 ---------------

I have uploaded the Tools.php...admincp was change to ---------

--------------- Added 1343577074 at 1343577074 ---------------

Datebase error
Its same as the above code

[BirdOPrey5]

im working on it now, please dont do anything.

[Naijasite]

Ok thanks bro

[BirdOPrey5]

You're back online. :up:

There were about 15 more phrase groups to add... then I did have to finish the upgrade that was previously started- that seems to have rebuilt the laguage... All phrases appear to be working now.

BACKUP YOUR DATABASE BEFORE YOU DO ANYTHING ELSE.

[ozzy47]

Excellent Joe, thanks for sticking through this with me and figuring out the issue.

[Naijasite]

Thanks so much. You should be in Vbulletin Team.
You actually get my board working after spending hours working on it...

I do not know hot to say thanks to YOU.

God bless you you and BirdOpre5 and Ozzy47,

You guys are guru am going to do my backup now.
Thanks

[BirdOPrey5]

You are welcome.

Ozzy did most of the work with getting all the phrase groups back.

I am on the vBulletin Support Team :)

You can thank me by making regular backups. ;)

[Naijasite]

Thanks so much Ozzy for fixing the errors and Thanks to BirdOprey5 for responding so fast.
You both wonderfull people.

I just did my backup now

[TheLastSuperman]

Do we know which product caused such behavior? Which product did you uninstall just before this error presented itself?

[Naijasite]

The product that cause the error are Vbquiz and VbNotification they are the two last product that i uninstalled.

They just broke my board but my forum is working well now.

But Ozzy and BirdOprey5 are wonderful guys, they stayed up to 3-2 hours to help me resolve the issue.

Very big thanks to them.


Do we know which product caused such behavior? Which product did you uninstall just before this error presented itself?

[BirdOPrey5]

TLS- The problem may be from those mods but the issue is there is no uninstall code in either mod that *should* cause this. If there was no doubt dozens, maybe hundreds of people would have complained by now. Something very rare and unusual happened and I can't figure it out either.

It also means there is no actual proof the uninstall was the specific cause.

However it is simply a lesson to everyone who you should always keep regular backups because you never know when something like this may happen.

Felixkomo got lucky that both Ozzy and I were around yesterday morning and happened to click on his threads. Most people will never be that lucky. Had he had a backup from the night before (some hosts offer hourly backups) he would have been back online in minutes without needing anyone's assistance.

[Naijasite]

Sure there is no prof that the modes was actually the cause, but i just assume so.
But i was so lucky to have these to Samaritan work it out for me without a penny.

I would actually do my backup everyday now.

TLS- The problem may be from those mods but the issue is there is no uninstall code in either mod that *should* cause this. If there was no doubt dozens, maybe hundreds of people would have complained by now. Something very rare and unusual happened and I can't figure it out either.

It also means there is no actual proof the uninstall was the specific cause.

However it is simply a lesson to everyone who you should always keep regular backups because you never know when something like this may happen.

Felixkomo got lucky that both Ozzy and I were around yesterday morning and happened to click on his threads. Most people will never be that lucky. Had he had a backup from the night before (some hosts offer hourly backups) he would have been back online in minutes without needing anyone's assistance.

[Naijasite]

Please i need your help....my Board just got broken like the previous problem.
I have my database Backup already. But my site is down at the moment.


I just uninstalled a mod Guest warn https://vborg.vbsupport.ru/showthread.php?t=270070
and am now receiving database error, my site is not working again.

I can't access my admincp and site, am getting database error.

I have disable all plugins through ftp config.php , but still gettin database error.
Please r help me to fix it, my site is down.

Please how do i fix this ? ww.naijafinder.com

MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
Error Number : 1054
Request Date : Sunday, August 19th 2012 @ 02:18:00 PM

Thanks in advance

[ozzy47]

I would restore the site from a backup you did before you uninstalled the mod.

[Naijasite]

@Ozzy47 I have my forum Backup available. If you don't mind i will pm you my login details.

Please reply....

[ozzy47]

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.

[Naijasite]

thanks alot for the assistance i have my logn details to you.

Current Database Error will be posted below:


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

--------------- Added 1345420230 at 1345420230 ---------------

MySQL Error : Table 'felix_naijafinder.language' doesn't exist

[ozzy47]

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:

ALTER TABLE `language` ADD `phrasegroup_XXXXX` MEDIUMTEXT NULL DEFAULT NULL

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

[Naijasite]

Updated Database Error

Unknown column 'phrasegroup_global' in 'field list'

--------------- Added 1345472469 at 1345472469 ---------------

Unknown column 'phrasegroup_global' in 'field list'

--------------- Added 1345475466 at 1345475466 ---------------

please are you still working on it?

--------------- Added 1345483744 at 1345483744 ---------------

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.