Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 29 Jul 2012, 09:23
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Invalid SQL Data Base error on Admincp and forum

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);
Reply With Quote
  #2  
Old 29 Jul 2012, 11:19
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #3  
Old 29 Jul 2012, 11:23
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
I do not have my Database backup. Please how do i resolve this issue to enable my forum to start working.
Reply With Quote
  #4  
Old 29 Jul 2012, 11:44
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #5  
Old 29 Jul 2012, 12:04
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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?????
Reply With Quote
  #6  
Old 29 Jul 2012, 12:20
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #7  
Old 29 Jul 2012, 12:38
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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.
Reply With Quote
  #8  
Old 29 Jul 2012, 12:40
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
How exactly are you trying to run the query and what code are you using?
__________________
My mods.
Reply With Quote
  #9  
Old 29 Jul 2012, 12:49
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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'
Reply With Quote
  #10  
Old 29 Jul 2012, 12:51
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Originally Posted by felixkomo View Post
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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


If you use a custom prefix for your db tables, append it to the table name in the query above.
__________________
My mods.
Reply With Quote
  #11  
Old 29 Jul 2012, 12:54
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
You need to run this query:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

EDIT- borbole beat me to it.

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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #12  
Old 29 Jul 2012, 12:54
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
I just did that this the result i got:
#1060 - Duplicate column name 'phrasegroup_global'

Originally Posted by borbole View Post
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.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


If you use a custom prefix for your db tables, append it to the table name in the query above.
Reply With Quote
  #13  
Old 29 Jul 2012, 12:57
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Are you sure you are working the same database that your forum is running off of?
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #14  
Old 29 Jul 2012, 13:03
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Yes is my forum Database.

--------------- Added 29 Jul 2012 at 13:09 ---------------

any recommendation please...
Reply With Quote
  #15  
Old 29 Jul 2012, 13:13
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 13:23.

Layout Options | Width: Wide Color: