Invalid SQL Data Base error on Admincp and forum

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

Originally Posted by 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]

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

[BirdOPrey5]

Originally Posted by felixkomo

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