Database error

[p30suite]

Hello
One of the webmasters, goes to the plugins section and delete one of plugins
this plugin about with "hide exit link for ban"
After this,Site have a problem and show Database Error
This error can be seen in the page's adminCp

Please Help me

http://forum.p30suite.ir

[ForceHSS]

<!--
Database error in vBulletin 4.1.6:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_holiday AS phrasegroup_holiday,
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 = 4;

MySQL Error : Unknown column 'phrasegroup_global' in 'field list'
Error Number : 1054
Request Date : Saturday, April 21st 2012 @ 06:44:52 AM
Error Date : Saturday, April 21st 2012 @ 06:44:52 AM
Script : http://forum.p30suite.ir/
Referrer :
IP Address : hidden
Username :
Classname : vB_Database
MySQL Version :
-->
here is your problem

[blind-eddie]

If the plugin about with "hide exit link for ban" was an addon, simple re-upload xml for that modification, the plugin will get re-added.

[p30suite]

If the plugin about with "hide exit link for ban" was an addon, simple re-upload xml for that modification, the plugin will get re-added.

this error showen in AdminCp page too and cant re-add this plugin :(

--------------- Added 1334994544 at 1334994544 ---------------

please help me :(

[blind-eddie]

Via FTP edit your includes/config.php and add the following code just below <?php (1st line)

This is what your edit should look like:
<?php
define('DISABLE_HOOKS', true);


This will disable all products. Login to your site & fix or remove product that is causing said issue. Once you do that, edit the config.php & remove that line of code you added.

[p30suite]

i added this line to config.php
define('DISABLE_HOOKS', true);

But there was no change :(

[blind-eddie]

Just below <?php , right?

Then your issue is not due to any addon plugin being removed.
You will need to contact your host and request a database backup to be installed.
Just make sure the backup is dated before the start date of this issue.
You will be good to go after that.

[p30suite]

yes i added this line below <?php

My backup is too old :((

The problem is the language

is problem slove with upgrade to newer version?

[blind-eddie]

How old is to old?
Doing so will bring your site back up?

[p30suite]

2011 !:eek::(

upgrade ?

[blind-eddie]

What date in 2011 is the backup from?

I am not sure if upgrading will fix your issue, as I truely don't know what was done to your site to cause this issue.
If your site is not very busy & you think you will not lose many threads/post installing the database backup then I would suggest installing it.

I would suggest submitting a ticket on vbulletin.com & explain to support staff exactly what was done to your site to cause this issue & see if they can offer a better solution.
Also, link them to this thread for a quicker understanding of your issue.

In the future, create a copy of your database daily or weekly just in case issues like this come up.

[Lynne]

When you removed the plugin, did you also remove all files from the site that were added for the modification? If you aren't sure, then please go redownload the modification and go through the installation instructions backwards.