Error on Logging In

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lernia
    New Member
    • Jun 2007
    • 11
    • 3.5.x

    Error on Logging In

    This is a two part problem.


    Part I:

    I've received the following error when individuals try to log in.


    Database error in vBulletin 3.5.4:

    Invalid SQL: SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) ASpassworddate, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, language.phrasegroup_posting AS phrasegroup_posting, language.phrasegroup_postbit AS phrasegroup_postbit, language.phrasegroup_showthread AS phrasegroup_showthread, language.phrasegroup_inlinemod AS phrasegroup_inlinemod, language.phrasegroup_global AS phrasegroup_global, language.options AS lang_options, language.languagecode AS lang_code, language.charset AS lang_charset, language.locale AS lang_locale, language.imagesoverride AS lang_imagesoverride, language.dateoverride AS lang_dateoverride, language.timeoverride AS lang_timeoverride, language.registereddateoverride AS lang_registereddateoverride, language.calformat1override AS lang_calformat1override, language.calformat2override AS lang_calformat2override, language.logdateoverride AS lang_logdateoverride, language.decimalsep AS lang_decimalsep, language.thousandsep AS lang_thousandsep FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid =user.userid) INNER JOIN language AS language ON (language.languageid =IF(user.languageid = 0, 1, user.languageid)) WHERE user.userid = 4;MySQL Error : Lost connection to MySQL server during queryError Number : 2013Date : Tuesday, June 12th 2007 @ 12:46:08 PMScript : http://www.lernia-ts.com/forums/showthread.php?t=23Referrer : http://www.lernia-ts.com/forums/forumdisplay.php?f=11IP Address : 155.94.62.222Username : Classname : vb_database

    Part II:

    We are still able to log in, but then when we try and access threads within the forum, we get the next error:

    There seems to have been a problem with the database.
    Please try again by clicking the Refresh button in your web browser.
    An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.
    We apologise for any inconvenience.
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    1. Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem. If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

    Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

    2. We need to see the real error message. Right-click on the error page and go to View/Source. Then copy-n-paste the error message here.
    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

    • lernia
      New Member
      • Jun 2007
      • 11
      • 3.5.x

      #3
      Source for Error Message

      Here's the source for the error message:

      Database error in vBulletin 3.5.4:
      Invalid SQL:
      SELECT
      userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
      IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
      language.phrasegroup_posting AS phrasegroup_posting,
      language.phrasegroup_postbit AS phrasegroup_postbit,
      language.phrasegroup_showthread AS phrasegroup_showthread,
      language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
      language.phrasegroup_global AS phrasegroup_global,
      language.options AS lang_options,
      language.languagecode AS lang_code,
      language.charset AS lang_charset,
      language.locale AS lang_locale,
      language.imagesoverride AS lang_imagesoverride,
      language.dateoverride AS lang_dateoverride,
      language.timeoverride AS lang_timeoverride,
      language.registereddateoverride AS lang_registereddateoverride,
      language.calformat1override AS lang_calformat1override,
      language.calformat2override AS lang_calformat2override,
      language.logdateoverride AS lang_logdateoverride,
      language.decimalsep AS lang_decimalsep,
      language.thousandsep AS lang_thousandsep

      FROM user AS user
      LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
      LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

      WHERE user.userid = 4;
      MySQL Error : Lost connection to MySQL server during query
      Error Number : 2013
      Date : Tuesday, June 12th 2007 @ 01:28:55 PM
      Script : http://www.lernia-ts.com/forums/showthread.php?t=22
      Referrer : http://www.lernia-ts.com/forums/forumdisplay.php?f=11
      IP Address : 155.94.62.222
      Username :
      Classname : vb_database
      -->

      Comment

      • lernia
        New Member
        • Jun 2007
        • 11
        • 3.5.x

        #4
        1. Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem. If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

        Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it. Do you have the same problem?

        I'll try this and see what happens. Thnx.

        Comment

        • lernia
          New Member
          • Jun 2007
          • 11
          • 3.5.x

          #5
          Should I upgrade?

          I was also going to upgrade to the lastest version of vBulletin. Would this have the same effect? Thnx.

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            This is a server issue. You need to contact your host about this. See this post for the possible causes of a lost connection 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...