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 )
