Evil lag - More problems with v2.5.2 upgrade [message #14449] |
Fri, 14 November 2003 09:24 |
juboy309
Messages: 17 Registered: May 2003
Karma: 0
|
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
Thanks
|
|
|
|
|
|
|
|
|
|