All of a sudden about an hour ago I started getting emails to my admin account stating there are some sql errors. Example below. I haven' changed anything in days and quite a few of the my pages appear to have "gone", blog, content, gallery etc. Forum and posts appear to be still there.
Any ideas anyone?
Database error in vBulletin 4.1.1:
Invalid SQL:
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid)
INNER JOIN blog AS blog ON (tagcontent.contenttypeid = AND tagcontent.contentid = blog.blogid)
INNER JOIN blog_user AS blog_user ON (blog.userid = blog_user.bloguserid)
WHERE blog.dateline <= 1301422466 AND blog.pending = 0 AND blog.state = 'visible' AND ~blog.options & 8
AND tagcontent.dateline > 1269886466
GROUP BY tagcontent.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;
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 tagcontent.contentid = blog.blogid)
INNER JOIN blog_user AS blog_user ON' at line 4 Error Number : 1064 Request Date : Tuesday, March 29th 2011 @ 02:14:26 PM
thanks
Guy
Any ideas anyone?
Database error in vBulletin 4.1.1:
Invalid SQL:
SELECT tagcontent.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagcontent AS tagcontent
INNER JOIN tag AS tag ON (tagcontent.tagid = tag.tagid)
INNER JOIN blog AS blog ON (tagcontent.contenttypeid = AND tagcontent.contentid = blog.blogid)
INNER JOIN blog_user AS blog_user ON (blog.userid = blog_user.bloguserid)
WHERE blog.dateline <= 1301422466 AND blog.pending = 0 AND blog.state = 'visible' AND ~blog.options & 8
AND tagcontent.dateline > 1269886466
GROUP BY tagcontent.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70;
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 tagcontent.contentid = blog.blogid)
INNER JOIN blog_user AS blog_user ON' at line 4 Error Number : 1064 Request Date : Tuesday, March 29th 2011 @ 02:14:26 PM
thanks
Guy
Comment