I'm MySQL database email errors sent to me, below are the two errors:
Database error in vBulletin 2.3.0:
Invalid SQL:
SELECT DISTINCT post.userid, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attac h
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '2745' AND post.visible = 1) LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
WHERE thread.threadid IN (0,13156,13058,10121,13133,13132,13111,13038,13023,12561,13044,13043,12842,12693,12276,130 11,12622,12960,12464,12922,12968,12870,12175,12961,12920,12341,12497,12717,12573,12738,127 74,8210,12701,12564,149,11579)
ORDER BY sticky DESC, lastpost DESC
mysql error: Got error 28 from table handler
mysql error number: 1030
AND THIS
Database error in vBulletin 2.3.0:
Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=3429 ORDER BY title
mysql error: Got error 28 from table handler
mysql error number: 1030
Can anyone tell me what causes these and how to go about fixing them? I just ran repair.php and that doesn't seem to do anything for the errors.
-Michael
Database error in vBulletin 2.3.0:
Invalid SQL:
SELECT DISTINCT post.userid, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postuserid,
lastposter,thread.dateline,views,thread.iconid,notes,thread.visible,sticky,votetotal,attac h
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '2745' AND post.visible = 1) LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
WHERE thread.threadid IN (0,13156,13058,10121,13133,13132,13111,13038,13023,12561,13044,13043,12842,12693,12276,130 11,12622,12960,12464,12922,12968,12870,12175,12961,12920,12341,12497,12717,12573,12738,127 74,8210,12701,12564,149,11579)
ORDER BY sticky DESC, lastpost DESC
mysql error: Got error 28 from table handler
mysql error number: 1030
AND THIS
Database error in vBulletin 2.3.0:
Invalid SQL: SELECT * FROM forum,subscribeforum WHERE subscribeforum.forumid=forum.forumid AND userid=3429 ORDER BY title
mysql error: Got error 28 from table handler
mysql error number: 1030
Can anyone tell me what causes these and how to go about fixing them? I just ran repair.php and that doesn't seem to do anything for the errors.
-Michael
Comment