brandonmccoy
New Member
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT forum.description_clean AS forumdesc_clean, forum.title AS forum_title, forum.forumid, post.userid, post.threadid, post.postid, user.avatarrevision, post.title, post.pagetext, post.dateline, user.username, user.joindate ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width_thumb AS avwidth,customavatar.height_thumb AS avheight
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN thread AS thread ON(thread.threadid = post.threadid)
LEFT JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE post.postid IN (,1,11,12,10) ORDER BY FIELD(post.postid,'','1','11','12','10');
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 '1,11,12,10) ORDER BY FIELD(post.postid,'','1','11','12','10')' at line 8
Error Number : 1064
Request Date : Thursday, June 25th 2009 @ 10:36:05 PM
Error Date : Thursday, June 25th 2009 @ 10:36:05 PM
Script : http://ipodfun.sqweebs.com/forum/
Referrer :
IP Address : 76.22.178.86
Username : admin
Classname : vB_Database
MySQL Version : 5.0.27-Debian_0.dotdeb.1
Invalid SQL:
SELECT forum.description_clean AS forumdesc_clean, forum.title AS forum_title, forum.forumid, post.userid, post.threadid, post.postid, user.avatarrevision, post.title, post.pagetext, post.dateline, user.username, user.joindate ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width_thumb AS avwidth,customavatar.height_thumb AS avheight
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN thread AS thread ON(thread.threadid = post.threadid)
LEFT JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE post.postid IN (,1,11,12,10) ORDER BY FIELD(post.postid,'','1','11','12','10');
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 '1,11,12,10) ORDER BY FIELD(post.postid,'','1','11','12','10')' at line 8
Error Number : 1064
Request Date : Thursday, June 25th 2009 @ 10:36:05 PM
Error Date : Thursday, June 25th 2009 @ 10:36:05 PM
Script : http://ipodfun.sqweebs.com/forum/
Referrer :
IP Address : 76.22.178.86
Username : admin
Classname : vB_Database
MySQL Version : 5.0.27-Debian_0.dotdeb.1