Announcement

Collapse
No announcement yet.

Database error in vBulletin 3.6.4: Invalid SQL

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

  • Database error in vBulletin 3.6.4: Invalid SQL

    Hi guys, i am having this error in my forum, is this because Mysql service is going away ?
    Or it is that the Invalid SQL is making mysql die ?
    thanks

    Code:
    Database error in vBulletin 3.6.4:
    
    Invalid SQL:
    
                                    INSERT IGNORE INTO session
                                            (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass, profileupdate)
                                    VALUES
                                            ('4de8c22aed25ad3ed5cb7051dcc3732a', 0, '190.76.59.243', 'd9770e7d2a4d02a77e2e8179065423e3', 1219262141, '/foro/showthread.php?t=47233&page=3', 0, 0, 0, 2, 47233, 0, 0, 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; .NET CLR 3.0.04506; InfoPath.2)', 0, 0);
    
    MySQL Error  : MySQL server has gone away
    Error Number : 2006
    Date         : Wednesday, August 20th 2008 @ 04:56:47 PM
    Script       : http://www.nightclubber.com.ar/foro/...t=47233&page=3
    Referrer     : http://www.google.co.ve/search?hl=es...biente&spell=1
    IP Address   : 190.76.59.243
    Username     : No Registrado
    Classname    : vB_Database_MySQLi

  • #2
    This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

    http://www.vbulletin.com/forum/showt...265#post310265

    Also from the MySQL site:

    http://dev.mysql.com/doc/refman/5.0/en/gone-away.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


    • #3
      Thanks Steve, we have a dedicated server for MySQL, so this is very strange
      This is the response from my Hosting:

      Hello,

      Essentially, it looks like that error causes mysql to restart because of
      database corruption. Can you ask your developers if they have any ideas as to
      what query may be causing this corruption? I did a cursory search for the
      error and found that it may be related to temporary table caching, there are
      several options that could affect your situation. I think it would be a good
      idea to ask your dev team to look at this before proceeding further. They
      would have far more insight as to why this is occurring. Let me know what they
      have to say.

      If you have any further questions, let me know.

      Comment


      • #4
        This is still a server issue. There is no code in vB that would cause this or cause database corruption. Besides if it were corruption you would be getting a different error.
        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