Vackrick
08-30-2013, 02:43 PM
Database error in vBulletin 4.2.1:
Invalid SQL:
SELECT
user.username,
blog.userid, blog.title, blog.blogid, blog.categories, blog.postedby_username, blog.postedby_userid,
bu.title AS blogtitle, bu.options_guest & AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid = bu.bloguserid)
INNER JOIN user AS user ON (blog.userid = user.userid)
WHERE
state = 'visible' AND
dateline <= 1377877265 AND
blog.pending = 0 AND
~blog.options & AND
bu.options_buddy & AND
bu.options_member &
ORDER BY dateline DESC
LIMIT 1;
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 'AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid ' at line 4
Error Number : 1064
what is this?? i can't even save the usergroup setting, hw to fix it?
Invalid SQL:
SELECT
user.username,
blog.userid, blog.title, blog.blogid, blog.categories, blog.postedby_username, blog.postedby_userid,
bu.title AS blogtitle, bu.options_guest & AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid = bu.bloguserid)
INNER JOIN user AS user ON (blog.userid = user.userid)
WHERE
state = 'visible' AND
dateline <= 1377877265 AND
blog.pending = 0 AND
~blog.options & AND
bu.options_buddy & AND
bu.options_member &
ORDER BY dateline DESC
LIMIT 1;
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 'AS guestcanview
FROM blog AS blog
LEFT JOIN blog_user AS bu ON (blog.userid ' at line 4
Error Number : 1064
what is this?? i can't even save the usergroup setting, hw to fix it?