From: silviup at go dot ro
Operating system: Linux Red Hat 9.0
PHP version: 4.3.5
PHP Bug Type: MySQL related
Bug description: table modifications delayed in script after header("Location")
Description:
------------
It seems that modifications that result from an INSERT ... SELECT query in
a PHP script are sometimes not imediately available to another script
whose name apears in header("Location: ..."). I have been able to
reproduce this bug ONLY on my personal system: Red Hat 9.0 + MySQL 4.0.18
(installed from RPM) + PHP 4.3.5 (or 4.3.4) + apache 2.0.49 (or 1.3.29),
ONLY when making request from local computer and ONLY with a "INSERT ...
SELECT" query type.
It is weird that if I set DEBUG to TRUE I ALWAYS get 3 and I also get 3
ALWAYS when requesting the page from a remote location.
phpinfo() reports this in the Configure Command field:
'./configure' '--with-apxs=/usr/local/apache/bin/apxs' '--with-mysql=/usr'
'--with-config-file-path=/etc' '--enable-force-cgi-redirect'
'--disable-cgi' '--with-zlib' '--enable-bcmath' '--enable-calendar'
'--with-curl' '--enable-dio' '--with-dom' '--enable-exif' '--enable-ftp'
'--with-gettext' '--with-gmp' '--enable-mbstring' '--with-ncurses'
'--with-pgsql' '--with-gdbm' '--with-readline' '--with-libedit'
'--enable-sockets' '--enable-sysvmsg' '--enable-sysvsem'
'--enable-sysvshm' '--enable-wddx' '--enable-zend-multibyte'
Files /etc/php.ini and php.ini-dist are identical.
Reproduce code:
---------------
http://silviup.dap.ro/test/index.phps
http://silviup.dap.ro/test/index2.phps
Expected result:
----------------
I expect to see
#
3
Actual result:
--------------
Instead I see
# # # # # # # # # # #
3
or
# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #
# # # # # # # # # # #
3
or sometimes
#
3
--
Edit bug report at http://bugs.php.net/?id=28043&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=28043&r=trysnapshot4
Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=28043&r=trysnapshot5
Fixed in CVS: http://bugs.php.net/fix.php?id=28043&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=28043&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=28043&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=28043&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=28043&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=28043&r=support
Expected behavior: http://bugs.php.net/fix.php?id=28043&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=28043&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=28043&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=28043&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=28043&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=28043&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=28043&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=28043&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=28043&r=float
