I frequently get this databaserror. What should I do to get rid of it?
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
filename, ba.blogid, ba.userid, ba.attachmentid, ba.extension, ba.visible, attachmenttype.mimetype,
ba.dateline, filesize,
blog.blogid, blog.state, blog.pending, blog.postedby_userid,
bu.memberids, bu.memberblogids,
user.membergroupids, user.usergroupid, user.infractiongroupids
FROM blog_attachment AS ba
LEFT JOIN attachmenttype AS attachmenttype ON (attachmenttype.extension = ba.extension)
LEFT JOIN blog AS blog ON (ba.blogid = blog.blogid)
LEFT JOIN blog_user AS bu ON (bu.bloguserid = blog.userid)
LEFT JOIN user AS user ON (user.userid = blog.userid)
WHERE attachmentid = 1 AND options_guest & AND ~blog.options &;
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 'AND ~blog.options &' at line 17
Error Number : 1064
Request Date : Saturday, February 20th 2010 @ 06:40:51 PM
Error Date : Saturday, February 20th 2010 @ 06:40:51 PM
Script : http://xxx/forum/blog_attachment.php...1&d=1255725561
Referrer :
IP Address : 66.249.71.112
Username : ()
Classname : vB_Database
MySQL Version :
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT
filename, ba.blogid, ba.userid, ba.attachmentid, ba.extension, ba.visible, attachmenttype.mimetype,
ba.dateline, filesize,
blog.blogid, blog.state, blog.pending, blog.postedby_userid,
bu.memberids, bu.memberblogids,
user.membergroupids, user.usergroupid, user.infractiongroupids
FROM blog_attachment AS ba
LEFT JOIN attachmenttype AS attachmenttype ON (attachmenttype.extension = ba.extension)
LEFT JOIN blog AS blog ON (ba.blogid = blog.blogid)
LEFT JOIN blog_user AS bu ON (bu.bloguserid = blog.userid)
LEFT JOIN user AS user ON (user.userid = blog.userid)
WHERE attachmentid = 1 AND options_guest & AND ~blog.options &;
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 'AND ~blog.options &' at line 17
Error Number : 1064
Request Date : Saturday, February 20th 2010 @ 06:40:51 PM
Error Date : Saturday, February 20th 2010 @ 06:40:51 PM
Script : http://xxx/forum/blog_attachment.php...1&d=1255725561
Referrer :
IP Address : 66.249.71.112
Username : ()
Classname : vB_Database
MySQL Version :
Comment