Magento – Upgrade from 1.12 to 1.13.1 and 404 pages

404-pageee-1.13upgrade

we have successfully upgraded Magento from 1.12 to 1.13.1 .

All Modules and everything is working fine except the Category and product pages.
All category and Product pages shows 404 page.

All other links and default pages like login, my account etc etc are working fine.

Any idea what could be the problem?

Thanks

Best Answer

First off, be sure to rebuild your indexes via shell

php shell/indexer.php reindexall

They're set to "Scheduled" in admin, and you can see exactly how that's handled by checking -

System->Configuration->(Advanced)Indexing

They should be set to "On Save", but experience tells me that you should do it manually anyway.

If that fails, open your database and check that during the upgrade these two tables have been populated -

catalog_product_entity_url_key 
catalog_category_entity_url_key 

If they haven't, then you'll either need to attempt to upgrade again, or populate them manually.

Let us know how you get on.