[Zope] Zope/MySQL problem

[Richard Moon]

Has anyone come across anything like this ? I have a site www.tunedb.org 
which is using a MySQL backend. We are getting this error

Error Type : Operation Error
Error Value : (1100,"Table 'n' was not locked with lock tables")

When anyone submits a search (e.g. Searh by Tune name)
This seems to have been triggered when someone dip a query to the site 
which addressed a results page directly eg

http://tunedb.nipltd.net/tunedb/tune_details_results.html?tune_id=23&tune_name=The%20Bucks%20Of%20Oranmore

After that everyone gets the error until I restart Zope - (closing an 
re-opening the MySQL connections has the same effect). I have four MySQL 
connections open.

Any ideas gratefully received

Thanks

Full traceback
Traceback (innermost last):
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 
222, in publish_module
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 
187, in publish
   File /home/sites/site7/users/tunedb/2-2-2/lib/python/Zope/__init__.py, 
line 221, in zpublisher_exception_hook
     (Object: Traversable)
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 
171, in publish
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/mapply.py, line 
160, in mapply
     (Object: tune_search_logic.html)
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/ZPublisher/Publish.py, line 
112, in call_object
     (Object: tune_search_logic.html)
   File /home/sites/site7/users/tunedb/2-2-2/lib/python/OFS/DTMLMethod.py, 
line 172, in __call__
     (Object: tune_search_logic.html)
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_String.py, 
line 528, in __call__
     (Object: tune_search_logic.html)
   File /home/sites/site7/users/tunedb/2-2-2/lib/python/OFS/DTMLMethod.py, 
line 168, in __call__
     (Object: tune_search_results.html)
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_String.py, 
line 528, in __call__
     (Object: tune_search_results.html)
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/DocumentTemplate/DT_In.py, 
line 630, in renderwob
     (Object: tune_search_exact)
   File 
/home/sites/site7/users/tunedb/2-2-2/lib/python/Shared/DC/ZRDB/DA.py, line 
453, in __call__
     (Object: tune_search_exact)
   File /usr/share/zope/lib/python/Products/ZMySQLDA/db.py, line 184, in query
OperationalError: (see above)


Richard Moon
richard@dcs.co.uk