Database error

[aidler]

Invalid SQL:
SELECT DISTINCT post.userid, IF(votenum>=1,votenum,0) AS votenum,
IF(votenum>=1 AND votenum > 0,votetotal/votenum,0) AS voteavg, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,thread.dateline,views,thread.iconid,not es,thread.visible,sticky,votetotal,attach
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '51') LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
WHERE thread.threadid IN (0,194,172,170,156)
ORDER BY sticky DESC, lastpost DESC

mysql error: Got error -1 from table handler

mysql error number: 1030

Date: Wednesday 24th of July 2002 03:01:11 PM
Script: http://www.idler-online.de/forum/forum/forumdisplay.php?s=&forumid=7
Referer:

Got this mysql error today. Can somebody please help me to solve this problem. I have absolutely no knowledge of mysql. :confused:

thanks

[Steve Machol]

Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

repair.php?html=1&check=1

It everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

[aidler]

My provider ist using MySQL Version 3.22.32. Repair.php should not work with versions before 3.23.x. Any other suggestions??

[eva2000]

you need your provider to upgrade to mysql 3.23.51

if not them you they have to use Isamchk to repair corruption - you host should be able to that - but they'd have to shutdown mysql before they repair it with Isamchk

[aidler]

:( No other way???

I don't think my provider will upgrade to a other MySQL Version any time soon. They have said that many times on other occassions. I douth they will shut down their MySQL Server just because I have a problem. The MySQL server is used by many other users at the same time.

Thanks anyway....

[eva2000]

Originally posted by aidler
:( No other way???

I don't think my provider will upgrade to a other MySQL Version any time soon. They have said that many times on other occassions. I douth they will shut down their MySQL Server just because I have a problem. The MySQL server is used by many other users at the same time.

Thanks anyway.... nope no other way... if the table is corrupted it needs to be repaired!

if your host is unwilling to do this i suggest you find a new host