Help Urgent DB Blog Errors
 

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?

Run Maintenance > Diagnostics > Suspect File Version - are any files listed as not containing expected contents or missing or anything like that?

Thanks it was fixed :)