[Zope] mysql error...

[Kevin Carlson]

Chris,

I have seen this happen before and it's not always a MySQL error.  My 
guess is that you are using MySQL with MyISAM tables that do not support 
transactions.  This error can be caused by a bug in a dtml 
method/document or a python script that occurs after the call to a ZSql 
method.  When the zope transaction fails, it tries to rollback the MySQL 
transaction which is not supported and throws yet another exception.

I'd look at the rest of the script that contains the call to the ZSql 
method and see if there's not a bug in there somewhere.

Kevin

Chris Bowlby wrote:

> 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..
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
> http://mail.zope.org/mailman/listinfo/zope-dev )
>