SQLSTATE[HY000]: General error: 126 Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-af7a7-373974-1e04d0.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`, (select count(*) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = published) as `reviews_count`, (select avg(`ec_reviews`.`star`) from `ec_reviews` where `ec_products`.`id` = `ec_reviews`.`product_id` and `status` = published) as `reviews_avg` 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 > '2026-02-02 05:49:04' OR
ec_products.end_date < '2026-02-02 05:49:04'
)
) THEN ec_products.price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2026-02-02 05:49:04' AND
ec_products.end_date >= '2026-02-02 05:49:04'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date IS NULL AND
ec_products.end_date >= '2026-02-02 05:49:04'
) THEN ec_products.sale_price
WHEN (
ec_products.sale_type = 1 AND
ec_products.start_date <= '2026-02-02 05:49:04' 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 (61, 76)) and `ec_products`.`is_variation` = 0 and `ec_products`.`id` != 949 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 6) (View: platform/themes/wowy/views/ecommerce/product.blade.php)