Full-text Search Issues - not returning any results

Author	Message

Samuel

Full-text Search Issues - not returning any results Thu. Jun 25, '09 1:47 PM (permalink)

If you run into issue installing the search feature while setting up the software, you need to make sure that

your server has Full-text installed;
- ask your host for verification
your account has the permission to enable full-text for your database;
- ask your host to enable it for your db in case they don't allow the permission to your account

Once the set up completes successfully, the search engine should work. If after a while it starts acting weird like not returning any results,

Check the error log, and see if there is any SQLClient related error.
1. If you see this error: SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process,
  1. The problem was that the actual FTS service was disabled. So go into your services and make sure the following is running:
    
    SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
  2. Then use our database manager / SQL management studio, run this statement:
    EXEC sp_fulltext_service 'restart_all_fdhosts'
  3. Follow the steps below to re-build the catalog;
If there is no error, the catalog may become corrupted for some reason (for no reason). If so, you have to
1. rebuild the full-text search by re-running the setup program;
2. Skip to "step 4", and click the button to rebuild;
3. It takes a while for the catalog to re-populate which means you won't be able to search immediately.