database connection
how come when we do a write process on our database, it sometimes write more than once. for instance, when we process a form action to write to the database, the database comes up with 3 similar values/data. our current setup: 1) red hat 7.0 2) zope 2.3.2 3) zeo 1.0b1 4) mysql 3.23.38 5) python 1.5.2 thanks in advance. Fritz Mesedilla Systems Administrator Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph Palm Pilot Software: TVSked - Download from the link below ---------------------------------------------------------------------------- http://contemplation401.tripod.com +Basta Ikaw Lord
User Error ? ;) Sorry I'm in a wicked mood today. ----- Original Message ----- From: "Fritz Mesedilla" <fritz.mesedilla@summitmedia.com.ph> To: <zope@zope.org> Sent: Thursday, June 21, 2001 10:08 AM Subject: [Zope] database connection
how come when we do a write process on our database, it sometimes write
more
than once.
for instance, when we process a form action to write to the database, the database comes up with 3 similar values/data.
our current setup: 1) red hat 7.0 2) zope 2.3.2 3) zeo 1.0b1 4) mysql 3.23.38 5) python 1.5.2
thanks in advance.
Fritz Mesedilla Systems Administrator
Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph
Palm Pilot Software: TVSked - Download from the link below -------------------------------------------------------------------------- -- http://contemplation401.tripod.com +Basta Ikaw Lord
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] database connectionwell, we all have those days. mine is probably tom. *grin* Fritz Mesedilla Systems Administrator Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph Palm Pilot Software: TVSked - Download from the link below ---------------------------------------------------------------------------- http://contemplation401.tripod.com +Basta Ikaw Lord -----Original Message----- From: Phil Harris [mailto:phil.harris@zope.co.uk] Sent: Thursday, June 21, 2001 5:13 PM To: fritz.mesedilla@summitmedia.com.ph; zope@zope.org Subject: Re: [Zope] database connection User Error ? ;) Sorry I'm in a wicked mood today. ----- Original Message ----- From: "Fritz Mesedilla" <fritz.mesedilla@summitmedia.com.ph> To: <zope@zope.org> Sent: Thursday, June 21, 2001 10:08 AM Subject: [Zope] database connection
how come when we do a write process on our database, it sometimes write
more
than once.
for instance, when we process a form action to write to the database, the database comes up with 3 similar values/data.
our current setup: 1) red hat 7.0 2) zope 2.3.2 3) zeo 1.0b1 4) mysql 3.23.38 5) python 1.5.2
thanks in advance.
Fritz Mesedilla Systems Administrator
Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph
Palm Pilot Software: TVSked - Download from the link below
-------------------------------------------------------------------------- -- http://contemplation401.tripod.com +Basta Ikaw Lord
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
for instance, when we process a form action to write to the database, the database comes up with 3 similar values/data.
It depends on the form action, your DTML or Python code and the user. Did the user press the submit-button multiple times? What do you mean exactly by "similar values/data"? I think you have to be more specific... Regards, René Pijlman
[Zope] database connectioni'm sorry i wasn't very specific. we have a message board on our site. and when a visitor tries to post a message, the message comes up 2 or more times. meaning, the message board gets flooded with duplicate messages. this also happens when users sign up to be members. their membership submit button produces multiple add records that an error comes up to them and says they have already signed up. thanks. Fritz Mesedilla Systems Administrator Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph Palm Pilot Software: TVSked - Download from the link below ---------------------------------------------------------------------------- http://contemplation401.tripod.com +Basta Ikaw Lord -----Original Message----- From: Fritz Mesedilla [mailto:fritz.mesedilla@summitmedia.com.ph] Sent: Thursday, June 21, 2001 5:09 PM To: zope@zope.org Subject: [Zope] database connection how come when we do a write process on our database, it sometimes write more than once. for instance, when we process a form action to write to the database, the database comes up with 3 similar values/data. our current setup: 1) red hat 7.0 2) zope 2.3.2 3) zeo 1.0b1 4) mysql 3.23.38 5) python 1.5.2 thanks in advance. Fritz Mesedilla Systems Administrator Summit Interactive, Inc. FHM | Seventeen | Candy | Cosmopolitan | Preview | Good Housekeeping femalenetwork.com | candymag.com | fhm.com.ph | cosmo.com.ph Palm Pilot Software: TVSked - Download from the link below -------------------------------------------------------------------------- -- http://contemplation401.tripod.com +Basta Ikaw Lord _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
we have a message board on our site. and when a visitor tries to post a message, the message comes up 2 or more times. meaning, the message board gets flooded with duplicate messages.
Ah, I see: there's a loop around your insert statement on line 482 of add_message.py that doesn't check its loop condition correctly :-) I'm sorry, but you'll have to be even more specific. Stories are hard to debug. Did you write this message board yourself, or is it a standard product that you downloaded from elsewhere? Is the source code available somewhere on the Net? Did you verify that the method that processes the form and adds the message is called only once? Regards, René Pijlman
participants (3)
-
Fritz Mesedilla -
Phil Harris -
Rene Pijlman