ID: 20583
User updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Feedback
+Status: Open
Bug Type: Variables related
Operating System: RedHat 7.2
PHP Version: 4CVS-2002-11-22 (stable)
New Comment:
Well perhaps I initially reported the bug in the wrong category from
the dropdown selection, since it seemed like it was a variables related
problem.
At this point, if I remove basically any of the lines from the code
segment given above, the error goes away. So based on this, here are
the three factors that I have been able to deduce are required to
recreate the bug.
1) Turn off cookies
2) Use sessions
3) Use the OCI module.
Basically, do everything I'm doing above in the code segment I sent
you. If I could have simplified it any more, than I would have.
However, the removal of any lines caused the problem to go away, which
is what leads me to believe it's a combination of all three of the
things I just listed.
>From the sample output I gave you, you can see that it's interpretting
a simple string assignment statement to the $sql variable as some sort
of object/resource. This is why I reported the bug as a variables
related issue, but maybe it isn't. Maybe it's all related to the OCI
module and PHP sessions.
Thank you.
Previous Comments:
------------------------------------------------------------------------
[2002-12-19 19:30:54] [EMAIL PROTECTED]
you're focussing on the wrong issue. It should be *self-contained*. Can
you still reproduce the issue, when you strip the ora_* stuff and
without sessions? If not, add sessions back in, then the ora_*.
>From what you're reporting:
<?php
$one='one';
$two='two';
print "$one $two";
?>
should result in 'one one'.
If this isn't the case, then it's not a variable issue, but specific to
some module. Unless we find out what module causes the behavior,
there's not much we can do.
------------------------------------------------------------------------
[2002-12-19 15:25:15] [EMAIL PROTECTED]
Ok, I've been able to narrow this bug down to a much simpler PHP
script. We have also confirmed that it is definitely a problem with the
newer version of PHP since we are running an identical script on
production, with an older version of PHP, and it is error free.
The following script should allow you to recreate the problem. You
should disable cookies on the browser in order to have the error
recreated each subsequent refresh. Otherwise, the error will only
happen the first time you view the page, and will be gone on
refreshes.
______________________________________________________
<?
session_start();
$db_sid = "SID_VALUE";
$oralogin = "scott";
$orapass = "tiger";
$conn_ora = OCIPLogon($oralogin, $orapass, $db_sid);
if (empty($_GET["view_all"])) {
$_GET["view_all"] = $_SESSION["view_all"];
}
$view_all = $_GET["view_all"];
session_register("view_all");
$sql = "select SOME_FIELDS_FROM_DATABASE ";
if ($mgt_user_row["SUPER_USER_FLAG"] == "Y" && $_GET["view_all"] ==
"Y") {
$sql .= "from SOME_TABLE_NAMES ";
} else {
$sql .= "from SOME_TABLE_NAMES ";
}
$another = "hello world";
$obviously_messed_up = "php";
$stmt = OCIParse($conn_ora, $sql);
print "SQL = $sql<br>";
print "Another = $another<br>";
print "Obviously Messed Up = $obviously_messed_up<br>";
?>
____________________________________________________
Output of Above Code:
SQL = Resource id #3
Another = Resource id #3
Obviously Messed Up = Resource id #3
------------------------------------------------------------------------
[2002-12-11 01:03:31] [EMAIL PROTECTED]
Please provide us a complete, self-contained and short script which can
be used to reproduce this.
(you're most likely doing something wrong..)
------------------------------------------------------------------------
[2002-12-10 19:12:37] [EMAIL PROTECTED]
We have upgraded our PHP to the version given below, and are still
experiencing the same problems.
Thanks
------------------------------------------------------------------------
[2002-12-07 15:41:30] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php4-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-latest.zip
------------------------------------------------------------------------
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/20583
--
Edit this bug report at http://bugs.php.net/?id=20583&edit=1
