Vb 4.2.2 upgrade error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ronitdeep
    Member
    • Apr 2008
    • 50

    [Suite] Vb 4.2.2 upgrade error

    Hello,
    i was upgrading my forum from vb 3.8 to 4.2.2

    While this i got this error:
    What should i do?
    ----------------------------------

    An error has occurred with your database. Please contact vBulletin Support for assistance.

    Module: vbcms, Step 1 Database Error:1054

    Unknown column 'columns' in 'field list'

    Query:

    REPLACE INTO cms_grid
    (gridid, gridhtml, title, addcolumn, addcolumnsnap, addcolumnsize, `columns`, flattened)
    VALUES
    (1, '
    \n
    \n
    \n
    \n
    \n
    \n
    $column[1]
    \n
    \n
    \n
    $column[2]
    \n
    \n
    \n
    \n
    \n
    \n
    $column[3]
    \n
    \n
    \n
    \n', 'Two Columns + Sidebar (25%, 75%, 240px)', 1, 1, 3, 8, 0)
    Best Medical Forum
    http://cafemedico.net/

  • wda2015
    Senior Member
    • May 2001
    • 1135

    #2
    Should disable the plugin system and try again.
    Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

    Comment

    • ronitdeep
      Member
      • Apr 2008
      • 50

      #3
      i had disabled the plugin system before i started upgrading.
      is it such a complex issue?
      Nobody from vb has answered my ticket since last 24 hours in members area..
      Dont know really whats going on..
      Best Medical Forum
      http://cafemedico.net/

      Comment

      • wda2015
        Senior Member
        • May 2001
        • 1135

        #4
        What version PHP you got?. version vb4 is made for PHP 5.4
        Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

        Comment

        • Yves R.
          vBulletin QA
          • Nov 2003
          • 3861
          • 5.6.X

          #5
          Following the install script, it seems you already run the upgrade.php script multiple times. The step 1 is creating the cms_grid table and fill the data correctly but on step 8, it renames the column 'columns' by 'gridcolumns', which makes this error if it's rerun. You should try to rename 'gridcolumns' column by 'columns' and retry to do the upgrade.

          vBulletin QA - vBulletin Support French - Lead Project Tools developer

          Next release? Soon(tm)

          Comment

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