Couldn't access list of unread posts from forums
DEBUG MODE
SQL Error : 145 Table './joe_upx0r/phpbb_topics' is marked as crashed and should be repaired
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
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 )
LEFT OUTER JOIN phpbb_approve_posts ap ON ap.post_id = p.post_id )
WHERE ( p.post_time > 1327732827 OR p.post_id IN (1359, 936, 1630, 194, 508, 167, 146, 223, 230, 676, 289, 402, 869, 531, 30, 192, 1632, 1405, 13, 4467, 185, 243, 429, 55, 245, 141, 32, 1221, 4438, 235, 268, 272, 476, 885, 475, 933, 1289, 887, 842, 845, 979, 863, 573, 641, 825, 758, 1562, 1218, 1383) )
AND p.post_id = t.topic_last_post_id
AND p.post_time < 1327732827
AND ap.post_id IS NULL
Line : 722
File : functions_categories_hierarchy.php
|
