Discussions now appearing!

We have been posting discussions and although we could see them in the database they weren't appearing on the website. I suspected this was a problem with sphinx not indexing them correctly. Then we found that the MySQL password had been changed but not updated in /usr/local/sphinx/etc/sphinx.conf.

However, restarting Sphinx still did not fix the problem and Sphinx complained with several warnings similar to

precaching index 'forums_idx'
WARNING: index 'forums_idx': '/home/xpapers/etc/wordforms.txt' differs from the original

Then I re-read the documentation! Although we had set up cron jobs the example provided does not include re-indexing Sphinx so it's necessary to run the following from time to time.

$SPHINX/bin/indexer --all --rotate

Now the discussions are appearing and seem to be working fine.