Project:Fuzzy Search
Version:5.x-1.x-dev
Component:Code
Category:bug report
Priority:critical
Assigned:Unassigned
Status:closed (fixed)

Issue Summary

The latest dev install fails to work, even after db update
When searching the following is thrown.

* user warning: Unknown column 'n.nid' in 'field list' query: SELECT COUNT(DISTINCT(n.nid)) FROM (SELECT n.nid, CEILING(SUM(completeness)) completeness, SUM(score) score FROM search_fuzzy_index AS n WHERE (ngram = 'iro' AND completeness <50.1) OR (ngram = 'ron' AND completeness <50.1) GROUP BY word_id HAVING SUM(completeness) > 10 ORDER BY completeness DESC, score DESC) AS n in /home/xxx/public_html/includes/database.mysql.inc on line 172.
* user warning: Unknown column 'ngram' in 'where clause' query: SELECT n.nid, SUM(percent) AS completeness, SUM(score) AS score FROM (SELECT n.nid, SUM(completeness) percent, SUM(score) score FROM search_fuzzy_index AS s LEFT JOIN node AS n ON (n.nid = s.nid) WHERE (( (ngram = 'iro' AND completeness <50.1) OR (ngram = 'ron' AND completeness <50.1)) AND n.status = 1) GROUP BY word_id HAVING percent > 10) AS n GROUP BY n.nid ORDER BY completeness DESC, score DESC LIMIT 0, 10 in /home/xxx/public_html/includes/database.mysql.inc on line 172.

Comments

#1

5x.1.2 is fine and works very well.

#2

Status:active» closed (fixed)

I recently took over this module. I'm going through all the old issues and closing them if possible. I'm not making any changes other than security fixes to the Drupal 5 version.

If you would still like to see this in the Drupal 6 version, please create a new issue or reopen this one, changing the version number.

Thanks,

awolfey