php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Fri May 03 22:01:33 2024 UTC