I thought I had upgraded successfullyâ¦exceptâ¦
when I modify/add a product it successfully completes the operation, but I get the error message:
SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘my_database.catalog_product_index_price_tmp’ doesn’t exist
What is strange is that this error doesnât appear to be affecting things working properly, or perhaps I just havenât found out where yet!
Iâve done a search and havenât found anyone with the same error. Iâd be v grateful anyone could please help me with this, and if possible give me a newbieâs guide to resolving it?
I did the upgrade v carefully (by means of a fresh install and new db, imported my old db following instructions, copied my theme folders over, ran install wizard, reinstalled extensions, cleared cache via admin and manually deleted var/cache contents, refreshed/reindexed everything, etc.).