[Zope] SQL Method running twice

Justin Dunsworth justin.dunsworth at gmail.com
Tue Dec 15 14:09:08 EST 2009


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 at 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 at 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 at 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>&nbsp;&nbsp; <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 at 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 at zopyx.com  \  www.zopyxgroup.com
> >>>
> ------------------------------------------------------------------------
> >>>
> >>>
> E-Publishing, Python, Zope & Plone development, Consulting
> >>>
> >>>
> >>>
> >
> >
> > ----------------------------------------------------------------------
> >
> >
> >
> _______________________________________________
> > Zope maillist  -  Zope at 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 at 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-----
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20091215/7cace621/attachment.html 


More information about the Zope mailing list