-----------------Allgemeiner Fehler
SQL ERROR [ mysql4 ]
Table './phpbb_4/topics_track' is marked as crashed and should be repaired [145]
SQL
SELECT t.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time FROM (topics t) LEFT JOIN topics_track tt ON (tt.user_id = 2 AND t.topic_id = tt.topic_id) LEFT JOIN forums_track ft ON (ft.user_id = 2 AND t.forum_id = ft.forum_id) WHERE ( (tt.mark_time IS NOT NULL AND t.topic_last_post_time > tt.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NOT NULL AND t.topic_last_post_time > ft.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NULL AND t.topic_last_post_time > 1291888433) ) AND t.forum_id = 0 ORDER BY t.topic_last_post_time DESC LIMIT 1
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()
FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()
FILE: includes/functions.php
LINE: 1715
CALL: dbal->sql_query_limit()
FILE: includes/functions_display.php
LINE: 110
CALL: get_unread_topics()
FILE: index.php
LINE: 28
CALL: display_forums()
habs schon mit
undREPAIR TABLE phpbb_4sessions;
versucht, bringt aber nichts, weiss jemand mal wieder rat?REPAIR TABLE phpbb_4topics_track;
und vielleicht wie man solche fehler vorbeugen kann und warum sie immer kommen?
gruß andy