SQLSTATE[HY000]: General error: 126 Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-234-904b6-3bf7.MAI' (Connection: mysql, SQL: select distinct `ec_products`.*, `ec_products`.`with_storehouse_management`, `ec_products`.`stock_status`, `ec_products`.`quantity`, `ec_products`.`allow_checkout_when_out_of_stock` from `ec_products` inner join ( SELECT DISTINCT ec_products.id, CASE WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price <> 0 ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 0 AND ec_products.sale_price = 0 ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ( ec_products.start_date > '2025-07-18 23:48:16' OR ec_products.end_date < '2025-07-18 23:48:16' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-07-18 23:48:16' AND ec_products.end_date >= '2025-07-18 23:48:16' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date IS NULL AND ec_products.end_date >= '2025-07-18 23:48:16' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-07-18 23:48:16' AND ec_products.end_date IS NULL ) THEN ec_products.sale_price ELSE ec_products.price END AS final_price FROM ec_products ) AS products_with_final_price on `products_with_final_price`.`id` = `ec_products`.`id` where `status` = published and exists (select * from `ec_product_categories` inner join `ec_product_category_product` on `ec_product_categories`.`id` = `ec_product_category_product`.`category_id` where `ec_products`.`id` = `ec_product_category_product`.`product_id` and `ec_product_category_product`.`category_id` in (239)) and `ec_products`.`is_variation` = 0 and `ec_products`.`id` != 27105 order by CASE WHEN ec_products.with_storehouse_management = 0 THEN CASE WHEN ec_products.stock_status = out_of_stock THEN 1 ELSE 0 END ELSE CASE WHEN ec_products.quantity <= 0 AND ec_products.allow_checkout_when_out_of_stock = 0 THEN 1 ELSE 0 END END ASC , `ec_products`.`order` asc, `ec_products`.`created_at` desc limit 7) (View: platform/themes/martfury/views/ecommerce/product.blade.php)