FUDforum: Bug Reports » help please

Home » FUDforum Development » Bug Reports » help please

Show: Today's Messages :: Polls :: Message Navigator

help please [message #13620]

Mon, 20 October 2003 06:35

belmax

Messages: 114
Registered: October 2002
Location: Saint-Petersburg, Russia

Karma: 0

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 Smile