Posted by phayes on July 4, 2008 at 3:56am
Jump to:
| Project: | Fuzzy Search |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
here is the code to allow this module to be installed in postgresql environment
db_query("CREATE TABLE search_index_queue (
nid serial PRIMARY KEY,
module character(60) NOT NULL,
\"timestamp\" integer NOT NULL
)");
db_query("CREATE TABLE search_fuzzy_index (
id serial PRIMARY KEY,
nid integer NOT NULL,
word_id integer NOT NULL,
ngram varchar(6) NOT NULL,
completeness double precision NOT NULL,
score numeric(8,2) NOT NULL
)");
Comments
#1
You also need to modify line 216 to use proper drupal database abstraction.
Should be:
$query = db_query_range("SELECT nid FROM {search_index_queue}", 0, 150);#2
Thanks for your help on this. As I am putting in more work to this module I will make sure to include this in the next release.
#3
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