I forgot to add version: Zope 2.11.4-final, python 2.4.4, win32 and using ZMySQLDA 2.0.9
On Tue, Dec 15, 2009 at 11:34 AM, Justin Dunsworth < justin.dunswo...@gmail.com> wrote: > 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 )
