No announcement yet.

MySQL errors: blank queries?

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] MySQL errors: blank queries?

    Hi, this is probably a simple or even a normal thing, but I'm just curious. In the log file I'm fairly free of errors, but the ones that seem common are where the query text is empty, like this:

    Database error in vBulletin 4.1.3:
    Invalid SQL:
        SELECT thread.firstpostid
        FROM thread AS thread
        WHERE thread.threadid =;
    MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
    Error Number  : 1064
    Request Date  : Wednesday, February 15th 2012 @ 05:58:20 PM
    Error Date    : Wednesday, February 15th 2012 @ 05:58:20 PM
    Script        :
    Referrer      : 
    IP Address    :
    Username      : xxxxxxxxxx
    Classname     : vB_Database
    MySQL Version :
    As you can see this was from mobiquo, but still. Under what circumstances would the forum try to query with an empty value? That is, thread.threadid = blank?

    This isn't the only error. I have another from a moderator in the inlinemod.php script that got this query:
    Invalid SQL:
    UPDATE user SET usertitle = 'Banned', usergroupid = '10', displaygroupid = '0' WHERE userid=;
    Why would any script give a blank value like this?


  • #2
    Any ideas?


    • #3
      I have the same issue.
      Did you ever find a solution on this?


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