Home •  Forum •  FAQ •  Search •  Recent Topics •  Memberlist •  Register •  Log in 
Forum » Icy Phoenix Support » Older Versions Archive » Old Support Topics

SOLVED Couldn't Access List Of Unread Posts From Forums

This topic is locked: you cannot edit posts or make replies.

 

Vortex
Quote
Posts: 412 Location: Prato, Italy
Sat 13 Jan, 2007 13:50
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 ;)

Profile PM   Website MSN Skype
z3d0
Quote
Posts: 81 Location: TOPICS_TABLE
Sat 13 Jan, 2007 14:17
Subject: Re: Couldn't Access List Of Unread Posts From Forums
try repairing the table from the db

Profile PM   Website
Vortex
Quote
Posts: 412 Location: Prato, Italy
Sat 13 Jan, 2007 14:26
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 ;)

Profile PM   Website MSN Skype
This topic is locked: you cannot edit posts or make replies.
 

Page 1 of 1


  
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

   

This is a "Lo-Fi" version of our main content. To view the full version with more information, formatting and images, please click here.

Powered by Icy Phoenix based on phpBB
Generation Time: 0.2845s (PHP: 7% SQL: 93%)
SQL queries: 10 - Debug Off - GZIP Enabled