Database error

[ExTincTi0N]

Okay here is the deal.
When ever my other two admins and i try to edit one of our threads it takes us to a page saying Database error and all of that stuff.
My site is not open yet so we dont have to worry about it happening to members.
But can you please tell me whats wrong and how to fix it.

[snunhuck]

Can you provide the error details/output? It is sent to the webmaster's/ tehc support email.

[ExTincTi0N]

Ok one sec
Edit: It dosnt seem i have recieved one.

[SEOvB]

view the page source (the database error page) and post here.

This is most liekly due to a plugin however, try to disable all plugins first and then trying again.

[ExTincTi0N]

A plugin or a product?

--------------- Added 1206147575 at 1206147575 ---------------

Sorry about the doublepost, but i un pluged everything since we only had four products and such and its still happening and i have not recieved a email.

[snunhuck]

Ok, when you get the error, view the source of the page, then post the following information (given in the source):

Database error in vBulletin :

MySQL Error :
Error Number :
Date :
Script :
Referrer :
IP Address :
Username :
Classname :
MySQL Version :

[ExTincTi0N]

Ummmm well im kinda of a noob if you would like you could download teamvewier so you can see what happens.

[Lynne]

To view the source in firefox, you go to View > Page Source (apple + U on a Mac, maybe control + U on a PC?). Near the bottom of the page will be the database error. Just copy/paste it here.

[ExTincTi0N]

Ok, here is what i got.

MySQL Error : Unknown column 'language.phrasegroup_prefix' in 'field list'
Error Number : 1054
Date : Friday, March 21st 2008 @ 11:12:30 PM
Script : http://eastudios.org/editpost.php?do=editpost&p=16
Referrer : http://eastudios.org/showthread.php?p=16
IP Address : 71.51.33.1
Username :
Classname : vb_database

This is happening to everybody on the site.

[Lynne]

That's just fine. The error is here:
MySQL Error : Unknown column 'language.phrasegroup_prefix' in 'field list'

However, there is no column 'phrasegroup_prefix'' in default vbulletin, so as suggested above, you have a plugin installed that is causing this error.

I would try turning the plugins off through the config file by adding this someplace after the first line:
define('DISABLE_HOOKS', true);

See if that fixes the problem.

[ExTincTi0N]

Ok but i took out every plugin/product on the site.

--------------- Added 1206160146 at 1206160146 ---------------

Ok sorry about the double post, but when ever i upload a plugin after that fixes it wont they not work.

--------------- Added 1206170230 at 1206170230 ---------------

Sorry for double post but nothing worked im just gunna make a back up of everything except the products and plugins and reupload it. Thank you guys for your help.

[snunhuck]

Did you uninstall (the plugins/products) before remoming them?

[ExTincTi0N]

Yes i uninstalled them before removing them.

[snunhuck]

What plugins did you used to have?

[Lynne]

Check your includes/xml folder and see if you have any extra xml files in there from a mod.

[ExTincTi0N]

We fixed it.
I had to re-upload vB and all of that but its fixed now.