( ! ) Fatal error: Uncaught Exception: Error: Table './veloha78243_new/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)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) 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) INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_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 in /home/veloha78243/public_html/system/library/db/mysqli.php on line 41
( ! ) Exception: Error: Table './veloha78243_new/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)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) 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) INNER JOIN `oc_category_path` AS cp ON (cp.category_id = p2c.category_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') LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id FROM `oc_bf_tax_rate` WHERE customer_group_id = '1' AND ((based = 'store' AND country_id = '13' AND zone_id IN ('0', '192')) OR (based = 'shipping' AND country_id = '13' AND zone_id IN ('0', '192'))) GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id) WHERE p2s.store_id = '0' AND p.date_available <= NOW() AND cp.path_id = '211' GROUP BY p.product_id in /home/veloha78243/public_html/system/library/db/mysqli.php on line 41
Call Stack
#TimeMemoryFunctionLocation
10.0002394880{main}( ).../index.php:0
20.0065803120start( $application_config = 'catalog' ).../index.php:19
30.0068833248require_once( '/home/veloha78243/public_html/system/framework.php ).../startup.php:104
40.01861131056Router->dispatch( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' }, $error = class Action { private $id = 'error/not_found'; private $route = 'error/not_found'; private $method = 'index' } ).../framework.php:169
50.03791800192Router->execute( $action = class Action { private $id = 'startup/router'; private $route = 'startup/router'; private $method = 'index' } ).../router.php:56
60.03791800192Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'log' => class Log { ... }, 'event' => class Event { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'model_design_translation' => class Proxy { ... }, 'url' => class Url { ... }, 'model_localisation_language' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'model_localisation_currency' => class Proxy { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Cart\Tax { ... }, 'weight' => class Cart\Weight { ... }, 'length' => class Cart\Length { ... }, 'storecart' => class Cart\Storecart { ... }, 'cart' => class Cart\Cart { ... }, 'encryption' => class Encryption { ... }, 'model_setting_event' => class Proxy { ... }, 'model_catalog_category' => class Proxy { ... }, 'model_catalog_product' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'model_extension_module_isenselabs_seo' => class Proxy { ... }, 'model_extension_module_brainyfilter' => class Proxy { ... }, 'model_extension_module_brainyfilter_seo' => class Proxy { ... }] }, $args = ??? ).../router.php:67
70.03821805640ControllerStartupRouter->index( ).../action.php:79
80.03851817896Action->execute( $registry = class Registry { private $data = ['config' => class Config { ... }, 'log' => class Log { ... }, 'event' => class Event { ... }, 'load' => class Loader { ... }, 'request' => class Request { ... }, 'response' => class Response { ... }, 'db' => class DB { ... }, 'session' => class Session { ... }, 'cache' => class Cache { ... }, 'language' => class Language { ... }, 'document' => class Document { ... }, 'model_design_translation' => class Proxy { ... }, 'url' => class Url { ... }, 'model_localisation_language' => class Proxy { ... }, 'customer' => class Cart\Customer { ... }, 'model_localisation_currency' => class Proxy { ... }, 'currency' => class Cart\Currency { ... }, 'tax' => class Cart\Tax { ... }, 'weight' => class Cart\Weight { ... }, 'length' => class Cart\Length { ... }, 'storecart' => class Cart\Storecart { ... }, 'cart' => class Cart\Cart { ... }, 'encryption' => class Encryption { ... }, 'model_setting_event' => class Proxy { ... }, 'model_catalog_category' => class Proxy { ... }, 'model_catalog_product' => class Proxy { ... }, 'model_tool_image' => class Proxy { ... }, 'model_extension_module_isenselabs_seo' => class Proxy { ... }, 'model_extension_module_brainyfilter' => class Proxy { ... }, 'model_extension_module_brainyfilter_seo' => class Proxy { ... }] }, $args = ??? ).../router.php:25
90.03921899616ControllerProductCategory->index( ).../action.php:79
100.05232312336Proxy->getTotalProducts( ['filter_category_id' => 211, 'filter_filter' => '', 'sort' => 'p.sort_order', 'order' => 'ASC', 'start' => 0, 'limit' => '24', 'filter_bfilter' => TRUE] ).../category.php:227
110.05232312712Proxy->__call( $key = 'getTotalProducts', $args = [0 => ['filter_category_id' => 211, 'filter_filter' => '', 'sort' => 'p.sort_order', 'order' => 'ASC', 'start' => 0, 'limit' => '24', 'filter_bfilter' => TRUE]] ).../category.php:227
120.05232313496Loader->{closure:/home/veloha78243/public_html/system/storage/modification/system/engine/loader.php:220-262}( $args = [0 => ['filter_category_id' => 211, 'filter_filter' => '', 'sort' => 'p.sort_order', 'order' => 'ASC', 'start' => 0, 'limit' => '24', 'filter_bfilter' => TRUE]], [0 => ['filter_category_id' => 211, 'filter_filter' => '', 'sort' => 'p.sort_order', 'order' => 'ASC', 'start' => 0, 'limit' => '24', 'filter_bfilter' => TRUE]] ).../proxy.php:47
130.05242314560ModelCatalogProduct->getTotalProducts( $data = ['filter_category_id' => 211, 'filter_filter' => '', 'sort' => 'p.sort_order', 'order' => 'ASC', 'start' => 0, 'limit' => '24', 'filter_bfilter' => TRUE] ).../loader.php:248
140.05592705424ModelExtensionModuleBrainyFilter->prepareQueryForTotal( ).../product.php:723
150.05592705424ModelExtensionModuleBrainyFilter->_prepareFilterQuery( $filterByPrice = ??? ).../brainyfilter.php:796
160.05612713016ModelExtensionModuleBrainyFilter->_fillTmpTable( $sql = class SqlStatement { protected $_select = [0 => 'p.product_id', 1 => 'p.sort_order', 'match_filters' => '"1"', 'actual_price' => '(IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), IF(MIN(pd2.price) IS NOT NULL, MIN(pd2.price), p.price)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0))']; protected $_distinct = FALSE; protected $_from = ['p' => '`oc_product`']; protected $_where = [0 => 'p2s.store_id = \'0\'', 1 => 'p.date_available <= NOW()', 2 => 'cp.path_id = \'211\'']; protected $_having = []; protected $_join = ['p2s' => [...], 'f' => [...], 'p2c' => [...], 'cp' => [...], 'pd2' => [...], 'ps' => [...], 'tx' => [...]]; protected $_order = []; protected $_group = [0 => 'p.product_id']; protected $_limit = ['offset' => 0, 'limit' => 0]; protected $_mode = 'select'; protected $_insert = NULL; protected $_ignore = FALSE; protected $_union = []; protected $_update = NULL; protected $_set = [] } ).../brainyfilter.php:691
170.05652714808DB->query( $sql = '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)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) 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 O'... ).../brainyfilter.php:641
180.05652714808DB\MySQLi->query( $sql = '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)) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) 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 O'... ).../db.php:45