No announcement yet.

Database Error 1064

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Error 1064

    Any suggestions for what caused this (six times for a new user) and what can be done to resolve it?

    Database error in vBulletin 3.0.1:

    Invalid SQL:
    post.*, post.username AS postusername, post.ipaddress AS ip,
    ##icon.title as icontitle,icon.iconpath,
    ##NOT ISNULL(deletionlog.primaryid) AS isdeleted,
    NOT ISNULL(deletionlog.primaryid) AS isdeleted,
    user.*, userfield.*

    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    ##LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
    ##LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
    LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
    WHERE threadid = 6 AND post.visible = 1
    ORDER BY postid

    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 1

    mysql error number: 1064

    Date: Wednesday 26th of May 2004 09:38:25 PM

  • #2
    Have you installed any hacks (including portals) or added any code to the headinclude, header or phpinclude templates? Reupload the original showthread.php file from the vB zip file. Make sure you upload in ASCII and overwrite the one on the server.
    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.


    • #3
      Thanks, Steve. Hope that does it (I'm not sure what the user was doing when the problem occurred).


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