php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #18904 search does not allow *all* words
Submitted: 2002-08-14 10:32 UTC Modified: 2002-08-15 04:48 UTC
Votes:1
Avg. Score:1.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: ne at clickcom dot com Assigned:
Status: Wont fix Package: Website problem
PHP Version: 4.2.2 OS: any
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
MUST BE VALID
Solve the problem:
18 - 5 = ?
Subscribe to this entry?

 
 [2002-08-14 10:32 UTC] ne at clickcom dot com
Today i was searching for a problem where even though my time_limit was set to 30 seconds, I have users getting an error of "Maximum execution time of 5 seconds exceeded" (even though it's set to 30). When I try to search for that phrase, it ignores the "of" and "5" in the search. Ignoring the "5" in this case causes me to get 100's of results instead of more relavent results. I tried putting the search criteria in quotes however the results page then just called me a Bad Hacker and still didn't work.

Can anything be done to allow for it to require ALL the keywords to be used or to allow explicit phrase matching? I imagine you're just doing a full-text search but would it be possible to add a LIKE search as an option as well for cases like this?

John

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-08-15 02:30 UTC] georg@php.net
The php.net site uses the mysql fulltext search. This 
means, that you can't search for words with length < 4 and 
also words which match 50% of the rows have a minor weight.

The LIKE "%word%" statement doesn't work, cause you can't 
use an index. (Fulltablescan with such amount of data 
would paralyze php.net).

 [2002-08-15 04:48 UTC] goba@php.net
AFAIK only bugs.php.net uses the MySQL FTS feature. Other siets are using htdig (htdig.org), which has some limitations, and sometimes small bugs...
 
PHP Copyright © 2001-2019 The PHP Group
All rights reserved.
Last updated: Sun Jun 16 13:01:28 2019 UTC