firemanruss, thanks, spot on! The above didnt work, followed your instructions and it worked a treat!
My issue was on Magento version 18.104.22.168, pretty much same problem, but I was getting the Stock indexer running error in the Magento backend when trying to re-index.
Followed firemanruss\’s instructions and that sorted it.
I had just transfered onto a VPS.
I had the same issue with 2 sites, the first worked, I got this error from putty when I try ran the reindex on the second site though, any ideas?
PHP Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 7680 bytes) in /var/www/vhosts/#/httpdocs/app/code/core/Mage/Index/Model/Indexer.php on line 59