[Zope-DB] rollback mysql?

3205 5361 1215 9784 3205 5361 1215 9784 <keo@goa.hu>
Tue, 06 Aug 2002 08:41:40 +0200


Hello zope-db,

  i have the following problem:

===
Site Error
An error was encountered while publishing this resource. 

_mysql_exceptions.NotSupportedError

Sorry, a site error occurred.

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

mysql.log:

020806  8:27:41      76 Query       BEGIN
                     76 Query       update opt_cpu set
  opt_name='IntelR Pentiumt-4',
  opt_short_name='P4'
  where opt_id=13
                     76 Query       ROLLBACK



why is zope rollbacking?
and whats all this?
the mysql has the correct new data, but zope gives an error...

thanks,


k

-- 
don't believe everything you think