This seems to be happening on more than just one query now... is there any suggestion on where to look?<br><br>
<div class="gmail_quote">On Thu, Dec 10, 2009 at 1:14 PM, Justin Dunsworth <span dir="ltr"><<a href="mailto:justin.dunsworth@gmail.com">justin.dunsworth@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div class="im">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? <br> <br>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.<br>
<br></div>
<div class="gmail_quote">
<div class="im">On Thu, Dec 10, 2009 at 1:03 PM, Andreas Jung <span dir="ltr"><<a href="mailto:lists@zopyx.com" target="_blank">lists@zopyx.com</a>></span> wrote:<br></div>
<div>
<div></div>
<div class="h5">
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">In case of a ZODB conflict error the whole request will be repeat up to<br>three times.<br>If you database does not provide proper transaction support (trible<br>
check your MySQL<br>installation and your table type useage), you're doomed. A proper RDBMS<br>like Oracle<br>or Postgres will behave properly and abort the transaction in case of a<br>ZODB transaction<br>abort.<br><br>
-aj<br><br>Am 10.12.09 19:59, schrieb Justin Dunsworth:<br>
<div>
<div></div>
<div>> I am running into a brand new issue today that I can't, for the life<br>> of me, figure out. I wrote a standard page to insert data into a MySQL<br>> table using Z SQL methods from a form like I always have but for some<br>
> strange reason it's running the same query twice, thus adding a<br>> duplicate entry.<br>><br>> I have confined the original code in it's own document, checked,<br>> double checked, and still no avail. Here's the code for the page:<br>
><br>> <dtml-var frame_header><br>> <dtml-if addnewstatus><br>> <dtml-try><br>> <dtml-call "RootSQLMethods.admin.Status_Add(_.None,_)"><br>> <dtml-call "RESPONSE.redirect(BASE2+'/statuses')"><br>
> <dtml-except><br>> <p>Error while submitting! Status not added.</p><br>> <br>Error type: <dtml-var error_type><br>> <br>Error value: <dtml-var error_value><br>
> </dtml-try><br>> </dtml-if><br>> <form action="&dtml-URL;" method="post"><br>> <table class="tborder" align="center" width="30%" cellspacing="0" ><br>
> <tr><td class="tcat" align="center" colspan="2" style="font-size:<br>> 12pt;">Add New Status</td></tr><br>> <tr><td width="35%" align="right"><b>Name:</b></td><td<br>
> width="65%"><input type="text" name="name_add" size=15></td></tr><br>> <tr><td width="35%" align="right"<br>> valign="top"><b>Description:</b></td><td width="65%"><textarea<br>
> name="description_add" cols=25 rows=4></textarea></td></tr><br>> <tr><td width="35%" align="right"><b>Sort:</b></td><td<br>> width="65%"><input type="text" name="sort_add" value="5" size=1></td></tr><br>
> <tr><td align="center" colspan="2"><hr></td></tr><br>> <tr><br>> <td><input type="hidden" name="addnewstatus" value="1"></td><br>
> <td><br>> <button class="button" onclick="this.form.submit()">Add<br>> Status</button>&nbsp;&nbsp;<br>> <button class="button" onclick="window.location = '<dtml-var<br>
> BASE2>/statuses'; return false;">Cancel</button><br>> </td><br>> </tr><br>> </table><br>> </form><br>> <dtml-var frame_footer><br>><br>
> I can run the SQL Method by itself and it works just fine (only<br>> inserting it once) but when run as a separate page it adds the two.<br>><br>> Any assistance is appreciated<br>><br>><br></div></div>
> _______________________________________________<br>> Zope maillist - <a href="mailto:Zope@zope.org" target="_blank">Zope@zope.org</a><br>> <a href="https://mail.zope.org/mailman/listinfo/zope" target="_blank">https://mail.zope.org/mailman/listinfo/zope</a><br>
> ** No cross posts or HTML encoding! **<br>> (Related lists -<br>> <a href="https://mail.zope.org/mailman/listinfo/zope-announce" target="_blank">https://mail.zope.org/mailman/listinfo/zope-announce</a><br>
> <a href="https://mail.zope.org/mailman/listinfo/zope-dev" target="_blank">https://mail.zope.org/mailman/listinfo/zope-dev</a> )<br>
><br><font color="#888888"><br><br>--<br>ZOPYX Ltd. & Co KG \ zopyx group<br>Charlottenstr. 37/1 \ The full-service network for your<br>D-72070 Tübingen \ Python, Zope and Plone projects<br>
<a href="http://www.zopyx.com/" target="_blank">www.zopyx.com</a>, <a href="mailto:info@zopyx.com" target="_blank">info@zopyx.com</a> \ <a href="http://www.zopyxgroup.com/" target="_blank">www.zopyxgroup.com</a><br>------------------------------------------------------------------------<br>
E-Publishing, Python, Zope & Plone development, Consulting<br><br><br></font></blockquote></div></div></div><br></blockquote></div><br>