php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #2758 joined MySQL queries fail
Submitted: 1999-11-18 19:12 UTC Modified: 2000-07-22 19:20 UTC
From: admin at i-1 dot net Assigned:
Status: Closed Package: MySQL related
PHP Version: 3.0.12 OS: BSD/OS 4.0 / 4.0.1
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: admin at i-1 dot net
New email:
PHP Version: OS:

 

 [1999-11-18 19:12 UTC] admin at i-1 dot net
After upgrading PHP from 4.0b2 to 4.02b3, the following MySQL query (which has not changed) no longer works:

select x.name, x.place, y.color, y.shade from locations as x, prefs as y 

The error returned is: 

Warning: x not found in MySQL result index 7 in mysql.php3 on line 26

Warning: y not found in MySQL result index 7 in mysql.php3 on line 26

Line 26 of mysql.php3 is:

$result = mysql_result($qhandle,$row,$field);

This has not changed either -- it worked yesterday :-)

The problem is reproducible, and is affecting all my php scripts which contain queries structured in the same fashion.

Config/Build options have only changed in one respect from 4.0b2 to 4.0b3; I had to compile with --disable-inline to work around a virtual memory exhaustion problem.

Here's the config line I used to build PHP:

--with-mysql=/usr/local/mysql \
        --with-apache=../apache_1.3.9 \
        --enable-track-vars \
        --disable-inline \
        --with-config-file-path=/var/www/conf

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-22 19:20 UTC] mrobinso at cvs dot php dot net
Bug report against php4 showing version 3.0.12.
Please reopen with correct version of problem persists.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri May 10 05:01:31 2024 UTC