Announcement

Collapse
No announcement yet.

Database Error 1064

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

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

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


  • Mr Toner
    started a topic Database Error 1064

    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:
    SELECT
    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
    Script: http://www.copier411.com/showthread.php?mode=hybrid&t=6
    Referer: http://www.copier411.com/showthread.php?p=6#post6
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X