[Zope] mysql error...

[Chris Bowlby]

Hi All,

  Got an issue with a search feature that was configured by a client of 
mine, when they choose to search using a keyword, they get this error:


Site Error

An error was encountered while publishing this resource.

_mysql_exceptions.NotSupportedError
Sorry, a site error occurred.


Traceback (innermost last):
   File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 150, in 
publish_module
   File /usr/local/www/Zope/lib/python/ZPublisher/Publish.py, line 106, in 
publish
   File /usr/local/www/Zope/lib/python/Zope/__init__.py, line 182, in abort
   File /usr/local/www/Zope/lib/python/ZODB/Transaction.py, line 107, in abort
   File /usr/local/www/Zope/lib/python/Shared/DC/ZRDB/TM.py, line 60, in abort
   File /usr/local/www/Zope/lib/python/Products/ZMySQLDA/db.py, line 328, 
in _abort
NotSupportedError: (1196, "Warning:  Some non-transactional changed tables 
couldn't be rolled back")

I'm not much of a Zope user/admin, so someone might need to be really 
specific about what this error actually means, it seems to be that a table 
might be missing from the mysql datatbase, but I need some confirmation on 
that, also if that is the case, where would I get the schema for this table..