Getting Database error in vBulletin 4.1.11

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PolicyWala
    Senior Member
    • Feb 2009
    • 270

    [CMS] Getting Database error in vBulletin 4.1.11

    Getting below errors after upgrading to vBulletin 4.1.11, Please guide whats the problem -
    Database error in vBulletin 4.1.11:

    Invalid SQL:

    REPLACE INTO cache
    SET cacheid = 'widget_4.647f954c9052907896b05c649df8011a',
    expires = 1331285962,
    created = 1331285662,
    locktime = 0,
    data = "a:4:{s:13:\"contenttypeid\";s:1:\"1\";s:3:\"ids\";a:4:{i:0;s:4:\"8936\";i:1;s:4:\"8935\";i:2;s:4:\"8934\";i:3;s:4:\"8933\";}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_Criteria\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:1330680862;}s:7:\"forumid\";a:1:{s:3:\"neq\";i:46;}}s:24:\"\0vB_Search_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_
    PolicyWala.com | Insurance Discussion Forum | Indian Insurance
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    We need the end of that error also
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • PolicyWala
      Senior Member
      • Feb 2009
      • 270

      #3
      It's too long last part -
      ";s:12:\"lastactivity\";s:10:\"1331267938\";s:8:\"lastpost\";s:10:\"1331267788\";s:10:\"lastpostid\";s:4:\"8936\";s:5:\"posts\";s:1:\"1\";s:10:\"reputation\";s:2:\"10\";s:17:\"reputationlevelid\";s:1:\"5\";s:14:\"timezoneoffset\";s:3:\"5.5\";s:7:\"pmpopup\";s:1:\"1\";s:8:\"avatarid\";s:1:\"0\";s:14:\"avatarrevision\";s:1:\"0\";s:18:\"profilepicrevision\";s:1:\"0\";s:14:\"sigpicrevision\";s:1:\"0\";s:7:\"options\";s:8:\"53496854\";s:8:\"birthday\";s:0:\"\";s:15:\"birthday_search\";s:10:\"0000-00-00\";s:8:\"maxposts\";s:2:\"-1\";s:11:\"startofweek\";s:2:\"-1\";s:10:\"referrerid\";s:1:\"0\";s:10:\"languageid\";s:1:\"1\";s:10:\"emailstamp\";s:1:\"0\";s:12:\"threadedmode\";s:1:\"0\";s:13:\"autosubscribe\";s:1:\"3\";s:7:\"pmtotal\";s:1:\"0\";s:8:\"pmunread\";s:1:\"0\";s:4:\"salt\";s:30:\"!ppDJzX*a)6M\'%1~q@nmwUInm(gBQ8\";s:7:\"ipoints\";s:1:\"0\";s:11:\"infractions\";s:1:\"0\";s:8:\"warnings\";s:1:\"0\";s:18:\"infractiongroupids\";s:0:\"\";s:17:\"infractiongroupid\";s:1:\"0\";s:12:\"adminoptions\";s:1:\"0\";s:13:\"profilevisits\";s:1:\"0\";s:11:\"friendcount\";s:1:\"0\";s:14:\"friendreqcount\";s:1:\"0\";s:13:\"vmunreadcount\";s:1:\"0\";s:16:\"vmmoderatedcount\";s:1:\"0\";s:19:\"socgroupinvitecount\";s:1:\"0\";s:16:\"socgroupreqcount\";s:1:\"0\";s:13:\"pcunreadcount\";s:1:\"0\";s:16:\"pcmoderatedcount\";s:1:\"0\";s:16:\"gmmoderatedcount\";s:1:\"0\";s:12:\"importuserid\";s:1:\"0\";s:13:\"assetposthash\";s:0:\"\";s:8:\"fbuserid\";s:15:\"100001910292241\";s:10:\"fbjoindate\";s:10:\"1331267180\";s:6:\"fbname\";s:11:\"Manoj Yadav\";s:9:\"logintype\";s:2:\"fb\";s:17:\"bloggroupreqcount\";s:1:\"0\";s:11:\"showblogcss\";s:1:\"1\";s:13:\"fbaccesstoken\";s:116:\"AAAB326ZAqOVcBAGdqihk4rwNVYiC30OEPigeVLiwK5dqIjqcWPgDarQgQZCaFABV2ljwcTRRtaLZAMTjV4UC5YVxbDbQzxKy3Qh24NvsOJhHn2SuRQ2\";s:11:\"dl2_uploads\";s:1:\"0\";s:13:\"dl2_downloads\";s:1:\"0\";s:12:\"dl2_comments\";s:1:\"0\";s:10:\"avatarpath\";N;s:15:\"hascustomavatar\";s:1:\"0\";s:14:\"avatardateline\";N;s:5:\"width\";N;s:6:\"height\";N;s:12:\"height_thumb\";N;s:11:\"width_thumb\";N;s:14:\"filedata_thumb\";N;}}}}}",
      serialized = '1';

      MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
      Error Number : 1153
      Request Date : Friday, March 9th 2012 @ 07:32:08 AM
      Error Date : Friday, March 9th 2012 @ 07:32:08 AM
      Script : http://www.policywala.com/
      Referrer :
      IP Address : 176.35.129.54
      Username : Unregistered
      Classname : vB_Database
      MySQL Version :
      PolicyWala.com | Insurance Discussion Forum | Indian Insurance

      Comment

      • PolicyWala
        Senior Member
        • Feb 2009
        • 270

        #4
        Error code 1153: Got a packet bigger than 'max_allowed_packet' bytes
        It means that a query is sent that is larger than your host allows for.

        MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

        You need to ask your host to increase the 'max_allowed_packet' variable in the my.cnf file and restart MySQL. The default is 1Mb, but most hosts run 8-16 Mb without problems.

        More info here: http://dev.mysql.com/doc/refman/5.0/...too-large.html

        Source -
        https://www.vbulletin.com/docs/html/...t_mysql_errors
        PolicyWala.com | Insurance Discussion Forum | Indian Insurance

        Comment

        • PolicyWala
          Senior Member
          • Feb 2009
          • 270

          #5
          This is an issue with VB CMS.
          PolicyWala.com | Insurance Discussion Forum | Indian Insurance

          Comment

          • PolicyWala
            Senior Member
            • Feb 2009
            • 270

            #6
            Updated by MySQL Packet Size - 32.00 MB, Now the issue solved.
            Vbulletin should have to put this as a basic requirement for vbulletin CMS owners.
            PolicyWala.com | Insurance Discussion Forum | Indian Insurance

            Comment

            Related Topics

            Collapse

            Working...