help please [message #13620] |
Mon, 20 October 2003 06:35 |
|
belmax
Messages: 114 Registered: October 2002 Location: Saint-Petersburg, Russia
Karma:
|
Senior Member |
|
|
on start page of forum i see this message:
(index.php) 1030: Got error 28 from table handler
Query: SELECT m.subject, m.id, m.post_stamp, u.id, u.alias, c.description, c.name, c.default_view, c.allow_collapse, f.cat_id, f.forum_icon, f.id, f.last_post_id, f.moderators, f.name, f.descr, f.post_count, f.thread_count, fr.last_view, mo.id AS md, CASE WHEN g2.p_READ IS NULL THEN g1.p_READ ELSE g2.p_READ END AS p_READ FROM fud_forum f INNER JOIN fud_cat c ON c.id=f.cat_id INNER JOIN fud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud_msg m ON f.last_post_id=m.id LEFT JOIN fud_users u ON u.id=m.poster_id LEFT JOIN fud_forum_read fr ON fr.forum_id=f.id AND fr.user_id=5 LEFT JOIN fud_mod mo ON mo.user_id=5 AND mo.forum_id=f.id LEFT JOIN fud_group_cache g2 ON g2.user_id=5 AND g2.resource_id=f.id ORDER BY c.view_order, f.view_order
Server Version: 3.23.54
if i go to any topic directly, i see page normally
when i run "Forum Consistency", i receive error:
Checking threads against messages
(consist.php) 1030: Got error 28 from table handler
Query: SELECT m.thread_id, t.id, count(*) as cnt FROM fud_thread t LEFT JOIN fud_msg m ON t.id=m.thread_id WHERE m.approved='Y' GROUP BY m.thread_id,t.id ORDER BY cnt
Server Version: 3.23.54
[Referring Page] http://linuxportal.ru/forums/adm/consist.php?
rebooting mySQL server does not help - same errors
please, help
this is urgent
sorry for my poor english
|
|
|