Database Error post upgrade to 4.1.11 PL1

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dannefaerd
    New Member
    • Feb 2006
    • 29
    • 4.0.0

    [Forum] Database Error post upgrade to 4.1.11 PL1

    Hi team

    Upgraded my installation from 4.1.10 to 4.1.11 PL1, and since doing that have had a couple of automated emails saying that there is a database error. A snippet of the raw data that I get is below... grateful for any ideas of what the problem might be.

    Thanks!
    Martin

    Invalid SQL:

    REPLACE INTO vb_cache
    SET cacheid = 'widget_4.8330b09955ca5366ef6f3714fd4eca53',
    expires = 1332995800,
    created = 1332995500,
    locktime = 0,
    data = "a:4:{s:13:\"contenttypeid\";s:1:\"1\";s:3:\"ids\";a:5:{i:0;s:5:\"22686\";i:1;s:5:\"22684\ ";i:2;s:5:\"22682\";i:3;s:5:\"22676\";i:4;s:5:\"22674\";}s:8:\"criteria\";O:18:\"vB_Search _Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\0vB_Search_Criteria\ 0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0;s:27:\"\0vB_Search_C riteria\0filters\";a:3:{s:11:\"contenttype\";a:1:{s:2:\"eq\";a:1:{i:0;i:1;}}s:8:\"dateline \";a:1:{s:2:\"gt\";i:1332390700;}s:7:\"forumid\";a:1:{s:3:\"neq\";i:13;}}s:24:\"\0vB_Searc h_Criteria\0sort\";a:2:{i:0;s:8:\"dateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria \0grouped\";i:2;s:31:\"\0vB_Search_Criteria\0searchterms\";N;s:32:\"\0vB_Search_Criteria\0 criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";s:1:\"1\";s:35:\"\0vB_Se arch_Criteria\0display_strings\";a:4:{s:4:\"type\";s:7:\": Posts\";s:13:\"exclude_forum\";N;s:4:\"date\";s:18:\"Date 22-03-2012\";s:8:\"keywords\";s:16:\": <b><u></u></b>\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0h
  • ENF
    Senior Member
    • Apr 2002
    • 2677
    • 3.8.11

    #2
    Need to see the whole error.

    That snippet tells us nothing about the error it actually is. (The key stuff is at the bottom of the error)
    To be updated...

    Comment

    • dannefaerd
      New Member
      • Feb 2006
      • 29
      • 4.0.0

      #3
      Doh! Sorry - message email was clipped. Error details below:

      MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
      Error Number : 1153
      Request Date : Thursday, March 29th 2012 @ 07:01:41 PM
      Error Date : Thursday, March 29th 2012 @ 07:01:51 PM
      Script : http://www.paintball.net.nz/
      Referrer :
      IP Address : 118.92.69.50
      Username : Armagedonmad
      Classname : vB_Database
      MySQL Version :


      Thanks!

      Comment

      • ENF
        Senior Member
        • Apr 2002
        • 2677
        • 3.8.11

        #4
        Originally posted by dannefaerd
        MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
        You need to raise the MySQL setting for "max_allowed_packet".

        If you are unsure about this, please ask your host. This error could continue to repeat in the future if this setting isn't adjusted.

        MySQL Ref: http://dev.mysql.com/doc/refman/5.0/...too-large.html
        To be updated...

        Comment

        • dannefaerd
          New Member
          • Feb 2006
          • 29
          • 4.0.0

          #5
          Got a suggestion to what level I should raise it? Also - is this a function of the new 4.1.11PL1? First time I've ever had this error....

          Comment

          • ENF
            Senior Member
            • Apr 2002
            • 2677
            • 3.8.11

            #6
            Originally posted by dannefaerd
            Got a suggestion to what level I should raise it? Also - is this a function of the new 4.1.11PL1? First time I've ever had this error....
            It really doesn't have anything to do with the patch. You probably would have hit this sooner or later anyway.

            The setting is really dependent on your environment. Whatever it is now, raise it up 10-20% and see what happens.

            The default is 1MB, you can check your current setting in the AdminCP in the quick statistics block under "MySQL Packet Size".
            To be updated...

            Comment

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