[Zope-DB] Keyword search broken after upgrade from 2.6.3 -> 2.7.0 ...

[Dieter Maurer]

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.

Your options:

  *  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

-- 
Dieter