On Thu, 2004-04-15 at 22:27, Josh Endries wrote: > When I was setting up the whitelist/blacklist stuff in webmail, I > noticed it was adding two records for every one entry on the list > (when I added [EMAIL PROTECTED], two would be put in the db). Deleting > them also removed two, so I didn't notice at first. After screwing up > some things and discovering a huge table with lots of duplicates, I > started watching the logs. > > After spending probably hours playing with loops and other PHP things > I noticed that, at the end of each script I ran, the last (and only > the last) query got repeated. If I was adding a user to the whitelist, > the final INSERT query was sent/processed two times. I hacked around > this (had to get it up and running :( sigh) by adding a "null" 'SELECT > '' from table..." query, which was sone twice. Since this was the last > query, the "real" queries were only done once, so its a patch but not > a fix.
I'm not very familiar with PHP. But I have had experiences with Perl CGIs multiply-executing under certain configurations if the program does not explicitly exit(); (as opposed to just having no more commands). Just a shot in the dark, but you never know. :) -- Sean Quinlan <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
