PostgreSQL Installation Notes

If your PostgreSQL installation does not include the SOUNDEX() function, then you should uncheck "Enable spelling suggestions (Did you mean...)" in the Search Settings section on the Settings tab. Failure to do so will result in a fatal error if a search is performed on a word which does not appear in the database. A message like: 'The search "kabloopdaloop" did not match any documents' is always preferable to: 'Fatal error: Call to a member function errorInfo() on boolean in...'

NOTE ON SOUNDEX(): By default, the SOUNDEX() function is not installed with PostgreSQL. When you search the web on how to enable it, you get LOTS of information and STILL have no idea how to enable it. It is very easy. Included in this download is fuzzystrmatch.sql. Put it in the PostgreSQL directory labeled ".../share/contrib/". Go to your Postres SQL Shell, log in as 'postgres' to the default database, and run "\i ..share/contrib/fuzzystrmatch.sql". Then switch to the database you created for sphider and run the SAME EXACT command. SOUNDEX() should now be functioning.

SQLite Installation Notes

If your SQLite installation does not include the SOUNDEX() function, then you should uncheck "Enable spelling suggestions (Did you mean...)" in the Search Settings section on the Settings tab. (This is UNchecked by default.) Failure to do so will result in a fatal error if a search is performed on a word which does not appear in the database. A message like: 'The search "kabloopdaloop" did not match any documents' is always preferable to: 'Fatal error: Call to a member function errorInfo() on boolean in...'

NOTE ON SOUNDEX(): By default, binary distributions of SQLite for Windows have the soundex() function disabled. It can be enabled by doing your own compile from source code and setting the SOUNDEX option. This does not seem to be the case for Linux distributions. Soundex() works out of the box on Ubuntu 16.04.