Let me take this a bit further and I hate spamming but if any other person that has a similar issue can refer to... I simplified a page and all it's dependencies and added code back one by one. It eventually ended up coming down to one tag that was switching browser modes and POSTed twice. Switched compatability mode to on with IE8 and did it with the same tag and it worked fine. I removed the tag: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" " http://www.w3.org/TR/html4/strict.dtd"> On Tue, Dec 15, 2009 at 1:09 PM, Justin Dunsworth < justin.dunsworth@gmail.com> wrote:
Investigating further the page is actually being posted twice. This was due to javascript and not the database, transactions, or otherwise.
On Tue, Dec 15, 2009 at 11:50 AM, Andreas Jung <lists@zopyx.com> wrote:
-----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.dunsworth@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 <lists@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, info@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, info@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-----