SQL Error

[Raven Faust]

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 11th Mar 2010. 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

[jayfella]

repair database via phpmyadmin.

[bentink]

Restore from a backup

[Raven Faust]

repaired and optimized,same issue.

UndergroundTeam.org has the same issue, could it be the host?

[GoonzNetwork]

probably the host if you both are having the same problem and are both on the same server otherwise it could be a lately installed plugin/product that caused the crash

[Raven Faust]

well were on the same server so prob that, which sucks.. not worth fixing right now if its the hosts issue, so i just wait? or what.. :\

[Nemesis]

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

Source

[Raven Faust]

tried that as stated above

[Nemesis]

Yeah, but it says you may need to run a few times to fix the error

[Raven Faust]

well tried that and same issue on UGteam:

Database error in vBulletin

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;

MySQL Error : Table './GTS1/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Thursday, March 11th 2010 @ 03:12:38 AM
Error Date : Thursday, March 11th 2010 @ 03:12:39 AM