I suddenly started getting this error on my zope-pages, and I can no longer access the manage-pages (the same error just pops up): Zope Error Zope has encountered an error while publishing this resource. Error Type: NotSupportedError Error Value: (1196, "Warning: Some non- transactional changed tables couldn't be rolled back") Anyone recognize this? I'd greatly appreciate any help here! regards, Kyrre Myrbostad webmaster Student-TV Trondheim, Norway kyrrem@stud.ntnu.no
Kyrre Myrbostad wrote:
Error Type: NotSupportedError Error Value: (1196, "Warning: Some non- transactional changed tables couldn't be rolled back")
What flavour of SQL database do you use? What changes have been made to it recently? cheers, Chris - why must everyone torture themselves with SQL? ;-)
This will happen when a particular dtml method or python script fails for one reason or another after issuing a successful SQL call. In MySQL, for example, the default table types do not support transactions. The Zope Rdb machinery apparently issues a rollback to the database when a script throws an exception that is not handled. My guess is that if you put try / except blocks around portions of your code that follow the SQL call, you will find your culprit. If you are using MySQL, try using InnoDB tables which support transactions. Kevin -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Kyrre Myrbostad Sent: Monday, October 07, 2002 12:40 PM To: zope@zope.org Subject: [Zope] Strange notsupported error I suddenly started getting this error on my zope-pages, and I can no longer access the manage-pages (the same error just pops up): Zope Error Zope has encountered an error while publishing this resource. Error Type: NotSupportedError Error Value: (1196, "Warning: Some non- transactional changed tables couldn't be rolled back") Anyone recognize this? I'd greatly appreciate any help here! regards, Kyrre Myrbostad webmaster Student-TV Trondheim, Norway kyrrem@stud.ntnu.no _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Thank's alot. That did the trick. There was also a problem that when an error occured (page not found or whatever) Zope published the standard errorpage, which included the standard footer where my script was. This generated a loop, an ugly one ;) Well, thx again for helping out. This maillist far exceeded my expectations ;) regards, Kyrre Myrbostad kyrrem@stud.ntnu.no ----- Original Message ----- From: "Kevin Carlson" <khcarlso@bellsouth.net> To: "Kyrre Myrbostad" <kyrrem@stud.ntnu.no>; <zope@zope.org> Sent: Thursday, October 10, 2002 4:53 AM Subject: RE: [Zope] Strange notsupported error
This will happen when a particular dtml method or python script fails for one reason or another after issuing a successful SQL call. In MySQL, for example, the default table types do not support transactions. The Zope Rdb machinery apparently issues a rollback to the database when a script throws an exception that is not handled.
My guess is that if you put try / except blocks around portions of your code that follow the SQL call, you will find your culprit. If you are using MySQL, try using InnoDB tables which support transactions.
Kevin
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Kyrre Myrbostad Sent: Monday, October 07, 2002 12:40 PM To: zope@zope.org Subject: [Zope] Strange notsupported error
I suddenly started getting this error on my zope-pages, and I can no longer access the manage-pages (the same error just pops up):
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: NotSupportedError Error Value: (1196, "Warning: Some non- transactional changed tables couldn't be rolled back")
Anyone recognize this? I'd greatly appreciate any help here!
regards, Kyrre Myrbostad webmaster Student-TV Trondheim, Norway kyrrem@stud.ntnu.no
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (3)
-
Chris Withers -
Kevin Carlson -
Kyrre Myrbostad