error in shopping cart

[cameraguy]

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

thanks!

 

 

"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"

[Guest]

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

thanks!

"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"

You have not run an sql file to update your datebase (typically via phpMyAdmin). How to do it is in the forums. Check the contribs that you have installed for the sql file.