Announcement

Collapse
No announcement yet.

3.5.2 -> 5.5.6 upgrade issues

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

  • #16
    Thanks for the patched files, Wayne. I installed them as required, mounted the same database iteration the dev grabbed, then ran the upgrader thru CLI.

    We got to 5.5.4 alpha 4 step 3 when it threw an error

    Code:
    Upgrading to 5.5.4 Alpha 4
    ----------------------------------
    Step 1 - Dropping Old picturecomment Table
    Step 2 - Dropping Old picturecomment_hash Table
    Step 3 - Altering node Table (1 of 1)
    
    
    
    MySQL server has gone away
    ----------------------------------
    
    ### vBulletin Database Alter ###
    ALTER TABLE node
    MODIFY ipaddress VARCHAR(45) NOT NULL DEFAULT ''
    Error_log in core folder:

    Code:
    [02-Mar-2020 17:24:22 America/Boise] Warning: Invalid argument supplied for foreach() in /xxx/core/install/includes/class_upgrade_500a28.php on line 142

    Comment


    • #17
      The two issues are not related.

      The first is a MySQL issue. It closed the connection before returning the results of the query. Make sure your max_allowed_packet is at least 8 MB and that the wait_timeout and innodb_lock_wait_timeout values are at least 120 seconds. The 5.5.4 Alpha 4 steps are increasing the length of the IP Address fields throughout the database to accommodate IPv6. You may need to increase temp storage so that it is at least 3 times the largest table by size in the database. This is needed for temporary tables in adding fields and rebuilding indexes. The node table is probably the largest table in the database for this operation. Unfortunately, changing the size of the field can't be batched to only change a number of rows at one time.

      The second is a PHP Warning from the 5.0.0 Alpha 28 Step 6. That step would have been updating the postedithistory table. There would have been 100s of intervening steps and database modifications since this occurred and MySQL timed out. There are 154 versions of vBulletin between 5.0.0 Alpha 28 and 5.5.4 Alpha 4.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API - Full / Mobile
      Vote for your favorite feature requests and the bugs you want to see fixed.

      Comment


      • #18
        Wayne,

        It looks like everything turned out ok after your last advice, solved the most recent impasse.

        I really appreciate the level of suport that you and your team delivered here. Two thumbs up.... Thanks!

        Comment

        Related Topics

        Collapse

        Working...
        X