php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #28043 table modifications delayed in script after header("Location")
Submitted: 2004-04-18 01:54 UTC Modified: 2004-04-29 23:07 UTC
From: silviup at go dot ro Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.3.5 OS: Linux Red Hat 9.0
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: silviup at go dot ro
New email:
PHP Version: OS:

 

 [2004-04-18 01:54 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-04-29 23:07 UTC] sniper@php.net 
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.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Sep 16 21:00:01 2025 UTC