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.).