We currently have a Magento Community edition 188.8.131.52 store, we're facing issues with "Index product and categories URL rewrites" , it is stuck in processing and doesn't finish even if done through command line or cron jobs.
This problem is preventing our ability to add more store views thus results in not allowing us to add products via product import. On the import status it displays error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'templatename_magento.catalog_category_flat_store_7' doesn't exist (store_7 being the new store view we added).
It started when we tried adding a new store view to existing website and store. New store view shows up in "Store Manager" , but doesn't show up anywhere else. Tried re-indexing all indexes, which ran successfully except for the mentioned "index product and category URL rewrites." We have already tried clearing the URL rewrites table in MySQL and let Magento reindex it, but it did not work.
Bidder/Winner must be OK and legal to work with Adult Content. Our store contains adult products and content.
This project is a very urgent problem for us, we need to have 100% confirmation project will be able to be completed in the given time frame.
The issues are very specific, we also have error message/log of Magento's [url removed, login to view] reindexall. We will provide all specific information needed and will be asking more questions through PM's prior to selecting winner if necessary.