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] [EMAIL PROTECTED]
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
