Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

error i cant understand please help


Recommended Posts

Hi i run a camera website and am having en error where whenever i go to the shopping cart i see an error on the bottom of the page(shown below).

i looked in my shopping cart file and dont even see those lines of code in it and am 100% clueless what to do to get rid of it

any help would mean the world to me




"1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY s.name' at line 1


SELECT round( sum( p.products_price * rate * cb.customers_basket_quantity ) , 2 ) AS cost, s.name FROM customers_basket cb INNER JOIN products p ON p.products_id = cb.products_id INNER JOIN shipping_methods s ON s.products_shipping_class_id = p.products_shipping_class_id WHERE cb.customers_id = GROUP BY s.name"

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...