Warning: session_start(): open(/var/lib/php/session/sess_0t5m9bk8e0j9ohdj9ri27ss6j2, O_RDWR) failed: No space left on device (28) in /var/www/sabuyonline.com/www-v3/html/category.php on line 2
Database query error ! : SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#sql_c85_2.MAI' (Errcode: 28)
SELECT shop_bestseller_last2week.amount,
(CASE WHEN IFNULL(pc.in_stock_all, shop_product.in_stock_all) >0 THEN
1
ELSE
CASE WHEN warning_stock = 0 THEN
0
ELSE
CASE WHEN warning_stock = 2 THEN
-1
ELSE
-2
END
END
END)
as istock,
shop_product.* ,po.option_id, po.option_name_th, pc.choice_id, pc.choice_name_th,
pc.in_stock_all,
IFNULL(pc.datetime_add, shop_product.datetime_add) as dt
FROM shop_product
LEFT JOIN shop_product_option po ON shop_product.product_id = po.product_id
AND po.is_group =1
LEFT JOIN shop_product_option_choice pc ON po.product_id = pc.product_id
AND po.option_id = pc.option_id
AND pc.status = 1
LEFT JOIN shop_bestseller_last2week ON
shop_product.product_id=shop_bestseller_last2week.product_id AND
IFNULL(pc.option_id, 0)=shop_bestseller_last2week.option_id AND
IFNULL(pc.choice_id, 0)=shop_bestseller_last2week.choice_id
WHERE shop_product.product_id in
( SELECT product_id
FROM shop_product_category
WHERE cat_id in (337,62,119,316,314,317,318,319,320,321,323,324,325,326,327,332,371,490,493,494,495,496,508,541,571,595,618,620,623,120,353,354,355,367,121,122,357,358,359,360,361,362,363,364,365,482,123,124,125,133,132,135,144,171,172,173,174,185,208,233,256,257,264,265,266,271,276,280,281,282,283,286,292,293,315,329,349,369,370,380,438,454,463,466,491,507,515,519,526,531,532,533,552,572,582,579,587,594,597,598,599,600,601,602,604,609,606,607,610,611,612,613,625,626,627,356,469,603) )
and shop_product.product_id in (select product_id from shop_product_type where type_id<>2 and option_id=1 and type_value in ('7','38','130','186','297','353')) and shop_product.status<>0 and shop_product.show_web = 1 and shop_product.price_net > 0
ORDER BY istock DESC,shop_bestseller_last2week.amount desc, dt desc
LIMIT 0,12
Warning: Unknown: open(/var/lib/php/session/sess_0t5m9bk8e0j9ohdj9ri27ss6j2, O_RDWR) failed: No space left on device (28) in Unknown on line 0
Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session) in Unknown on line 0