MySQL WARNING!DB Error : mySQL Error on Query : SELECT
c.id as id,
c.uid as uid,
c.sesid as sesid,
ci.id AS cart_item_id,
ci.gift_id AS cart_item_gift_id,
ci.gift_price AS cart_item_gift_price,
ci.cart_id AS cart_item_cart_id,
ci.product_id AS cart_item_product_id,
ci.qty AS cart_item_qty,
ci.price AS cart_item_price,
ci.promo_price AS cart_item_price_promo,
ci.options_ids AS options_ids,
ci.attributes_ids AS attributes_ids,
ci.attributes_values_ids AS attributes_values_ids,
ci.data_id AS data_id,
ci.color AS color,
ci.size AS size,
p.id AS product_id,
p.type AS product_type,
p.weight AS weight,
p.title_en AS product_title,
p.slug AS product_slug,
pi.image AS product_image
FROM shop_cart as c
LEFT JOIN shop_cart_items as ci ON ci.cart_id = c.id
LEFT JOIN shop_products as p ON p.id = ci.product_id
LEFT JOIN shop_products_images as pi ON pi.product_id = ci.product_id
WHERE ci.product_id != ''
AND ci.qty != ''
AND c.sesid = 'b21fc1315ab7b95131496b0f4992d741fe2891ab'
GROUP BY ci.id
More Information :
- MySQL Error : 1054
- MySQL Error no # : Unknown column 'p.title_en ' in 'field list'
- Date : April 24, 2024, 5:42 pm
- Referer : 1
- Script : /?lang=en%C2%A0%C2%A0