Suddenly the blog access has started to fail with a SQL error.
Any clues why this is happening?
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT blog.blogid, user.username, blogtextid, blog.title, blog_text.dateline, blog_text.pagetext, user.*, blog_user.title AS blogtitle, blog_text.title AS commenttitle,
blog_text.state,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, options_ignore, options_buddy, options_everyone
, ignored.relationid AS ignoreid, buddy.relationid AS buddyid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_blog_text AS blog_text
LEFT JOIN vb3_blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN vb3_user AS user ON (user.userid = blog_text.userid)
LEFT JOIN vb3_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
LEFT JOIN vb3_userlist AS buddy ON (buddy.userid = blog.userid AND buddy.relationid = 5 AND buddy.type = 'buddy')
LEFT JOIN vb3_userlist AS ignored ON (ignored.userid = blog.userid AND ignored.relationid = 5 AND ignored.type = 'ignore')
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE blog.state IN('visible', 'moderation')
AND blog.dateline <= 1234411079
AND blog.pending = 0
AND blog_text.state IN('visible', 'moderation')
AND blog.firstblogtextid <> blog_text.blogtextid
AND blog_text.dateline >= 1233201479
ORDER BY blog_text.dateline DESC
LIMIT 10;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Any clues why this is happening?
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT blog.blogid, user.username, blogtextid, blog.title, blog_text.dateline, blog_text.pagetext, user.*, blog_user.title AS blogtitle, blog_text.title AS commenttitle,
blog_text.state,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, options_ignore, options_buddy, options_everyone
, ignored.relationid AS ignoreid, buddy.relationid AS buddyid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb3_blog_text AS blog_text
LEFT JOIN vb3_blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN vb3_user AS user ON (user.userid = blog_text.userid)
LEFT JOIN vb3_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
LEFT JOIN vb3_userlist AS buddy ON (buddy.userid = blog.userid AND buddy.relationid = 5 AND buddy.type = 'buddy')
LEFT JOIN vb3_userlist AS ignored ON (ignored.userid = blog.userid AND ignored.relationid = 5 AND ignored.type = 'ignore')
LEFT JOIN vb3_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb3_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE blog.state IN('visible', 'moderation')
AND blog.dateline <= 1234411079
AND blog.pending = 0
AND blog_text.state IN('visible', 'moderation')
AND blog.firstblogtextid <> blog_text.blogtextid
AND blog_text.dateline >= 1233201479
ORDER BY blog_text.dateline DESC
LIMIT 10;
MySQL Error : Got error 28 from storage engine
Error Number : 1030
Comment