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
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
Comment