ID: 24952 Updated by: [EMAIL PROTECTED] Reported By: sirber at myrealbox dot com Status: Bogus Bug Type: PostgreSQL related Operating System: Gentoo Linux PHP Version: 4.3.2 New Comment:
Broken/invalid HTML has been the cause for these kind of problems before. It sometimes causes the page to get reloaded and thus you get duplicate entries in your DB. Previous Comments: ------------------------------------------------------------------------ [2003-08-05 16:12:34] sirber at myrealbox dot com I got it few times on Mozilla, but it's at ~90% with IE. ------------------------------------------------------------------------ [2003-08-05 14:45:35] [EMAIL PROTECTED] Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. If you cannot replicate the error accross all browsers then this is a browser issue and not a PHP one. ------------------------------------------------------------------------ [2003-08-05 12:35:41] grimskonk at hotmail dot com i would also like to add that we tried something to find the bug.. and it came up with a really weird error. In that same page where we only insert one row, we tried adding 2 new rows with a SELECT CURRVAL inbetweeen. Like this : //_____________________1st insert_______________________ pg_query($ConnectID,"INSERT INTO tblassdivision ....") rsCur = pg_fetch(pg_query(SELECT currval from tblass.") <script> alert(rsCur->currval) </script> //_____________________2nd insert_______________________ pg_query($ConnectID,"INSERT INTO tblassdivision ....") rsCur = pg_fetch(pg_query(SELECT currval from tblass.") <script> alert(rsCur->currval) </script> It inserted 4 rows with the ids 51,52,53,54 We got 2 popups.. but the weird thing is that it poped [53] and [54] instead of [51][53] / [52][54] As if a set of inserts were being made BEFORE the actual code, AND THEN it proceeds to the actual code ------------------------------------------------------------------------ [2003-08-05 11:48:00] sirber at myrealbox dot com Seems to bug with Internet Explorer only... ------------------------------------------------------------------------ [2003-08-05 11:42:39] sirber at myrealbox dot com Description: ------------ Gentoo make.conf: USE="-X -gnome -kde -qt perl 3dnow mmx crypt -cups gd gif -gtk imap -java jpeg mbox ncurses png postgres samba sse ssl tcpd zlib x86 apache" With apache (1 or 2), PHP 4.3.2-x and Postgresql 7.3.2-x, a pg_query($ConenctID, "INSERT INTO ..."); insert 2 elements. If I add mod_ssl, and use ssl, the same page insert only 1 element, which is normal. We made a lot of tests, and the pg_query is executed only once in both case, and the page is loaded only once too. Reproduce code: --------------- pg_query($ConnectID,"INSERT INTO tblassdivision (asscontratid, dateeffective, dateterminaison, concontactid, entdivisionid, conadresseid, creepar, creedate) values ( '$contratID', $txtDateEffective, $txtDateTerminaison, '$contactID', '$divisionID', '$conAdrID' ,'$sUserID', now())"); Expected result: ---------------- 1 new row Actual result: -------------- 2 new rows without mod_ssl 1 new row with mod_ssl ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=24952&edit=1
