|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2003-08-05 11:42 UTC] 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 PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 05:00:02 2025 UTC |
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.