Invalid SQL Data Base error on Admincp and forum

[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'

Originally Posted by borbole

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 [DATE]1343567383[/DATE] at [TIME]1343567383[/TIME] ---------------

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:

[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 [DATE]1343569371[/DATE] at [TIME]1343569371[/TIME] ---------------

wow thanks.. ok please help to correct the error.

Originally Posted by ozzy47

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

[borbole]

Originally Posted by felixkomo

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.

Originally Posted by felixkomo

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.