Announcement

Collapse
No announcement yet.

Upgrade error on adding RSS entry to FAQ

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

  • Upgrade error on adding RSS entry to FAQ

    Database error in vBulletin 3.0.1:

    Invalid SQL:
    REPLACE INTO datastore
    (title, data)
    VALUES
    Lots of info here, too big to post.

    mysql error: MySQL server has gone away

    mysql error number: 2006


    This is a test database before i upgrade the real one and is on my local machine. I've increased all memory limits and timeouts etc. Any Idea?

  • #2
    Even if there is lots of info, you really need to post the whole error, so the support team have a better chance of figuring out what's going wrong
    http://www.weirdpixels.com/images/buttons/button.gif

    Comment


    • #3
      When i meant lots of info, it's too long to post in here.

      The text that you have entered is too long (1063488 characters). Please shorten it to 65536 characters long.

      Comment


      • #4
        sorry about that, I did not actually think it was too big to post here.
        That must be some error!
        http://www.weirdpixels.com/images/buttons/button.gif

        Comment


        • #5
          Have a look at: http://dev.mysql.com/doc/mysql/en/gone-away.html

          Some quotes:
          <LI>You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld receives a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 1MB. You may also need to increase the maximum packet size on the client end. More information on setting the packet size is given in Section A.2.9, “Packet too large”.

          <LI>You also get a lost connection if you are sending a packet 16MB or larger if your client is older than 4.0.8 and your server is 4.0.8 and above, or the other way around.
          Want to take your board beyond the standard vBulletin features?
          Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

          Comment


          • #6
            If the query or packet is broken, how do you fix it?

            Because it's not the max_allowed_packet or wait_timeout

            Comment


            • #7
              Is it possible to install a fresh vbulletin and then import mysql data after?

              Comment


              • #8
                Reinstalling and importing will not fix the underlying server issue that is causing this.
                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


                • #9
                  What is max_allowed_packet and wait_timeout set to?

                  This query: SHOW VARIABLES

                  Will show you the actual values that your server is using.

                  Comment


                  • #10
                    max_allowed_packet = 1048576

                    wait_timeout = 28800 and i've also tried 57600

                    Comment


                    • #11
                      It is your max_allowed_packet setting of 1 megabyte. Increase it to 2 megabytes and you'll be able to do the upgrade.

                      Comment

                      Loading...
                      Working...
                      X