Catched error 406HY000: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_782_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
in /var/www/vhosts/osava.ua/osava-sushi.com.ua/protected/classes/DataBase.php on line 92.
Query: 'SELECT tb.id,
tb.url,
tb.photo,
tb.active,
tb.sort,
tb.code,
tb.weight,
tb4.status_id,
tb5.name AS status,
tb_lang.name,
tb_lang.body_m,
tb3.catalog_id,
de.id AS de_id,
CASE WHEN (tb_price.discount = 0 AND de.sale = 0) THEN 0
WHEN tb_price.discount = 0 THEN de.sale
ELSE tb_price.discount
END AS discount,
tb_price.id as price_id,
tb_price.price - ( tb_price.price * (tb_price.discount / 100 )) AS discount2,
tb_price.price, tb_price.stock, tb_price.unit
FROM `product` `tb`
LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN product_catalog tb3 ON tb3.product_id=tb.id
LEFT JOIN `price` as `tb_price` ON `tb_price`.product_id=tb.id
LEFT JOIN city_product city_p ON city_p.product_id = tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN day_event de ON de.catalog_id = tb3.catalog_id AND de.day_id = 4 AND 1753922480 >= UNIX_TIMESTAMP(de.time_start) AND 1753922480 <= UNIX_TIMESTAMP(de.time_end) AND de.active = 1 AND city_p.city_id=1
LEFT JOIN ua_product_status tb5 ON tb4.status_id=tb5.product_status_id
WHERE tb.id!='0' AND (tb3.catalog_id='172' ) AND tb.active='1'
GROUP BY tb.id
ORDER BY tb.sort desc, tb.id desc
':''
Catched error 406HY000: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_782_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
in /var/www/vhosts/osava.ua/osava-sushi.com.ua/protected/classes/DataBase.php on line 92.
Query: 'SELECT tb.id,
tb.url,
tb.photo,
tb.active,
tb.sort,
tb.code,
tb.weight,
tb4.status_id,
tb5.name AS status,
tb_lang.name,
tb_lang.body_m,
tb3.catalog_id,
de.id AS de_id,
CASE WHEN (tb_price.discount = 0 AND de.sale = 0) THEN 0
WHEN tb_price.discount = 0 THEN de.sale
ELSE tb_price.discount
END AS discount,
tb_price.id as price_id,
tb_price.price - ( tb_price.price * (tb_price.discount / 100 )) AS discount2,
tb_price.price, tb_price.stock, tb_price.unit ,tb_price.discount as lol1, de.sale as lol2
FROM `product` `tb`
LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN product_catalog tb3 ON tb3.product_id=tb.id
LEFT JOIN `price` as `tb_price` ON `tb_price`.product_id=tb.id
LEFT JOIN city_product city_p ON city_p.product_id = tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN day_event de ON de.catalog_id = tb3.catalog_id AND de.day_id = 4 AND 1753922480 >= UNIX_TIMESTAMP(de.time_start) AND 1753922480 <= UNIX_TIMESTAMP(de.time_end) AND de.active = 1 AND city_p.city_id=1
LEFT JOIN ua_product_status tb5 ON tb4.status_id=tb5.product_status_id
WHERE tb.id!='0' AND (tb3.catalog_id='172' ) AND tb.active='1'
GROUP BY tb.id
ORDER BY tb.sort desc, tb.id desc
LIMIT 0, 24':''
Catched error 406HY000: SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_782_10.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
in /var/www/vhosts/osava.ua/osava-sushi.com.ua/protected/classes/DataBase.php on line 92.
Query: 'SELECT tb.id,
tb.url,
tb.photo,
tb.active,
tb.sort,
tb.code,
tb.weight,
tb4.status_id,
tb5.name AS status,
tb_lang.name,
tb_lang.body_m,
tb3.catalog_id,
de.id AS de_id,
CASE WHEN (tb_price.discount = 0 AND de.sale = 0) THEN 0
WHEN tb_price.discount = 0 THEN de.sale
ELSE tb_price.discount
END AS discount,
tb_price.id as price_id,
tb_price.price - ( tb_price.price * (tb_price.discount / 100 )) AS discount2,
tb_price.price, tb_price.stock, tb_price.unit ,tb_price.discount as lol1, de.sale as lol2
FROM `product` `tb`
LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id LEFT JOIN product_catalog tb3 ON tb3.product_id=tb.id
LEFT JOIN `price` as `tb_price` ON `tb_price`.product_id=tb.id
LEFT JOIN city_product city_p ON city_p.product_id = tb.id LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN day_event de ON de.catalog_id = tb3.catalog_id AND de.day_id = 4 AND 1753922480 >= UNIX_TIMESTAMP(de.time_start) AND 1753922480 <= UNIX_TIMESTAMP(de.time_end) AND de.active = 1 AND city_p.city_id=1
LEFT JOIN ua_product_status tb5 ON tb4.status_id=tb5.product_status_id
WHERE tb.id!='0' AND (tb3.catalog_id='172' ) AND tb.active='1'
GROUP BY tb.id
ORDER BY tb.sort desc, tb.id desc
':''