Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #31  
Old 29 Jul 2012, 15:08
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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
Reply With Quote
  #32  
Old 29 Jul 2012, 15:09
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
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?
Reply With Quote
  #33  
Old 29 Jul 2012, 15:13
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.

__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #34  
Old 29 Jul 2012, 15:13
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
Do you mean i should upload my vb 4.2.0 files to my server?
Originally Posted by ozzy47 View Post
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?
Reply With Quote
  #35  
Old 29 Jul 2012, 15:13
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
And in the future this is why you ALWAYS NEED BACKUPS.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #36  
Old 29 Jul 2012, 15:14
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by felixkomo View Post
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #37  
Old 29 Jul 2012, 15:14
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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
Reply With Quote
  #38  
Old 29 Jul 2012, 15:17
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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.
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.
Reply With Quote
  #39  
Old 29 Jul 2012, 15:18
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
Check now
Reply With Quote
  #40  
Old 29 Jul 2012, 15:18
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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
Reply With Quote
  #41  
Old 29 Jul 2012, 15:20
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
now?
Reply With Quote
  #42  
Old 29 Jul 2012, 15:21
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
MySQL Error : Unknown column 'phrasegroup_search' in 'field list'
Reply With Quote
  #43  
Old 29 Jul 2012, 15:22
ozzy47's Avatar
ozzy47 ozzy47 is offline
 
Join Date: Aug 2009
Real name: Chris
and again
Reply With Quote
  #44  
Old 29 Jul 2012, 15:24
Naijasite's Avatar
Naijasite Naijasite is offline
 
Join Date: Mar 2012
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
Reply With Quote
  #45  
Old 29 Jul 2012, 15:27
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
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
__________________
-Joe
Former vb.org Moderator. Retired.

@BirdOPrey5 | All Things BOP5 | Joe's Ultimate Off Topic
Note - I no longer making new VB mods, sorry.

Last edited by BirdOPrey5; 29 Jul 2012 at 15:47.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:10.

Layout Options | Width: Wide Color: