#24952 [Fbk->NoF]: PHP 4.3.2 + Postgresql 4.3.x without SSL inserts 2 elements

ID: 24952 Updated by: sniper@php.net -Summary: PHP 4.3.2 + Postgresql 4.3.x whitout SSL insert 2 elements Reported By: sirber at myrealbox dot com -Status: Feedback +Status: No Feedback Bug Type: PostgreSQL related Operating System: Gentoo Linux PHP Version: 4.3.2 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. And too old PHP version anyway. Previous Comments: ------------------------------------------------------------------------ [2004-01-13 14:28:32] sniper@php.net Does it happen if your page contains ONLY the code, no HTML at all? ------------------------------------------------------------------------ [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