Announcement

Collapse
No announcement yet.

Missing DB field after upgrade to v2

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    You are missing one of the default vB tables. Please start your own thread with all the relevant details. Thank you.

    Leave a comment:


  • barroca
    replied
    Unfortunately don't works in my install
    the sql returns
    Um erro ocorreu enquanto tentava executar sua consulta. A seguinte informação foi retornada.
    número do erro: 1146
    descrição do erro: Table 'xtrad_vb2.vb_language' doesn't exist
    the blogs section is offline!

    if you can help ... tks!
    joao barroca

    Leave a comment:


  • slavetothename
    replied
    Sorry for the delay in stopping by again. I just ran the query and it worked for me too. Thanks so much.

    Leave a comment:


  • Frogfish
    replied
    Originally posted by PitchouneN64ngc View Post
    Run this query:

    ALTER TABLE vb_language ADD phrasegroup_vbblogcat MEDIUMTEXT
    That did it!
    Thank you very much!

    Leave a comment:


  • Yves Rigaud
    replied
    Run this query:

    ALTER TABLE vb_language ADD phrasegroup_vbblogcat MEDIUMTEXT

    Leave a comment:


  • Frogfish
    replied
    Could you leed me in the right direction?

    This is the error I get when using the blog
    Code:
    Invalid SQL:
    
    					SELECT languageid,
    			phrasegroup_global AS phrasegroup_global,
    			phrasegroup_posting AS phrasegroup_posting,
    			phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
    			phrasegroup_postbit AS phrasegroup_postbit,
    			phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
    			phrasegroup_inlinemod AS phrasegroup_inlinemod,
    			phrasegroup_prefix AS phrasegroup_prefix,
    			phrasegroup_adv_gallery AS phrasegroup_adv_gallery,
    			options AS lang_options,
    			languagecode AS lang_code,
    			charset AS lang_charset,
    			locale AS lang_locale,
    			imagesoverride AS lang_imagesoverride,
    			dateoverride AS lang_dateoverride,
    			timeoverride AS lang_timeoverride,
    			registereddateoverride AS lang_registereddateoverride,
    			calformat1override AS lang_calformat1override,
    			calformat2override AS lang_calformat2override,
    			logdateoverride AS lang_logdateoverride,
    			decimalsep AS lang_decimalsep,
    			thousandsep AS lang_thousandsep
    					FROM vb_language
    					WHERE languageid = 5;
    
    MySQL Error   : Unknown column 'phrasegroup_vbblogcat' in 'field list'
    Error Number  : 1054
    If I try to run this Quiery:
    ALTER TABLE language ADD phrasegroup_vbblogcat MEDIUMTEXT
    I get this error message..

    Code:
    An error occurred while attempting to execute your query. The following information was returned. 
    error number: 1146 
    error desc: Table 'mysite_no3.language' doesn't exist
    Where do i need to search to find the correct table prefix that i am suposed to miss?

    Leave a comment:


  • Steve Machol
    replied
    Sounds like you are using a table prefix and you need to add that prefix to the query.

    Leave a comment:


  • Frogfish
    replied
    I tried to run the Run thequery:
    but got thiss error message:

    Code:
    An error occurred while attempting to execute your query. The following information was returned. 
    error number: 1146 
    error desc: Table 'mysite_no3.language' doesn't exist
    upgraded from latest stable relase to Blog v2.0.0 b3 I am running Vb 7.3
    I had no error messages before the upgrade.

    Leave a comment:


  • Tigratrus
    replied
    Sorry I didn't get back to this earlier, took a while to get the testbed rebuilt, then something went south and I got to do it again!

    Anyway, the query worked for us too.

    ::thumbs up::

    Now to start playing with it so we can get a feel for it... Thanks Freddie!

    James and Susan

    Leave a comment:


  • dodgeboard.com
    replied
    Unknown column 'language.phrasegroup_vbblogcat' in 'field list'

    I had the same problem, ran the query, and that fixed it. Never had vBlogoten.

    Thanks Freddie!

    VB 3.7.3
    Blog v2.0.0 b3

    Leave a comment:


  • Yves Rigaud
    replied
    You should do

    Leave a comment:


  • slavetothename
    replied
    I stopped using vBlogetin almost a year ago, as far as I know all traces of that are long gone.

    It was an upgrade to Beta 3 from the latest stable 1.x version. Should I still run the query Freddie?

    Leave a comment:


  • Freddie Bingham
    replied
    Did you do a new install of beta 3? I think I see what the problem is.

    Run this query:

    ALTER TABLE language ADD phrasegroup_vbblogcat MEDIUMTEXT

    Leave a comment:


  • Tigratrus
    replied
    I ran into the same problem on our testbed. All sorts of DB inconsistencies and problems. And you can't run the upgrade a second time as it fails if the tables it wants to create are already there, or if the changes it wants to make to existing tables have already been made.

    We too are running a vBlog DB that had data pulled in from vBlogetin via Impex. And yes, all vBlogetin tables were renamed/removed. We're up and running fine on vBlog 1.05, though impex left some orphan records behind.

    I think it might be a good idea to have a DB validation tool that can be run before you try and upgrade? The vBlog 2.0 B3 upgrade process makes a *LOT* of DB changes, and if it doesn't work perfectly the first time you appear to be up the proverbial creek... That's why I always do upgrades on the testbed first .

    BTW, I did put a bug report in on what we saw as a heads up to Freddie. Will follow-up with a more detailed breakdown once I have a chance to rebuild the testbed, it's gotten out of sync with the live site.

    James and Susan

    Leave a comment:


  • Steve Machol
    replied
    Did you remove or rename the vbolgetin tables before installing the Blog? By default they have the same table prefix that we use.

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X