FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » help please
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
help please [message #13620] Mon, 20 October 2003 06:35 Go to previous message
belmax is currently offline  belmax   Russian Federation
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 Smile
[Message index]
 
Read Message
Read Message
Read Message
Previous Topic: Template and Administration problems
Next Topic: Forum marks ALL posts as UNREAD, & DOESN'T show new posts in tree view?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 07:01:32 GMT 2024

Total time taken to generate the page: 0.04008 seconds