Announcement

Collapse
No announcement yet.

Database error in vBulletin 2.3.0

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

  • Database error in vBulletin 2.3.0

    My forum is very very slow. I received many database errors. Is it a problem with my mysql database or with the sql server ?

    Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='89'
    mysql error: Lost connection to MySQL server during query

    mysql error number: 2013==============Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT template FROM template WHERE title='forumhome_threadbits' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
    mysql error: Lost connection to MySQL server during query

    mysql error number: 2013===============Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='17'
    mysql error: Lost connection to MySQL server during query

    mysql error number: 2013================= Database error in vBulletin 2.3.0:

    Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('8520539c83740bef23b14f236d77573b','1','64.228.239.60','Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; i-N','1058300426','','/index.php')
    mysql error: Lost connection to MySQL server during query

    mysql error number: 2013

    Date: Tuesday 15th of July 2003 04:20:57 PM===============Database error in vBulletin 2.3.0:

    Invalid SQL: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder,forumid
    mysql error: Lost connection to MySQL server during query

    mysql error number: 2013

    Date: Tuesday 15th of July 2003 03:51:45 PMetc etcMy forum is very very slow and I received many database. What's the meaning of this error messages. A problem with my mysql database or a problem with the sql server ?
    Last edited by esfron; Tue 15 Jul '03, 2:01pm.

  • #2
    A very unstable MySQL server - contact your hosting company and ask why it keeps going down.

    Comment


    • #3
      Thanks Xiphoïd. I'll check it with them.

      The last one:


      Database error in vBulletin :

      Link-ID == false, connect failed
      mysql error: Can't connect to MySQL server on 'megasqlservers.com' (111)

      mysql error number: 2003

      Date: Tuesday 15th of July 2003 04:09:59 PM
      Script: /index.php
      Referer:
      Thanks.

      The last one:

      Comment


      • #4
        This error means either MySQL crashed, it's not running or it can't find the socket. You need to contact your host about this. Here is more info on this error:

        http://www.mysql.com/doc/C/a/Can_not...to_server.html
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Thanks

          @++


          Database error in vBulletin 2.3.0:
          Invalid SQL: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='132'
          mysql error: Lost connection to MySQL server during query
          mysql error number: 2013
          Date: Tuesday 15th of July 2003 01:46:08 PM
          ...........
          Database error in vBulletin 2.3.0:
          Invalid SQL: DELETE FROM session WHERE sessionhash=''
          mysql error: MySQL server has gone away
          mysql error number: 2006
          Date: Tuesday 15th of July 2003 01:50:42 PM
          -----------
          Database error in vBulletin 2.3.0:
          Invalid SQL: DELETE FROM session WHERE sessionhash=''
          mysql error: Lost connection to MySQL server during query
          mysql error number: 2013
          Date: Tuesday 15th of July 2003 02:55:35 PMThanks
          ------------

          Database error in vBulletin 2.3.0:

          Invalid SQL: SELECT forum.forumid,styleid,styleoverride FROM forum,thread WHERE forum.forumid=thread.forumid AND threadid='411'
          mysql error: Lost connection to MySQL server during query

          mysql error number: 2013

          Date: Thursday 10th of July 2003 03:20:15 PM

          Comment


          • #6
            http://www.vbulletin.com/forum/showt...265#post310265
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

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