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             ..
......                                                          ......