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

Home » FUDforum » FUDforum Installation Issues » Evil lag - More problems with v2.5.2 upgrade
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Evil lag - More problems with v2.5.2 upgrade [message #14449] Fri, 14 November 2003 09:24 Go to previous message
juboy309 is currently offline  juboy309   United Kingdom
Messages: 17
Registered: May 2003
Karma:
Junior Member
Sorted out most of the problems with our recent upgrade to v2.5.2 but not constantly get this SQL error message:

(index.php) 1100: Table 's' was not locked with LOCK TABLES
Query: SELECT s.id AS sid, s.ses_id, s.data, s.returnto, t.id AS theme_id, t.lang, t.name AS theme_name, t.locale, t.theme, t.pspell_lang, u.alias, u.append_sig, u.show_sigs, u.show_avatars, u.show_im, u.posts_ppg, u.time_zone, u.sig, u.last_visit, u.email_conf, u.last_read, u.default_view, u.is_mod, u.cat_collapse_status, u.ignore_list, u.acc_status, u.ignore_list, u.buddy_list, u.id, u.group_leader_list, u.coppa, u.blocked, u.email, u.login, u.notify, u.pm_notify, u.last_read, u.pm_messages FROM av_ses s INNER JOIN av_users u ON u.id=(CASE WHEN s.user_id>2000000000 THEN 1 ELSE s.user_id END) INNER JOIN av_themes t ON t.id=u.theme WHERE s.ses_id='271b7368122fa77fe7c11c958e9d2213'
Server Version: 3.23.57
[Referring Page] http://www.avtalk.co.uk

These build up and eventually no users can post replies or new threads and the forum speed grinds to a halt. It's definitely not a server problem.

If anyone could explain how to correct this error we'd be most grateful as, other than that, everything's now running great Smile
Thanks
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Fallen at the first hurdle
Next Topic: 2.6 install
Goto Forum:
  

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

Current Time: Wed Nov 27 01:52:57 GMT 2024

Total time taken to generate the page: 0.04345 seconds