Error codes - Database Errors email -

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • OverallOpinion
    Member
    • May 2016
    • 33
    • 5.2.x

    Error codes - Database Errors email -

    Good Morning folks,

    Yesterday I had the highest number of people online on my forum - though it is still very new - the number was 59.

    Although I had a few error codes emailed to me - I don't see any failures on the site, but would like you guys to take a look at them.

    First Error.

    Database error in vBulletin 5.2.1:

    Invalid SQL:
    SELECT * FROM template
    WHERE `templateid` IN (1031);

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Thursday, June 9th 2016 @ 05:56:12 PM
    Error Date : Thursday, June 9th 2016 @ 05:58:53 PM
    Script : http:///robots.txt
    Referrer :
    IP Address : REMOVED BY USER*
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :

    -------------------------------------------------------------------------------------------------------------------------------------------------------

    Second Error.

    Database error in vBulletin 5.2.1:

    Invalid SQL:
    SELECT
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM user AS user
    LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE user.userid IN (36)
    /** fetchUserinfo **/;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Thursday, June 9th 2016 @ 05:56:17 PM
    Error Date : Thursday, June 9th 2016 @ 05:59:06 PM
    Script : http:///
    Referrer : URL OF WEBSITE REMOVED BY USER*
    IP Address : REMOVED BY USER*
    Username :
    Classname : vB_Database_MySQLi
    MySQL Version :

    -------------------------------------------------------------------------------------------------------------------------------------------------------

    Third Error.

    Database error in vBulletin 5.2.1:

    Invalid SQL:
    SELECT * FROM style
    WHERE `styleid` = 7
    LIMIT 1;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Thursday, June 9th 2016 @ 05:56:11 PM
    Error Date : Thursday, June 9th 2016 @ 05:59:33 PM
    Script : http:///robots.txt
    Referrer :
    IP Address :REMOVED BY USER*
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :

    -------------------------------------------------------------------------------------------------------------------------------------------------------

    Final Error.

    Database error in vBulletin 5.2.1:

    Invalid SQL:
    SELECT * FROM cache
    WHERE `cacheid` IN ('node_1_lvl1data');

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Thursday, June 9th 2016 @ 05:55:34 PM
    Error Date : Thursday, June 9th 2016 @ 05:59:01 PM
    Script : http:///forum/URL REMOVED BY USER*
    Referrer :
    IP Address :REMOVED BY USER*
    Username : Guest
    Classname : vB_Database_MySQLi
    MySQL Version :

    -------------------------------------------------------------------------------------------------------------------------------------------------------

    *** I removed URL's and IP Address.

    Anyway - I'm still very new to this and still trying to fine tune it.

    I am using a linux GoDaddy server that has up until now seemed to be running flawlessly.

    Like I said there is no real user end issues that I saw - though that doesn't mean they don't exist.

    I will add though, the forum did all of a sudden take forever to load right around the time of these errors, not sure if this hiccup was related.

    Thanks in advance!
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 74120

    #2
    They are all the same error code. It means the MySQL didn't respond to your query. It is usually caused by an overloaded server. If you're not using a GoDaddy VPS or Dedicated Server, you're sharing MySQL with hundreds if not thousands of other sites. If one takes up too many resources other sites will be affected. We have no control over this.

    You can clear your system cache in the AdminCP under Maintenance -> Clear System Cache. This may provide some relief. It tends to be one of the largest tables and isn't cleared out as much as I would like.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

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