Announcement

Collapse
No announcement yet.

Database error

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

  • [Forum] Database error

    in last few days we got alot of database error like this.

    Database error in vBulletin 4.2.2:

    Invalid SQL:

    SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM thread as thread
    LEFT JOIN user AS user ON (user.username = thread.lastposter) WHERE forumid IN (3,8,9,72,124,144,81,178,65) ORDER BY lastpost DESC LIMIT 0, 10;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Monday, May 5th 2014 @ 03:51:52 AM
    Error Date : Monday, May 5th 2014 @ 03:52:21 AM
    Script : domian,com/do=newthread&f=19&fcon=1
    Referrer :
    IP Address :
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version :
    i know it might be from one extra addon which we have added but i'm wondering is there any easy way to find out which one is the reason ??? checked them one by one but couldnt find anything.

    any help would be great.

    Thanks


  • #2
    Either the query timed out, or the amount of data returned was too big. Ask your webhost what the MySQL wait_timeout and max_packet_size are.

    Comment


    • #3
      wait_timeout = 20 - connect_timeout = 10 and MySQL Packet Size 64.00 MB

      Comment

      Related Topics

      Collapse

      Working...
      X