We have Magento CE 1.9.1. We recently enabled multi store functionlity to support city wise stores. All the functionlity seems to be setup fine and working as desired. However we noticed one thing is broken. The catalogue view URLs are not working for user accounts that were created before we switched to the Multi Store setup. All the links work fine for not logged in users and for user accounts created after the setup was done. It does not work only for accounts that were created prior to the multi store setup. The users just get redirected to the home page with a 302 redirect to the home page url. The same URL works fine for not logged in users as well as logged in users with the new created accounts.
We have looked through all the customer tables for any mapping. All user accounts are mapped to the original default store ID (which still exists). We have deleted all the Session files, Truncted the core_url_rewrite table and recreated all the indexes again.
Can someone please guide where to look for a solution?