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_bg) 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 = '605cfd3e1e9f354cbe7ed9a9639cc5559dd9870f'
GROUP BY ci.id
More Information :
- MySQL Error : 1064
- MySQL Error no # : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AS product_title,
p.slug AS product_slug,
pi.image AS product_image
...' at line 22
- Date : April 25, 2024, 6:58 am
- Referer : 1
- Script : /index.php?option=com_content&view=article&id=1740:registeremp&catid=317:bg07prevrisk&Itemid=528&lang=bg)