I've installed SPPC v2.2 and it seems to work quite fine (manual installation as several other items also changed). All now seems to work fine, except for one feature: if you try to change the sort order of the product listing (by default the list is sorted on product name & this works fine), I get an SQL error message:
<<
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 'order by final_price , pd.products_name limit 0, 50' at line 1
select p.products_image, pd.products_name, m.manufacturers_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '24' order by order by final_price , pd.products_name limit 0, 50
>>
I am no SQL wizard, but indeed it seems the last part of the statement is something my version of MySQL cannot translate.
Anyone out there that could help me out here?
Regards, Philippe