Tweet
Hi, today I finished the move to a new server. Everything went well so far and is working properly.
However, the Blog is not available anymore. The pulldown menu in the navbar is not popping up, and I received this strange database error message:
Can anybody help me and give me a hint how to solve that issue? I switched off vBSEO to see if this was the reason but it wasn't, still the same.
Thanks a lot!
However, the Blog is not available anymore. The pulldown menu in the navbar is not popping up, and I received this strange database error message:
Database error in vBulletin 3.8.3:
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 vb_blog AS blog
LEFT JOIN vb_blog_user AS bu ON (blog.userid = bu.bloguserid)
LEFT JOIN vb_user AS user ON (blog.userid = user.userid)
WHERE
state = 'visible' AND
dateline <= 1248208213 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 vb_blog AS blog
LEFT JOIN vb_blog_user AS bu ON (blog.u' at line 4 Error Number : 1064 Request Date : Tuesday, July 21st 2009 @ 10:30:13 PM
Error Date : Tuesday, July 21st 2009 @ 10:30:13 PM
Script : http://www.cureconnections.com/cron.php?rand=1248208212
Referrer : http://www.cureconnections.com/newthread.php?do=postthread&f=10
IP Address : xxx.xxx.xxx.xx
Username : Unregistered
Classname : vb_database
MySQL Version :
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 vb_blog AS blog
LEFT JOIN vb_blog_user AS bu ON (blog.userid = bu.bloguserid)
LEFT JOIN vb_user AS user ON (blog.userid = user.userid)
WHERE
state = 'visible' AND
dateline <= 1248208213 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 vb_blog AS blog
LEFT JOIN vb_blog_user AS bu ON (blog.u' at line 4 Error Number : 1064 Request Date : Tuesday, July 21st 2009 @ 10:30:13 PM
Error Date : Tuesday, July 21st 2009 @ 10:30:13 PM
Script : http://www.cureconnections.com/cron.php?rand=1248208212
Referrer : http://www.cureconnections.com/newthread.php?do=postthread&f=10
IP Address : xxx.xxx.xxx.xx
Username : Unregistered
Classname : vb_database
MySQL Version :
Thanks a lot!
Comment