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
Reporternicdev 
Assigned To 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
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:
<LOG>
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 u.incidentid=i.id GROUP BY u.incidentid ORDER BY score, i.id DESC LIMIT 0, 20
<LOG>

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 - 2019 MantisBT Team
Powered by Mantis Bugtracker