Invalid SQL: DELETE FROM active_sessions WHERE changed...
S.R.Patterson
S.R.Patterson@soton.ac.uk
Fri, 17 Nov 2000 09:38:03 +0000 (GMT)
If this one has come up before, slap me.
IMP got a rude shutdown a few days ago when power failed and since then
a number of people have reported seeing this error:
Database error (HordeDB): Invalid SQL: DELETE FROM active_sessions WHERE
changed <'somedatestring' AND name='HordeSession'
My guess is there's a bunch of stale cookies lying around and out of
date session information? I plan to shut down imp for 10 minutes or so
and clear out the session tables - is this wise and is it likely to fix
the problem? The problem seems purely aesthetic and goes away after a
login/logout (presumably because by then your session information is
updated).
Any help or advice? Ta.
--
Steven Patterson, MSci ----------------------------------------------+
| Electronic Information Systems Support and Development |
| Computing Services, University of Southampton, UK. |
+-------------------------------------------- Tel: +44 (0) 2380 595810
...... ......
.. In the time of chimpanzees I was a monkey ..
...... ......