Database query failed. Error received from database was #144:

Question

Database query failed. Error received from database was #144: Table 'dbname.mantis_bug_file_table' is marked as crashed and last (automatic?) repair failed for the query: SELECT bug_id, COUNT(bug_id) AS attachments
FROM mantis_bug_file_table
GROUP BY bug_id.

How to avoid above issue. Many times I got this error after repair table. If I repair table after loading the page it's says "#2013 - Lost connection to MySQL server during query".

Thanks.

PSR · Answer 1 · 2013-03-14T07:17:35.987

1

Stop MySQL process first.Go to your data folder and try running myisamchk -r <table_name>. If it is not work then try with myisamchk -r -v -f <table_name>.

edited Mar 14 '13 at 07:17

answered Mar 14 '13 at 07:12

PSR

36,137
33
104
147

Where I have to run this myisamchk -r . – selva Mar 14 '13 at 07:28
see here http://www.thegeekstuff.com/2008/09/how-to-repair-corrupted-mysql-tables-using-myisamchk/ – PSR Mar 14 '13 at 07:31

Database query failed. Error received from database was #144:

1 Answers1