Bug #25886 errror
Submitted: 27 Jan 2007 3:28 Modified: 28 Feb 2007 10:23
Reporter: daniel sheldon Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Errors Severity:S2 (Serious)
Version:MySQL 4.0.13 OS:
Assigned to: CPU Architecture:Any

[27 Jan 2007 3:28] daniel sheldon
when i go to view a post i get this::

General Error
SQL ERROR [ mysql4 ]

Can't open file: 'phpbb_topics.MYI'. (errno: 145) [1016]


SELECT t.*, tp.topic_posted, tt.mark_time FROM (phpbb_topics t) LEFT JOIN phpbb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 2) LEFT JOIN phpbb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 2) WHERE t.forum_id IN (10, 0) AND t.topic_type IN (2, 3) ORDER BY t.topic_time DESC


FILE: includes/db/mysql.php
LINE: 132
CALL: dbal->sql_error()

FILE: viewforum.php
LINE: 338
CALL: dbal_mysql->sql_query()

How to repeat:
every time i go to a post i get the error

Suggested fix:
im not sure how to fix it
[28 Jan 2007 10:23] Valeriy Kravchuk
Error 145 means that you have to repair your table. Read http://dev.mysql.com/doc/refman/4.1/en/repair-table.html on how to do it. 

In case of similar problem after successfull repair, please, try to repeat with a newer version, 4.0.27, and inform about the results.
[1 Mar 2007 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".