Warning: mysqli::query(): (HY000/145): Table './nexen_dbdpnew/oc_bf_filter' is marked as crashed and should be repaired in /sites/decoraplaza.kz/system/library/db/mysqli.php on line 25
Fatal error: Uncaught Exception: Error: Table './nexen_dbdpnew/oc_bf_filter' is marked as crashed and should be repaired<br />Error No: 145<br />CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) SELECT p.product_id, p.sort_order, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price))) AS actual_price FROM `oc_product` AS p INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id) INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id) INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id) LEFT JOIN `oc_product_discount` AS pd2 ON (pd2.product_id = p.product_id AND pd2.quantity = '1' AND (pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()) AND pd2.customer_group_id = '1') LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1') WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND p2c.category_id = '104' GROUP BY p.product_id in /sites/decoraplaza.kz/system/library/db/mysqli.php:49 Stack trace: #0 /sites/decoraplaza.kz/system/library/db.php(45): DB\MySQLi->query('CREATE TEMPORAR...') #1 /sites/decoraplaza.storage/modification/catalog/model/extension/module/brainyfilter.php(641): DB->query('CREATE TEMPORAR...') #2 /sites/decoraplaza.storage/modification/catalog/model/extension/module/brainyfilter.php(691): ModelExtensionModuleBrainyFilter->_fillTmpTable(Object(SqlStatement)) #3 /sites/decoraplaza.storage/modification/catalog/model/extension/module/brainyfilter.php(796): ModelExtensionModuleBrainyFilter->_prepareFilterQuery() #4 /sites/decoraplaza.storage/modification/catalog/model/catalog/product.php(468): ModelExtensionModuleBrainyFilter->prepareQueryForTotal() #5 /sites/decoraplaza.storage/modification/system/engine/loader.php(248): ModelCatalogProduct->getTotalProducts(Array) #6 /sites/decoraplaza.kz/system/engine/proxy.php(47): Loader->{closure}(Array, Array) #7 /sites/decoraplaza.storage/modification/catalog/controller/product/category.php(240): Proxy->__call('getTotalProduct...', Array) #8 /sites/decoraplaza.storage/modification/system/engine/action.php(79): ControllerProductCategory->index() #9 /sites/decoraplaza.kz/catalog/controller/startup/router.php(27): Action->execute(Object(Registry)) #10 /sites/decoraplaza.storage/modification/system/engine/action.php(79): ControllerStartupRouter->index() #11 /sites/decoraplaza.kz/system/engine/router.php(67): Action->execute(Object(Registry)) #12 /sites/decoraplaza.kz/system/engine/router.php(56): Router->execute(Object(Action)) #13 /sites/decoraplaza.kz/system/framework.php(179): Router->dispatch(Object(Action), Object(Action)) #14 /sites/decoraplaza.kz/system/startup.php(104): require_once('/sites/decorapl...') #15 /sites/decoraplaza.kz/index.php(20): start('catalog') #16 {main} thrown in /sites/decoraplaza.kz/system/library/db/mysqli.php on line 49