#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] [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
#24952 [Bgs->Opn]: PHP 4.3.2 + Postgresql 4.3.x whitout SSL insert 2 elements
ID: 24952
User updated by: sirber at myrealbox dot com
-Summary: PHP .3.2 + Postgresql 4.3.x whitout SSL insert 2
elements
Reported By: sirber at myrealbox dot com
-Status: Bogus
+Status: Open
Bug Type: PostgreSQL related
Operating System: Gentoo Linux
PHP Version: 4.3.2
New Comment:
need to be fixed asap :)
Previous Comments:
[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.
[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.
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
#24952 [Bgs]: PHP .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: Bogus Bug Type: PostgreSQL related Operating System: Gentoo Linux PHP Version: 4.3.2 New Comment: 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... Previous Comments: [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. [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.") alert(rsCur->currval) //_2nd insert___ pg_query($ConnectID,"INSERT INTO tblassdivision ") rsCur = pg_fetch(pg_query(SELECT currval from tblass.") alert(rsCur->currval) 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... 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
#24952 [Bgs]: PHP .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: Bogus Bug Type: PostgreSQL related Operating System: Gentoo Linux PHP Version: 4.3.2 New Comment: I got it few times on Mozilla, but it's at ~90% with IE. Previous Comments: [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.") alert(rsCur->currval) //_2nd insert___ pg_query($ConnectID,"INSERT INTO tblassdivision ") rsCur = pg_fetch(pg_query(SELECT currval from tblass.") alert(rsCur->currval) 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
#24952 [Opn]: PHP .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: Seems to bug with Internet Explorer only... Previous Comments: [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
#24952 [NEW]: PHP .3.2 + Postgresql 4.3.x whitout SSL insert 2 elements
From: sirber at myrealbox dot com Operating system: Gentoo Linux PHP version: 4.3.2 PHP Bug Type: PostgreSQL related Bug description: PHP .3.2 + Postgresql 4.3.x whitout SSL insert 2 elements 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 bug report at http://bugs.php.net/?id=24952&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=24952&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=24952&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=24952&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=24952&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=24952&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=24952&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=24952&r=support Expected behavior: http://bugs.php.net/fix.php?id=24952&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=24952&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=24952&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=24952&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=24952&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=24952&r=dst IIS Stability: http://bugs.php.net/fix.php?id=24952&r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=24952&r=gnused
