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