phpMyAdmin

Support Requests item #1645714, was opened at 2007-01-27 01:01
Message generated for change (Settings changed) made by masterman22
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1645714&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL
Group: None
Status: Open
>Priority: 9
Private: No
Submitted By: daniel22 (masterman22)
Assigned to: Nobody/Anonymous (nobody)
Summary: error

Initial Comment:
hi i get this error:::
General Error
SQL ERROR [ mysql4 ]

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

SQL

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 (2, 0) AND t.topic_type IN (2, 3) ORDER BY t.topic_time DESC

BACKTRACE


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

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



*****************************************
could some1 help me please cos now my forum is not working

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1645714&group_id=23067

Support Requests item #1645714, was opened at 2007-01-27 02:01
Message generated for change (Comment added) made by nijel
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1645714&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL
Group: None
>Status: Closed
Priority: 9
Private: No
Submitted By: daniel22 (masterman22)
>Assigned to: Michal Čihař (nijel)
Summary: error

Initial Comment:
hi i get this error:::
General Error
SQL ERROR [ mysql4 ]

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

SQL

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 (2, 0) AND t.topic_type IN (2, 3) ORDER BY t.topic_time DESC

BACKTRACE


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

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



*****************************************
could some1 help me please cos now my forum is not working

----------------------------------------------------------------------

>Comment By: Michal Čihař (nijel)
Date: 2007-01-28 10:45

Message:
Logged In: YES 
user_id=192186
Originator: NO

MySQL error code 145: Table was marked as crashed and should be repaired

So you should run repair it.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1645714&group_id=23067