Need help with Application Error #401: Error from database #144

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
airthang
Posts: 2
Joined: 25 Apr 2019, 15:31

Need help with Application Error #401: Error from database #144

Post by airthang »

Hi,
I would like to summary about the situation first. The one who set up the bug tracker in my company left. I am trying to learn and fix this issue by myself with no knowledge about Mantis.
I got below issue

Code: Select all

APPLICATION ERROR #401
Database query failed. Error received from database was #144: Table './bugtracker/mantis_bug_file_table' is marked as crashed and last (automatic?) repair failed for the query: SELECT B.id AS bug_id, COUNT(F.bug_id) AS attachments FROM mantis_bug_table B JOIN mantis_bug_file_table F ON ( B.id = F.bug_id ) WHERE B.id IN (?) GROUP BY B.id.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
The MantisBT Version is 1.3.5/ Schema Version 209

Please let me know what should I do.

Thank you in advance for reading and answering my question.
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Need help with Application Error #401: Error from database #144

Post by cas »

Use phpmyadmin ( or another tool like Heidi etcetera) and access the DB outside mantis.
Navigate to the Matis Database, select the mantis_big_file_table and try to repair (option is available in the tool).
If it does not work, I hope you have a backup to restore :mrgreen:
airthang
Posts: 2
Joined: 25 Apr 2019, 15:31

Re: Need help with Application Error #401: Error from database #144

Post by airthang »

Could you please tell me where I can find the mantis database file?
cas
Posts: 1586
Joined: 11 Mar 2006, 16:08
Contact:

Re: Need help with Application Error #401: Error from database #144

Post by cas »

Download and install phpmyadmin: https://www.phpmyadmin.net/
Once installed you can navigate to the web-page, login and TaDa, you will find the mantis DB.
Post Reply