Error upgrading to 4.1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ramta
    New Member
    • Aug 2006
    • 11
    • 3.7.x

    [Suite] Error upgrading to 4.1

    Database error in vBulletin 4.1.0 Beta 1
    Invalid SQL: REPLACE INTO setting (varname, grouptitle, value, datatype,default_value)VALUES('socnet', 'user', '', 'integer' ,'63');

    MySQL Error : Unknown column 'default_value' in 'field list'
    Error Number : 1054
    Request Date : Thursday, December 2nd 2010 @ 04:26:44 PM
    Error Date : Thursday, December 2nd 2010 @ 04:26:44 PM
    Script : http://www.xxxxxx.com/foro/install/upgrade.php
    Referrer : http://www.dxxxxxxxx.com/foro/install/upgrade.php
    Classname : vB_Database
    MySQL Version : 5.0.91-community
  • echamberlain
    Member
    • Aug 2006
    • 30
    • 3.6.x

    #2
    We are getting the same error after re-uploaded the new files and restored the database a few times. We are upgrading from 4.0.8.

    Comment

    • Lynne
      Former vBulletin Support
      • Oct 2004
      • 26255

      #3
      This is a bug. http://tracker.vbulletin.com/browse/VBIV-10448

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help

      Comment

      • Boofo
        Senior Member
        • Apr 2002
        • 2033
        • 4.1.x

        #4
        The error code is still there in 4.1.0 PL1. Should we change it before upgrading to PL1 then? I am currently on 4.0.6.
        vBulletin - Sometimes, I'm just like, Wow, and then I'm like, Whoa, and then I'm like, Damn.

        vBulletin.org's ol' Moderator

        I have a lifetime terrorist hunting permit - #091101

        chmod a+x /bin/laden -- Allows anyone the permission to execute /bin/laden

        Comment

        • ramta
          New Member
          • Aug 2006
          • 11
          • 3.7.x

          #5
          Database error in vBulletin 4.1.0

          Invalid SQL: INSERT INTO setting (varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product) VALUES ( 'socnet', 'user', '1', '63', 'bitfield', 'bitfield:misc|socnet', 1, 0, 1, '', 0, 'vbulletin' ), ( 'reqbirthday', 'user', '0', '0', 'boolean', 'yesno', 5, 0, 1, '', 0, 'vbulletin' ), ( 'ctMaxChars', 'user', '25', '25', 'integer', '', 10, 0, 1, '', 0, 'vbulletin' ), ( 'ctCensorWords', 'user', 'admin forum moderator vbulletin leader', 'admin forum moderator vbulletin leader', 'free', 'textarea', 20, 0, 1, '', 0, 'vbulletin' ), ( 'ctCensorMod', 'user', '1', '1', 'boolean', 'yesno', 30, 0, 1, '', 0, 'vbulletin' ), ( 'minifriends_amount', 'user', '6', '6', 'integer', '', 30, 0, 1, '', 0, 'vbulletin' ), ( 'friends_per_page', 'user', '10', '10', 'posint', '', 40, 0, 1, 'return (intval($raw_data) > 0);', 0, 'vbulletin' ), ( 'profilemaxvisitors', 'user', '10', '10', 'integer', '', 50, 0, 1, 'return ($data >= 2);', 0, 'vbulletin' ), ( 'profilelastpost', 'user', '', '', 'boolean', 'yesno', 60, 0, 1, '', 0, 'vbulletin' ), ( 'profileprivacy', 'user', '1', '1', 'boolean', 'yesno', 90, 0, 1, '', 0, 'vbulletin' ), ( 'softlinebreakchars', 'user', '90', '90', 'integer', '', 110, 0, 1, '', 0, 'vbulletin' ), ( 'ignoremods', 'user', '', '', 'boolean', 'yesno', 300, 0, 1, '', 0, 'vbulletin' );
          MySQL Error : Duplicate entry 'socnet' for key 1
          Error Number : 1062
          Request Date : Thursday, December 2nd 2010 @ 10:48:54 PM
          Error Date : Thursday, December 2nd 2010 @ 10:48:54 PM
          Script : http://www.xxxxxxxcom/foro/install/upgrade.php
          Referrer : http://www.xxxxxxxxxxx.com/foro/install/upgrade.php
          Classname : vB_Database
          MySQL Version : 5.0.91-community

          Comment

          • Michael König
            Senior Member
            • May 2001
            • 461
            • 3.6.x

            #6
            That's another bug:

            Comment

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