#24371 [Opn->Csd]: bug search broken
| From: | philip@php.net | Date: | Sat, 28 Jun 2003 10:32:05 +0000 |
| Subject: | #24371 [Opn->Csd]: bug search broken | ||
| References: | 1 | Groups: | php.mirrors |
| Request: | Send a blank email to php-mirrors+get-19002@lists.php.net to get a copy of this message | ||
ID: 24371
Updated by: philip@php.net
Reported By: phpbug280603 at smayw dot nask dot com
-Status: Open
+Status: Closed
Bug Type: Website problem
Operating System: any
PHP Version: 4.3.3RC1
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2003-06-28 04:35:30] 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
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24371&edit=1