Dev install fails
| Project: | Fuzzy Search |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
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.

#1
5x.1.2 is fine and works very well.