man, 30/07/2012 - 10:32
Magento version:
Har du opgraderet din shop til Magento 1.7.x og oplever fejlen SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'report_viewed_product_aggregated_daily' already exists, så er en mulig løsning at slette disse tre tabeller:
- report_viewed_product_aggregated_daily
- report_viewed_product_aggregated_monthly
- report_viewed_product_aggregated_yearly
Det kan du gøre ved at køre følgende SQL-Query:
DROP TABLE `report_viewed_product_aggregated_daily`, `report_viewed_product_aggregated_monthly`, `report_viewed_product_aggregated_yearly`;