I've bumped into an odd problem on my local running version of Magento 126.96.36.199. I installed the Fishpig Splash Pages plugin which was working fine, but I uninstalled it (as I was testing different plugins to see which worked best).
I then decided this extension was the best one that was going to suit my requirements so I reinstalled it. After this install, One or more of the Indexes are not up to date - meaning I had to run the Attribute Splash reindex, but when running this I received the error:
Cannot initialize the indexer process. I then tried manually running the indexer via
\shell\indexer.php --reindex - and this produced some PHP errors that indicate the tables don't even exist.
I then created a brand new install of Magento running 188.8.131.52 - the plugin installed fine and correctly created the splash pages database tables. What could be causing my other copy not to do so?