Database Error 1064

[Mr Toner]

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

[Steve Machol]

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.

[Mr Toner]

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