<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Hi everybody,</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">I'm new to this group. I got the
very strange error below while setting a SESSION variable. Cannot understand
why, because it says it is a SQL error.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Site Error</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">An error was encountered while
publishing this resource. </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt">_mysql_exceptions.NotSupportedError</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Sorry, a site error occurred.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Traceback (innermost last): </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module ZPublisher.Publish, line
163, in publish_module_standard </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module
Products.PlacelessTranslationService.PatchStringIO, line 45, in new_publish </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module ZPublisher.Publish, line
108, in publish </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module Zope.App.startup, line
226, in abort </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module ZODB.Transaction, line
134, in abort </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module Shared.DC.ZRDB.TM, line
63, in abort </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Module Products.ZMySQLDA.db, line
327, in _abort </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">NotSupportedError: (1196,
"Warning: Some non-transactional changed tables couldn't be rolled back") </P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal
style="MARGIN: 0in 0in 0pt">----------------------------------------------------------------------</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Thers is no entry on the error
log for more information. I'm running zope 2.7.0 and also tried on 2.7.2-0. Both
gave me the same error.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">The python script code is:</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">request = container.REQUEST</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">session = request.SESSION</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">##</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">request.set('caller',
'processItem')</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">if not
request.has_key('submit'):</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>return 'NO SUBMIT'</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">#</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">orderNo = session['orderNo']</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">if orderNo == 0:</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>orderNo =
context.createOrderHeaderPY()</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>session.set('itemIndex',
1)</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>session.set('orderNo',
orderNo)<SPAN style="mso-spacerun: yes"> </SPAN>## <-- LINE WITH
PROBLEM</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>itemIndex = 1</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">else:</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>itemIndex =
int(session['itemIndex']) + 1</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>session.set('itemIndex',
itemIndex)</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN
style="mso-spacerun: yes"> </SPAN>orderNo =
session['orderNo']</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">#</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">I tried setting up another
SESSION variable (using a different name for it) and it works. This code was
working before. It broke when I made some changes in other scripts.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">I'd appreciate any help.</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p> </o:p></P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Thanks,</P>
<P class=MsoNormal style="MARGIN: 0in 0in 0pt">Norma</P></DIV></BODY></HTML>