Fatal error: Uncaught Exception: Error: Table 'mz_temp_common_product' already exists<br />Error No: 1050<br />CREATE TEMPORARY TABLE mz_temp_common_product SELECT p.product_id, p.manufacturer_id, p.stock_status_id, p.quantity, (SELECT AVG(rating) FROM oc_review WHERE product_id = p.product_id AND status = '1' GROUP BY product_id) AS rating, p.price, (SELECT price FROM oc_product_discount WHERE product_id = p.product_id AND customer_group_id = '1' AND quantity = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE product_id = p.product_id AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS special, (SELECT 100 - ((price * 100) / p.price) FROM oc_product_special ps WHERE product_id = p.product_id AND customer_group_id = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1) AS special_perc FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id in /var/www/lecturewalaOP/system/library/db/mysqli.php:49 Stack trace: #0 /var/www/lecturewalaOP/system/library/db.php(45): DB\MySQLi->query() #1 /var/www/lecturewalaOP/catalog/model/extension/maza/catalog/product.php(872): DB->query() #2 /var/www/lecturewalaOP/storage/modification/system/engine/loader.php(248): ModelExtensionMazaCatalogProduct->createTempTable() #3 /var/www/lecturewalaOP/system/engine/proxy.php(47): Loader->{closure}() #4 /var/www/lecturewalaOP/catalog/controller/extension/module/mz_filter.php(1207): Proxy->__call() #5 /var/www/lecturewalaOP/catalog/controller/extension/module/mz_filter.php(65): ControllerExtensionModuleMzFilter->loadData() #6 /var/www/lecturewalaOP/storage/modification/system/engine/action.php(79): ControllerExtensionModuleMzFilter->index() #7 /var/www/lecturewalaOP/storage/modification/system/engine/loader.php(48): Action->execute() #8 /var/www/lecturewalaOP/catalog/controller/extension/maza/layout_builder.php(684): Loader->controller() #9 /var/www/lecturewalaOP/catalog/controller/extension/maza/layout_builder.php(390): ControllerExtensionMazaLayoutBuilder->getModuleOutput() #10 /var/www/lecturewalaOP/catalog/controller/extension/maza/layout_builder.php(24): ControllerExtensionMazaLayoutBuilder->resolveShortcode() #11 /var/www/lecturewalaOP/storage/modification/system/engine/action.php(79): ControllerExtensionMazaLayoutBuilder->index() #12 /var/www/lecturewalaOP/storage/modification/system/engine/loader.php(48): Action->execute() #13 /var/www/lecturewalaOP/catalog/controller/extension/maza/event/controller/product/search.php(8): Loader->controller() #14 /var/www/lecturewalaOP/storage/modification/system/engine/action.php(79): ControllerExtensionMazaEventControllerProductSearch->before() #15 /var/www/lecturewalaOP/system/engine/event.php(62): Action->execute() #16 /var/www/lecturewalaOP/catalog/controller/startup/router.php(15): Event->trigger() #17 /var/www/lecturewalaOP/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index() #18 /var/www/lecturewalaOP/system/engine/router.php(67): Action->execute() #19 /var/www/lecturewalaOP/system/engine/router.php(56): Router->execute() #20 /var/www/lecturewalaOP/system/framework.php(169): Router->dispatch() #21 /var/www/lecturewalaOP/system/startup.php(104): require_once('...') #22 /var/www/lecturewalaOP/index.php(21): start() #23 {main} thrown in /var/www/lecturewalaOP/system/library/db/mysqli.php on line 49