php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #24371 bug search broken
Submitted: 2003-06-28 04:35 UTC Modified: 2003-06-28 05:32 UTC
From: phpbug280603 at smayw dot nask dot com Assigned:
Status: Closed Package: Website problem
PHP Version: 4.3.3RC1 OS: any
Private report: No CVE-ID: None
 [2003-06-28 04:35 UTC] phpbug280603 at smayw dot nask dot com
Description:
------------
typing a search phrase in the little box at the top of the 
screen generates this: 
 
SELECT SQL_CALC_FOUND_ROWS DISTINCT bugdb.*, 
TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM 
bugdb, bugdb_comments WHERE bug_type != 
'Feature/Change Request' AND MATCH (email,sdesc,ldesc) 
AGAINST ('undefined reference to 
`php_check_open_basedir_ex\\\'') AND 
(SUBSTRING(php_version,1,1) = '4' OR 
SUBSTRING(php_version,1,1) = '5') LIMIT 0,30 
Column: 'email' in where clause is ambiguous 

Expected result:
----------------
list of relevant bugs 

Actual result:
--------------
error quoted above 

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-06-28 05:32 UTC] philip@php.net
This worked locally, it seems I have a different FULLTEXT index name though as email wasn't ambigious for me.  This has been fixed and is working now.

A related problem (which happened right after) was distinct and a bugdb_comments table select were happening on every request, when only the recently added author_email option  wanted this.  That's been fixed too.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved.
Last updated: Wed Jun 17 19:00:01 2026 UTC