Announcement

Collapse
No announcement yet.

Missing DB field after upgrade to v2

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

  • Missing DB field after upgrade to v2

    I just upgraded, twice over, and get the same error. Perhaps this is an issue due to my blog being a vBlogetin conversion.

    The jist of the error message is:
    MySQL Error : Unknown column 'language.phrasegroup_vbblogcat' in 'field list'
    You can find it here: www.dragonninja.co.uk/blogs

    How can I create the column with the required contents?

    Thanks!
    www.dragonninja.co.uk - Wales' number one underground rock resource.

  • #2
    Did you remove or rename the vbolgetin tables before installing the Blog? By default they have the same table prefix that we use.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      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

      Comment


      • #4
        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

        Comment


        • #5
          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?
          www.dragonninja.co.uk - Wales' number one underground rock resource.

          Comment


          • #6
            You should do

            vBulletin QA - vBulletin Support French - Lead Project Tools developer

            Next release? Soon(tm)

            Comment


            • #7
              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

              Comment


              • #8
                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

                Comment


                • #9
                  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.

                  Comment


                  • #10
                    Sounds like you are using a table prefix and you need to add that prefix to the query.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      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?

                      Comment


                      • #12
                        Run this query:

                        ALTER TABLE vb_language ADD phrasegroup_vbblogcat MEDIUMTEXT

                        vBulletin QA - vBulletin Support French - Lead Project Tools developer

                        Next release? Soon(tm)

                        Comment


                        • #13
                          Originally posted by PitchouneN64ngc View Post
                          Run this query:

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

                          Comment


                          • #14
                            Sorry for the delay in stopping by again. I just ran the query and it worked for me too. Thanks so much.
                            www.dragonninja.co.uk - Wales' number one underground rock resource.

                            Comment


                            • #15
                              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
                              Community vBulletin Brasil & Portugal

                              Comment

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