[Zope] Error setting a session variable

Andy Dustman farcepest at gmail.com
Thu Jul 22 20:45:21 EDT 2004


> NotSupportedError: (1196,  "Warning: Some non-transactional changed tables couldn't be rolled back") 

Zope, for what ever reason, is aborting the transaction, but you wrote
something into your database, and were using some non-transaction-safe
tables, most likely ISAM or MyISAM tables. Unless you use
transaction-safe tables, such as InnoDB or BDB, this sort of this is
likely to happen and there's not much you can do about it. Zope is
very transactional. MySQL *can* be transactional, but the default
table types are not.

Your only option (short of changing databases) is to change your
database to use transaction-safe-tables; MySQL-4.0 is recommended for
this, though later 3.23 versions also support them. ALTER TABLE ...
TYPE=InnoDB will do the trick.


More information about the Zope mailing list