https://www.icyphoenix.com/viewtopic.php?f=35&t=895
-----------------------------------
Vortex
Sat 13 Jan, 2007 13:50

Couldn't Access List Of Unread Posts From Forums
-----------------------------------
I think something's wrong with my db :D


[quote]Couldn't access list of unread posts from forums

DEBUG MODE

SQL Error : 144 Table './kope/phpbb_posts' is marked as crashed and last (automatic?) repair failed

SELECT p.forum_id, p.topic_id, p.post_time, p.post_username, u.username, u.user_id, t.topic_last_post_id, t.topic_title, t.title_compl_infos FROM ((phpbb_posts p LEFT JOIN phpbb_topics t ON t.topic_id = p.topic_id AND t.forum_id = p.forum_id AND t.topic_moved_id = 0) LEFT JOIN phpbb_users u ON u.user_id = p.poster_id ) WHERE ( p.post_time > 1168673149 OR p.post_id IN (75638, 296212, 320527, 323567, 319274, 321730, 311778, 323577, 323560, 323576, 319955, 323076, 323587, 323572, 322920, 322856, 323544, 323229, 323545, 321484, 322815, 316744, 323556, 320842, 318417, 323524, 323210, 323573, 323574, 178656, 323541, 238354, 315367, 317290, 322868, 307080, 320211, 323566) ) AND p.post_id = t.topic_last_post_id

Line : 693
File : functions_categories_hierarchy.php[/quote]



Can you please suggest something?




Edit: forgot to say this is a live XS 0.58b, not IP test ;)


-----------------------------------
z3d0
Sat 13 Jan, 2007 14:17

Re: Couldn't Access List Of Unread Posts From Forums
-----------------------------------
try repairing the table from the db


-----------------------------------
Vortex
Sat 13 Jan, 2007 14:26

Re: Couldn't Access List Of Unread Posts From Forums
-----------------------------------
[quote user="z3d0" post="7325"]try repairing the table from the db[/quote]


Yes, you posted before me ;)


I repaired the table via phpmyadmin and it works... I have random problems but I think it's because of my host...  :roll: 



Thanks, solved ;)


