Announcement

Collapse
No announcement yet.

Problem upgrading from 3.8.4 to 4.0.5.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    ENF
    Senior Member

  • ENF
    replied
    Ok.

    So, it appears to crash at the same spot. I personally despise the "gone away" message as it offers up no other details without digging.

    Based on other posts I've seen by eva2000, you may want to consider upping your max_allowed_packets to say something like 128M. I'm guessing that your current entry is written in bytes, which only comes out to 4mb.

    I don't know what your server hardware resources are, but I'd consider raising that setting further. Also, have a look at this post that someone else posted: http://www.vbulletin.com/forum/showt...-a-Db-Eror-Plz... -- Read through eva2000's response. (He's pretty much the in-house expert on MySQL issues...)

    Leave a comment:

  • fitnesshealth
    Member

  • fitnesshealth
    replied
    Originally posted by ENF View Post
    Check your MySQL configuration. More specifically, check your wait_timeout settings.

    It wouldn't hurt to move up to a much more recent version of MySQL (4.1.22 was from 11/2006) as well.

    Your issue is MySQL related, not vBulletin.

    Edit: Also, take a peek at max_allowed_packet as well. If the query is too big and this setting is too low, the error message would appear the same as above.
    hi, i've upgraded mysql to 5.1.4.7.

    any idea what's the recommended settings for wait_timeout and max_allowed_packet?

    My current settings are:

    wait_timeout = 28800
    max_allowed_packet = 1048576

    i've tried increasing the wait_timeout and max_allowed_packet but they are not helping.

    wait_timeout = 144000
    max_allowed_packet = 4194304

    Error:
    Step 2) Misc Table Alterations (2/3)

    Altering subscribegroup Table (1 of 1)
    Altering forum Table (1 of 1)
    Altering thread Table (1 of 2)
    Altering thread Table (2 of 2)
    Altering tachyforumpost Table (1 of 1)
    Altering tachythreadpost Table (1 of 1)
    Altering style Table (1 of 1)
    Altering template Table (1 of 1)
    Creating templatemerge table
    Altering tag Table (1 of 1)
    Creating index canonicaltagid on tag
    Updating phrasetype table
    Database error


    Database error in vBulletin 3.8.4:

    Invalid SQL:
    ALTER TABLE tag ENGINE=InnoDB;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Monday, July 19th 2010 @ 04:14:03 PM
    Error Date : Monday, July 19th 2010 @ 04:14:03 PM
    Script : http://www.[removed].com/install/upgrade_400a1.php?step=2
    Referrer :
    IP Address : [removed]
    Username :
    Classname : vB_Database
    MySQL Version :
    fitnesshealth
    Member
    Last edited by fitnesshealth; Mon 19 Jul '10, 1:26pm.

    Leave a comment:

  • Lee G
    Senior Member

  • Lee G
    replied
    It might be worth taking a look at the following post as well.
    http://www.vbulletin.com/forum/showt...-connect-issue
    This was a regular issue people have been having with upgrades

    Leave a comment:

  • ENF
    Senior Member

  • ENF
    replied
    Check your MySQL configuration. More specifically, check your wait_timeout settings.

    It wouldn't hurt to move up to a much more recent version of MySQL (4.1.22 was from 11/2006) as well.

    Your issue is MySQL related, not vBulletin.

    Edit: Also, take a peek at max_allowed_packet as well. If the query is too big and this setting is too low, the error message would appear the same as above.

    Leave a comment:

  • fitnesshealth
    Member

  • fitnesshealth
    started a topic [Forum] Problem upgrading from 3.8.4 to 4.0.5.

    Problem upgrading from 3.8.4 to 4.0.5.

    Hi,

    I am trying to upgrade from 3.6.8 to 3.8.4 to 4.0.5

    Upgrading from 3.6.8 to 3.8.4 is ok. However, I've encountered an error when trying to upgrade 3.8.4 to 4.0.5.

    Error encountered when trying to run the upgrade.php:

    vBulletin 4.0 Upgrade System
    (Please be patient as some parts may take some time)

    Step 2) Misc Table Alterations (2/3) (Step 2 of 13) XML File Versions:

    vbulletin-style.xml
    vbulletin-settings.xml
    vbulletin-language.xml
    vbulletin-adminhelp.xml

    4.0.5
    4.0.5
    4.0.5
    4.0.5
    Step 2) Misc Table Alterations (2/3)

    Altering subscribegroup Table (1 of 1)
    Altering forum Table (1 of 1)
    Altering thread Table (1 of 2)
    Altering thread Table (2 of 2)
    Altering tachyforumpost Table (1 of 1)
    Altering tachythreadpost Table (1 of 1)
    Altering style Table (1 of 1)
    Altering template Table (1 of 1)
    Creating templatemerge table
    Altering tag Table (1 of 1)
    Creating index canonicaltagid on tag
    Updating phrasetype table

    Database error in vBulletin 3.8.4:

    Invalid SQL:
    ALTER TABLE tag ENGINE=InnoDB;

    MySQL Error : Lost connection to MySQL server during query
    Error Number : 2013
    Request Date : Monday, July 19th 2010 @ 08:28:57 AM
    Error Date : Monday, July 19th 2010 @ 08:28:57 AM
    Script : http://www.example.com/install/upgrade_400a1.php?step=2
    Referrer : http://www.example.com/install/upgrade_400a1.php?step=1
    IP Address : xxx.xxx.xxx.xxx
    Username :
    Classname : vB_Database
    MySQL Version : 4.1.22-standard
    The forum is hosted on a dedicated server.

    Any idea how to solve this?

Related Topics

Collapse

Working...
X