[Zope-DB] Keyword search broken after upgrade from 2.6.3 -> 2.7.0
dieter at handshake.de
Tue Jun 8 16:01:40 EDT 2004
Marc G. Fournier wrote at 2004-6-7 17:37 -0300:
>Just finished going through the routine of upgrading a client from 2.6.3
>-> 2.7.0 ... for the most part, it went uneventful, mostly had to do with
>getting the proper modules installed for the MySQL backend ...
>But, they just found an error on their keyword search section of the site,
>with the error generated being:
>NotSupportedError: (1196, "Warning: Some non-transactional changed tables couldn't be rolled back")
Something generated an exception. This caused an abort
of the Zope transaction. The "abort" was delegated to
the "MySQL" connection which answered with a secondary exception:
the one you see above.
This is not a Zope 2.7 problem but one of your MySQL setup.
* use only transaction capable tables in your MySQL database
* tell the DA to ignore the exceptions above.
Beware! This can bring your MySQL in an inconsistent state
* use a different database system with full transactional support
More information about the Zope-DB