All the links on my Magento 1.14.2 site are showing up as (literally):
".../catalog/product/view/id/1234/s/my-really-cool-product" instead of ".../my-really-cool-product"
Reindexing seems to build the rewrites in the database, but they don't seem to be acted upon at all. When traffic comes in to the site from ".../my-really-cool-product" it results in a page not found error.
I copied the files of the site to another directory and am using an older version of the database, and the issue does not seem to be replicated, so I'm thinking that the problem lies somewhere in the database, but I haven't been able to find it yet.
Any ideas what might be going on here and how to fix it?