Error: Error: Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-340-258a6-3a7d63.MAI'
Error No: 126
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (SELECT (CASE WHEN `pd2`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`pd2`.`price` / 100))) WHEN `pd2`.`type` = 'S' THEN (`p`.`price` - `pd2`.`price`) ELSE `pd2`.`price` END) FROM `oc_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND `pd2`.`special` = '0' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1) AS `discount`, (SELECT (CASE WHEN `ps`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`ps`.`price` / 100))) WHEN `ps`.`type` = 'S' THEN (`p`.`price` - `ps`.`price`) ELSE `ps`.`price` END) FROM `oc_product_discount` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND `ps`.`quantity` = '1' AND `ps`.`special` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special`, (SELECT `pr`.`points` FROM `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `oc_category_to_store` `c2s` LEFT JOIN `oc_product_to_category` `p2c` ON (`p2c`.`category_id` = `c2s`.`category_id` AND `c2s`.`store_id` = '0') LEFT JOIN `oc_product_to_store` `p2s` ON (`p2s`.`product_id` = `p2c`.`product_id` AND `p2s`.`store_id` = '0') LEFT JOIN `oc_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p`.`date_available` <= NOW()) LEFT JOIN `oc_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '9' AND `p2c`.`category_id` = '120' GROUP BY `p`.`product_id` ORDER BY p.sort_order ASC, LCASE(`pd`.`name`) ASC LIMIT 180,12 File: /usr/local/lsws/babyamy/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /usr/local/lsws/babyamy/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /usr/local/lsws/babyamy/catalog/model/catalog/product.php Line: 293 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /usr/local/lsws/babyamy/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Catalog\Product Function: getProducts Backtrace: 3 File: /usr/local/lsws/babyamy/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: {closure:Opencart\System\Engine\Loader::callback():312} Backtrace: 4 File: /usr/local/lsws/babyamy/catalog/controller/product/category.php Line: 231 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /usr/local/lsws/babyamy/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Category Function: index Backtrace: 6 File: /usr/local/lsws/babyamy/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /usr/local/lsws/babyamy/index.php Line: 20 Function: require_once Warning: Undefined array key "file" in /usr/local/lsws/babyamy/catalog/controller/startup/error.php on line 78Warning: Undefined array key "line" in /usr/local/lsws/babyamy/catalog/controller/startup/error.php on line 79Error: MISCONF Redis is configured to save RDB snapshots, but it's currently unable to persist to disk. Commands that may modify the data set are disabled, because this instance is configured to report errors during writes if RDB snapshotting fails (stop-writes-on-bgsave-error option). Please check the Redis logs for details about the RDB error. File: /usr/local/lsws/babyamy/system/library/session/redis.php Line: 61 Backtrace: 0 File: /usr/local/lsws/babyamy/system/library/session/redis.php Line: 61 Class: Redis Function: set Backtrace: 1 File: /usr/local/lsws/babyamy/system/library/session.php Line: 89 Class: Opencart\System\Library\Session\Redis Function: write Backtrace: 2 File: Line: Class: Opencart\System\Library\Session Function: close