Monday, May 13, 2013

Upgrading TTRSS - Sphinx search, schema changes and config.php


After you complete the upgrade, you'll want to check:
  1. config.php-dist to see if there have been any changes.  I have a post which describes a utility that can assist.
  2. Schema changes.  TTRSS will walk you through the procedure, if needed, when you first try to login after an upgrade.
  3. Rebuild the Sphinx full-text index of the ttrss database.  You'll want to do this if there has been a schema change.
To rebuild the Sphinx full-text index:

sudo systemctl stop searchd.service 

Run the indexer to create the full-text index of the ttrss database:

cd /bin
sudo ./indexer --all

sudo systemctl start searchd.service 

That's it.  You're done.