SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql-temptable-234-90520-a83d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (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:56:26' OR ec_products.end_date < '2025-07-18 23:56:26' ) ) THEN ec_products.price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-07-18 23:56:26' AND ec_products.end_date >= '2025-07-18 23:56:26' ) 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:56:26' ) THEN ec_products.sale_price WHEN ( ec_products.sale_type = 1 AND ec_products.start_date <= '2025-07-18 23:56:26' 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_collections` inner join `ec_product_collection_products` on `ec_product_collections`.`id` = `ec_product_collection_products`.`product_collection_id` where `ec_products`.`id` = `ec_product_collection_products`.`product_id` and `ec_product_collection_products`.`product_collection_id` in (5)) and `ec_products`.`is_variation` = 0 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 8)
Your experience on this site will be improved by allowing cookies
These cookies are essential for the website to function properly.
These cookies help us understand how visitors interact with the website.
These cookies are used to deliver personalized advertisements.