SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001440SiT!searchpublic2011-01-20 14:552012-04-02 13:29
Assigned To 
PlatformOSOS Version
Product Version3.62 LTS 
Target VersionFixed in Version 
Summary0001440: When searching for a phrase the search result is incorrect
DescriptionWhen searching for a phrase like: "our known failure text in log" With the double quotes the search fails, it gives 2025 results, when i know it should give maybe 1 or 2 results.

When looking at the sql query i see this:
SELECT SQL_CALC_FOUND_ROWS *,incidentid AS id, i.title, MATCH (bodytext) AGAINST ('"our known failure text in log"' IN BOOLEAN MODE) AS score FROM `sit_updates` as u, `sit_incidents` as i WHERE (MATCH (bodytext) AGAINST ('"our known failure text in log"' IN BOOLEAN MODE)) AND GROUP BY u.incidentid ORDER BY score, DESC LIMIT 0, 20

This is because we use the function "cleanvar" on the variable "q", which translates the quotes
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
User avatar (0004472)
nicdev (developer)
2012-04-02 13:29

Hi Ivan, did we ever investigate this? It seems too long ago, but i did see it is still an issue

- Issue History
Date Modified Username Field Change
2011-01-20 14:55 nicdev New Issue
2011-01-25 15:49 ivan Status new => acknowledged
2012-04-02 13:29 nicdev Note Added: 0004472

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker