I'm running Drupal 5.2 and tested the August 22th dev release. And I got some errors in the log.

I got this error right after enabling the module

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_IMCREMENT PRIMARY KEY, nid int(11) NOT NULL, word_id int(11' at line 2 query: CREATE TABLE search_fuzzy_index ( id int(11) NOT NULL AUTO_IMCREMENT PRIMARY KEY, nid int(11) NOT NULL, word_id int(11) NOT NULL, ngram varchar(6) character set utf8 NOT NULL, completeness double NOT NULL, score decimal(8,2) NOT NULL, ) /drupal/includes/database.mysql.inc on line 172.

I got this when trying to search

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY n.nid ORDER BY completeness DESC, score DESC LIMIT 0, 10' at line 1 query: SELECT DISTINCT(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) INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 251 AND na.realm = 'tac_lite') OR (na.gid = 252 AND na.realm = 'tac_lite') OR (na.gid = 232 AND na.realm = 'tac_lite') OR (na.gid = 234 AND na.realm = 'tac_lite') OR (na.gid = 250 AND na.realm = 'tac_lite') OR (na.gid = 233 AND na.realm = 'tac_lite') OR (na.gid = 280 AND na.realm = 'tac_lite') OR (na.gid = 236 AND na.realm = 'tac_lite') OR (na.gid = 376 AND na.realm /drupal/includes/database.mysql.inc on line 172.

The table doesn't exist errors filled 2000 pages in the log

Table 'drupal.search_fuzzy_index' doesn't exist query: DELETE FROM search_fuzzy_index WHERE nid = 1 /drupal/includes/database.mysql.inc on line 172.
This is just an example. The last error varied a bit depending on the query. It appeared when I tried to run cron.

Comments

BlakeLucchesi’s picture

BlakeLucchesi commented
Status: Active » Fixed

This has been fixed. Please download the latest dev release (dated aug 24) and reinstall the module, the install file has an error so the word index table did not get created on installation. If you want to load the table on your own and not have to re-download the new package you can with the following sql query:

CREATE TABLE `search_fuzzy_index` (
  `id` int(11) NOT NULL auto_increment,
  `nid` int(11) NOT NULL,
  `word_id` int(11) NOT NULL,
  `ngram` varchar(6) character set utf8 NOT NULL,
  `completeness` double NOT NULL,
  `score` decimal(8,2) NOT NULL,
  PRIMARY KEY  (`id`)
)
Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)