Swish-e Indexer
ternto333 - April 30, 2008 - 01:33
I'm getting this ugly error whenever a search result matches. It will still give me the file that found the search pattern, but it displays
# warning: Invalid argument supplied for foreach() in /var/www/drupal-5.7/modules/node/node.module on line 525.
# warning: implode() [function.implode]: Bad arguments. in /var/www/drupal-5.7/modules/node/node.module on line 529.
# user warning: 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE in /var/www/drupal-5.7/includes/database.mysql.inc on line 172.Delving into the code, I found out that the reason this error is happening is because the file that matches is not in the database. It should be in swish_fulltext and files if I'm not mistaken. The problem is I don't know how to get these files inserted into the database. I've tried running the cron manually, I've tried re-indexing swish-e. Nothing. By the way, swish-e is working fine when it indexes. It displays
* Indexing done!
Elapsed time: 00:00:02 CPU time: 00:00:00
10 files indexed. 3,564,302 total bytes. 3,360 total words.
* Your Swish-E settings has been saved.which is the correct number of files, but it never adds to the files table, and hence results in that error. I've got Drupal 5.7 and Swish-E 2.4.5. And it's running on Ubuntu 7.