[Naijafinder]

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:

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

[Naijafinder]

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.

[Naijafinder]

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

[Naijafinder]

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

[ozzy47]

now?

[Naijafinder]

MySQL Error : Unknown column 'phrasegroup_search' in 'field list'

[ozzy47]

and again

[Naijafinder]

MySQL Error : Unknown column 'phrasegroup_inlinemod' in 'field list'
Error Number : 1054
Request Date : Sunday, July 29th 2012 @ 10:27:57 AM
Error Date : Sunday, July 29th 2012 @ 10:27:57 AM

[BirdOPrey5]

These are going to be all the phrasegroups you'll need to enter:

phrasegroup_cpglobal
phrasegroup_cppermission
phrasegroup_forum
phrasegroup_calendar
phrasegroup_attachment_image
phrasegroup_style
phrasegroup_logging
phrasegroup_cphome
phrasegroup_promotion
phrasegroup_user
phrasegroup_help_faq
phrasegroup_sql
phrasegroup_subscription
phrasegroup_language
phrasegroup_bbcode
phrasegroup_stats
phrasegroup_diagnostic
phrasegroup_maintenance
phrasegroup_profilefield
phrasegroup_thread
phrasegroup_timezone
phrasegroup_banning
phrasegroup_reputation
phrasegroup_wol
phrasegroup_threadmanage
phrasegroup_pm
phrasegroup_cpuser
phrasegroup_accessmask
phrasegroup_cron
phrasegroup_moderator
phrasegroup_cpoption
phrasegroup_cprank
phrasegroup_cpusergroup
phrasegroup_holiday
phrasegroup_posting
phrasegroup_poll
phrasegroup_fronthelp
phrasegroup_register
phrasegroup_search
phrasegroup_showthread
phrasegroup_postbit
phrasegroup_forumdisplay
phrasegroup_messaging
phrasegroup_inlinemod
phrasegroup_plugins
phrasegroup_cprofilefield
phrasegroup_reputationlevel
phrasegroup_infraction
phrasegroup_infractionlevel
phrasegroup_notice
phrasegroup_prefix
phrasegroup_prefixadmin
phrasegroup_album
phrasegroup_socialgroups
phrasegroup_advertising
phrasegroup_tagscategories
phrasegroup_contenttypes
phrasegroup_vbblock
phrasegroup_vbblocksettings
phrasegroup_ckeditor