#28043 [Opn->Bgs]: table modifications delayed in script after header("Location")

ID: 28043 Updated by: sniper@php.net Reported By: silviup at go dot ro -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux Red Hat 9.0 PHP Version: 4.3.5 New Comment: 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. When a script code and logic are correct, this works fine. Check your code and ask support questions elsewhere. No bug here. Previous Comments: ------------------------------------------------------------------------ [2004-04-18 01:54:01] silviup at go dot ro 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 this bug report at http://bugs.php.net/?id=28043&edit=1