4images_groupmatch.MYD'. (errno: 144)

[wax]

hi all,

without any modifications i suddenly get the error
posted below, it only appears when a users logs in.
(all is fine when i log in as admin)..

do you have any idea what's going on?
like i said i didn't do anything.

greets,


derek


DB Error: Bad SQL Query: SELECT a.cat_id, a.auth_viewcat, a.auth_viewimage, a.auth_download, a.auth_upload, a.auth_directupload, a.auth_vote, a.auth_readcomment, a.auth_postcomment FROM 4images_groupaccess a, 4images_groupmatch m WHERE m.user_id = 14 AND a.group_id = m.group_id AND m.groupmatch_startdate <= 1025082061 AND (groupmatch_enddate > 1025082061 OR groupmatch_enddate = 0)
Can't open file: '4images_groupmatch.MYD'. (errno: 144)

[Nicky]

hi,

something ist wrong with your table:

error 144:
144 = Table is crashed and last repair failed

[wax]

hi nicky,

thanks for your reply. how is something like
that possible? and more important what to do next?

i have a complete backup from a few day's ago,
but can i just restore that table?

can you give me some insight in what to do?

(in phpadmin it says "in use")

thanks


derek

[Nicky]

sorry but here i can't help,

but look here:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Disaster_Prevention

4.4 Disaster Prevention and Recovery

[wax]

thanks nicky,

i just restored a mysql-backup and everything works
fine now..

thanks for your support.

greets

derek