Invalid SQL:
SELECT blog.blogid, blog.comments_visible as replycount, blog.title, blog.lastcomment, blog.lastcommenter, blog.postedby_userid, blog.postedby_username, blog.dateline,
blog_text.blogtextid, blog_text.pagetext AS message, blog.ratingnum, blog.ratingtotal, blog.rating, blog.views,
blog_user.title as blogtitle, blog_user.description as blogdescription, blog.trackback_visible,
lastcomment.userid AS lastuserid, lastcomment.username AS lastusername,
user.*
,avatar.avatarpath,
NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,
customavatar.width AS avwidth,customavatar.height AS avheight
FROM blog AS blog
INNER JOIN blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
INNER JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
LEFT JOIN user AS user ON (blog.userid = user.userid)
LEFT JOIN blog_text AS lastcomment ON lastcomment.blogtextid = blog.lastblogtextid
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE 1=1
AND (blog.dateline > 1277979293)
AND blog.userid = 0
AND blog.state IN('visible')
AND blog.dateline <= 1283163293
AND blog.pending = 0
AND options_guest &
AND ~blog.options &
ORDER BY blog.dateline DESC
LIMIT 0,6;
MySQL-Fehler : 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 'AND ~blog.options &
ORDER BY blog.dateline DESC
LIMIT 0,6' at line 28
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 30.08.2010 @ 12:14:53
Datum : Monday, 30.08.2010 @ 12:14:53
Skript :
http://static.xxx.xxx.xxx.xxx.client...ver.de/testvb/
Referrer :
IP-Adresse : yyy.yyy.yyy.yyy
Benutzername : Unregistriert
Klassenname : vB_Database
MySQL-Version :
Zitieren
Lesezeichen