MySQL error 1194

[PavelK]

Hi,
after I logged in I get this message:

Error filling in additional detail fields Query Failed:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0::MySQL error 1194:

thx for any advise

[mikesolomon]

Hi,
after I logged in I get this message:

Error filling in additional detail fields Query Failed:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0::MySQL error 1194:

thx for any advise

Per http://dev.mysql.com/doc/refman/5.0/...es-server.html

Error: 1194 SQLSTATE: HY000 (ER_CRASHED_ON_USAGE)

Message: Table '%s' is marked as crashed and should be repaired

Try repairing the table

[PavelK]

I've already tried to repair the table but it's still not working

[mikesolomon]

I've already tried to repair the table but it's still not working

Can you access the table from mysql?

You could try duplicating it and drop the original & renaming the duplicate