#24371 [Opn->Csd]: bug search broken

From: 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

« previous php.mirrors (#19002) next »