|
Page 1 of 1
|
 Vortex 
Joined: October 2006
Posts: 412
Location:  Prato, Italy
|
 Couldn't Access List Of Unread Posts From Forums
I think something's wrong with my db 
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 
|
#1 Sat 13 Jan, 2007 13:50 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
z3d0
Joined: August 2006
Posts: 81
Location: TOPICS_TABLE
|
Re: Couldn't Access List Of Unread Posts From Forums
try repairing the table from the db
|
#2 Sat 13 Jan, 2007 14:17 |
|
Vortex
Joined: October 2006
Posts: 412
Location: Prato, Italy
|
Re: Couldn't Access List Of Unread Posts From Forums
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... 
Thanks, solved
|
#3 Sat 13 Jan, 2007 14:26 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
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
|
|
|
|
