SQL syntax Error question

[Game5ive.com]

Hello,

 

Since 3 Days i try do make multi shop now all works but at the back panel in the Products when i filter it as category i get now this error:

False SQL Request
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 'FROM `pp_product` a LEFT JOIN `pp_product_lang` b ON (b.`id_product` = a' at line 4

With Debug on:

 

 

See in the HTM Document:

 

https://www.dropbox.com/s/cv8r42o0kklsb9f/index.php.htm

 

 

Can anyone help ?  The Problem comes since i activated Multishop.

 

 

Kind regards

[NemoPS]

There is a trailing comma at the end of the SELECT statement

... profit, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, sa.`active` , cp.`position`, 

[Game5ive.com]

 

There is a trailing comma at the end of the SELECT statement

... profit, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, sa.`active` , cp.`position`, 

Thank you but now with Update to 1.5.6.1 it work again .  Thank you when problem again i can make that can you take a look at this ?

 

http://www.prestashop.com/forums/topic/291336-prestashop-1541-mobile-css-problems-can-help/

 

And look if you can help ?

[Game5ive.com]

 

There is a trailing comma at the end of the SELECT statement

... profit, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, sa.`active` , cp.`position`, 

 

 

Now error:

 

• Falsche SQL-Abfrage

  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 od.product_id ) ped ON (ped.product_id=a.id_product) LEFT JOIN `t' at line 16