Getting a weird SQL Error:


Warning: mysql_query() [function.mysql-query]: Unable to save result set in [path]/class_core.php on line 408



Invalid SQL:

SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM thread as thread
LEFT JOIN user AS user ON (user.username = thread.lastposter) ORDER BY lastpost DESC LIMIT 0, 5;

MySQL Error : Table 'thread' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Thursday, March 11th 2010 @ 02:50:46 AM
Error Date : Thursday, March 11th 2010 @ 02:50:46 AM

Any ideas?

Raven Faust Reviewed by Raven Faust on . SQL Error Getting a weird SQL Error: Warning: mysql_query() : Unable to save result set in /class_core.php on line 408 Invalid SQL: SELECT thread.lastposter, thread.lastpost, thread.views, thread.open, thread.forumid, thread.replycount, thread.threadid, thread.pollid, thread.title, user.username, user.userid, user.usergroupid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid FROM thread as thread Rating: 5