#24952 [Opn]: PHP 4.3.2 + Postgresql 4.3.x whitout SSL insert 2 elements

ID: 24952 User updated by: sirber at myrealbox dot com Reported By: sirber at myrealbox dot com Status: Open Bug Type: PostgreSQL related Operating System: Gentoo Linux PHP Version: 4.3.2 New Comment: changed email address Previous Comments: ------------------------------------------------------------------------ [2004-01-12 11:47:12] sirber at myrealbox dot com need to be fixed asap :) ------------------------------------------------------------------------ [2004-01-12 11:37:30] sirb3r at yahoo dot ca The bug strike again, in Internet Explorer, whitout SSL. PostgreSQL: 7.3.5 PHP: 4.3.4-r2 Apache: 2.0.48-r1 From apache logs: the pages are asked only once: page1 - save - page2 From Javascript: the output from page "save" is only sent once (tested with "alert") From PHP: the script is executed twice: 12 2004-01-12 11:08:34.834394 Ajout de contrat: PID:10607 ID:3200 13 2004-01-12 11:08:34.900397 Ajout de contrat: PID:24142 ID:3201 with this code: pg_query("INSERT INTO tblasscontrat (enttitulaireid, refassureurid, nom, numero, dateeffective, dateterminaison , ident_emp, creepar, type) VALUES (" . $entTitulaireID . ", " . $selAssureur . ", '" . $txtNom . "', '" . $txtNo . "', " .$txtDateEffective . ", " . $txtDateTerminaison . ", " . GetMyPid() . ", " . $sUserID . ", " . $Type.")"); $sqlLastID = pg_query("SELECT currval('tblasscontrat_asscontratid_seq') AS lastid FROM tblasscontrat"); $rsLastID = pg_fetch_object($sqlLastID); $rsLastID = $rsLastID->lastid; $req = "INSERT INTO tbllog (message) VALUES ('Ajout de contrat: PID:" . GetMyPid() . " ID:" . $rsLastID . "')"; pg_query($req); Possible cause: from: Internet Explorer 6.0.2800.1106.XPSP2.030422-1633 - apache - mod_php - postgresql mod_php execute the scripts 2 times, but only return the first one to apache. from: Internet Explorer 6.0.2800.1106.XPSP2.030422-1633 - apache - mod_ssl - mod_php - postgresql the script is only executed once. On Mozilla 1.5, with or without SSL, the script is only executed once. I tryed with HTTP 1.0/1.1, with and without proxy (squid), and this error happend on both of my servers, both running gentoo linux. ------------------------------------------------------------------------ [2003-08-06 08:00:04] sirber at myrealbox dot com Ths page isn't reloaded, and it's processed only 1 time. I think there is a conflict between mod_php and apache, coz when the page goes through mod_ssl it's working #1... ------------------------------------------------------------------------ [2003-08-05 18:05:40] sniper@php.net 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. ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/24952 -- Edit this bug report at http://bugs.php.net/?id=24952&edit=1