Database error in vBulletin 4.1.10 (external)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • tiengnhat
    Member
    • Jul 2008
    • 91

    [Forum] Database error in vBulletin 4.1.10 (external)

    Hello
    Can you tell me about how can i to fix this error?

    Code:
    Database error in vBulletin 4.1.10:
    
       
      Invalid SQL:
       
                      REPLACE INTO externalcache
    
                              (cachehash, dateline, text, headers, forumid)
                      VALUES
                              (
                                      '566715ace21297339e7221d3b2004ea9',
                                      1332072972,
      [FONT=&quot]                                                        '<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n\r\n<rss version=\"2.0\" xmlns:dc=\"[URL="http://purl.org/dc/elements/1.1/"]http://purl.org/dc/elements/1.1/\[/URL]" xmlns:content=\"[URL="http://purl.org/rss/1.0/modules/content/"]http://purl.org/rss/1.0/modules/content/\[/URL]">\n              <channel>\n
    
    ..................................
    
    
    [/FONT]  </item>\n       </channel>\n</rss>\n',
                                      'a:6:{i:0;s:7:\"Pragma:\";i:1;s:33:\"Cache-control: max-age=1332076572\";i:2;s:38:\"Expires: Sun, 18 Mar 2012 13:16:12 GMT\";i:3;s:44:\"Last-Modified: Sun, 18 Mar 2012 12:16:12 GMT\";i:4;s:40:\"ETag: \"566715ace21297339e7221d3b2004ea9\"\";i:5;s:37:\"Content-Type: text/xml; charset=UTF-8\";}',
                                      0
                              );
       
      MySQL Error   : Got a packet bigger than 'max_allowed_packet' bytes
      Error Number  : 1153
      Request Date  : Sunday, March 18th 2012 @ 09:16:12 PM
      Error Date    : Sunday, March 18th 2012 @ 09:17:06 PM
      Script        : [url]http://www.mydomain.com/forums/external.php?type=RSS2[/url]
    
      Referrer      : 
      IP Address    : 209.85.238.247
      Username      : Unregistered
      Classname     : vB_Database
      MySQL Version :
  • PossumX
    Senior Member
    • Oct 2006
    • 261
    • 4.1.x

    #2
    Database error in vBulletin 4.1.10 (external)

    Package was larger than the MySQL config allows. You will need to correct yourself in the my.cnf file, if on VPS or dedicated. If shared, you'll need to contact your hosting company.

    Is this repetitive or a one time thing? If one time, I wouldn't worry much, if repeating it needs to be adjusted.

    This is because it is not a vBulletin error, but a MySQL error due to the max_packet_size being too small for the request made to the database.

    Comment

    • tiengnhat
      Member
      • Jul 2008
      • 91

      #3
      Originally posted by PossumX
      Package was larger than the MySQL config allows. You will need to correct yourself in the my.cnf file, if on VPS or dedicated. If shared, you'll need to contact your hosting company.

      Is this repetitive or a one time thing? If one time, I wouldn't worry much, if repeating it needs to be adjusted.

      This is because it is not a vBulletin error, but a MySQL error due to the max_packet_size being too small for the request made to the database.
      hello
      You can specify the correct file for my my.cnf in the path. Edit the parameters in that file. I am currently using VPS server. Repeated errors in the last few days. I have deleted files external.php from my forum .
      Looking forward to receiving your help.

      Comment

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