-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Please re-read my answer.
Andreas schrieb Justin Dunsworth: > This seems to be happening on more than just one query now... is > there any suggestion on where to look? > > On Thu, Dec 10, 2009 at 1:14 PM, Justin Dunsworth < > justin.dunswo...@gmail.com> wrote: > >> Thanks for the reply... Are you suggesting that there may be an >> issue with MySQL receiving the data from zope and the way it >> handles it? >> >> Strange thing is that I'm using the exact same method I have used >> thousands of times over and same code layout and this is the >> first time I'm seeing it. I've changed around a few things >> relating to variable names etc thinking it was the case but >> dumbing it down to the simplest way I can still is giving the >> error. >> >> On Thu, Dec 10, 2009 at 1:03 PM, Andreas Jung <li...@zopyx.com> >> wrote: >> >>> In case of a ZODB conflict error the whole request will be >>> repeat up to three times. If you database does not provide >>> proper transaction support (trible check your MySQL >>> installation and your table type useage), you're doomed. A >>> proper RDBMS like Oracle or Postgres will behave properly and >>> abort the transaction in case of a ZODB transaction abort. >>> >>> -aj >>> >>> Am 10.12.09 19:59, schrieb Justin Dunsworth: >>>> I am running into a brand new issue today that I can't, for >>>> the life of me, figure out. I wrote a standard page to insert >>>> data into a MySQL table using Z SQL methods from a form like >>>> I always have but for some strange reason it's running the >>>> same query twice, thus adding a duplicate entry. >>>> >>>> I have confined the original code in it's own document, >>>> checked, double checked, and still no avail. Here's the code >>>> for the page: >>>> >>>> <dtml-var frame_header> <dtml-if addnewstatus> <dtml-try> >>>> <dtml-call "RootSQLMethods.admin.Status_Add(_.None,_)"> >>>> <dtml-call "RESPONSE.redirect(BASE2+'/statuses')"> >>>> <dtml-except> <p>Error while submitting! Status not >>>> added.</p> <br>Error type: <dtml-var error_type> <br>Error >>>> value: <dtml-var error_value> </dtml-try> </dtml-if> <form >>>> action="&dtml-URL;" method="post"> <table class="tborder" >>>> align="center" width="30%" cellspacing="0" > <tr><td >>>> class="tcat" align="center" colspan="2" style="font-size: >>>> 12pt;">Add New Status</td></tr> <tr><td width="35%" >>>> align="right"><b>Name:</b></td><td width="65%"><input >>>> type="text" name="name_add" size=15></td></tr> <tr><td >>>> width="35%" align="right" >>>> valign="top"><b>Description:</b></td><td >>>> width="65%"><textarea name="description_add" cols=25 >>>> rows=4></textarea></td></tr> <tr><td width="35%" >>>> align="right"><b>Sort:</b></td><td width="65%"><input >>>> type="text" name="sort_add" value="5" >>> size=1></td></tr> >>>> <tr><td align="center" colspan="2"><hr></td></tr> <tr> >>>> <td><input type="hidden" name="addnewstatus" value="1"></td> >>>> <td> <button class="button" onclick="this.form.submit()">Add >>>> Status</button> <button class="button" >>>> onclick="window.location = '<dtml-var BASE2>/statuses'; >>>> return false;">Cancel</button> </td> </tr> </table> </form> >>>> <dtml-var frame_footer> >>>> >>>> I can run the SQL Method by itself and it works just fine >>>> (only inserting it once) but when run as a separate page it >>>> adds the two. >>>> >>>> Any assistance is appreciated >>>> >>>> >>>> _______________________________________________ Zope maillist >>>> - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope >>>> ** No cross posts or HTML encoding! ** (Related lists - >>>> https://mail.zope.org/mailman/listinfo/zope-announce >>>> https://mail.zope.org/mailman/listinfo/zope-dev ) >>>> >>> >>> -- ZOPYX Ltd. & Co KG \ zopyx group Charlottenstr. >>> 37/1 \ The full-service network for your D-72070 >>> Tübingen \ Python, Zope and Plone projects >>> www.zopyx.com, i...@zopyx.com \ www.zopyxgroup.com >>> ------------------------------------------------------------------------ >>> >>> E-Publishing, Python, Zope & Plone development, Consulting >>> >>> >>> > > > ---------------------------------------------------------------------- > > > _______________________________________________ > Zope maillist - Zope@zope.org > https://mail.zope.org/mailman/listinfo/zope ** No cross posts or > HTML encoding! ** (Related lists - > https://mail.zope.org/mailman/listinfo/zope-announce > https://mail.zope.org/mailman/listinfo/zope-dev ) - -- ZOPYX Ltd. & Co KG \ zopyx group Charlottenstr. 37/1 \ The full-service network for your D-72070 Tübingen \ Python, Zope and Plone projects www.zopyx.com, i...@zopyx.com \ www.zopyxgroup.com - ------------------------------------------------------------------------ E-Publishing, Python, Zope & Plone development, Consulting -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAksnzGMACgkQCJIWIbr9KYwPlACg1ddItBhsM1dT10Iq9pE/ULgE RwkAoOfg9NdwZKdvx9DqSWfK91X1myTh =x0AL -----END PGP SIGNATURE-----
<<attachment: lists.vcf>>
_______________________________________________ Zope maillist - Zope@zope.org https://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - https://mail.zope.org/mailman/listinfo/zope-announce https://mail.zope.org/mailman/listinfo/zope-dev )
