Icy Phoenix :: View topic - Couldn't Access List Of Unread Posts From Forums

Vortex [ Sat 13 Jan, 2007 13:50 ]
Post subject: 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

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 ]
Post subject: Re: Couldn't Access List Of Unread Posts From Forums

try repairing the table from the db

Vortex [ Sat 13 Jan, 2007 14:26 ]
Post subject: Re: Couldn't Access List Of Unread Posts From Forums

z3d0 wrote: [View Post]
try repairing the table from the db

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 ;)

Icy Phoenix

Old Support Topics - Couldn't Access List Of Unread Posts From Forums