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
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: phpbug280603 at smayw dot nask dot com
New email:
PHP Version: OS:

 

 [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 20:00:01 2026 UTC