Hi:
I have a problem with the module Profesional Blog, I get this error when I try to add a related product to the article I created:
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 'LIMIT 1' at line 11
SELECT COUNT(DISTINCT pl.`id_product`) AS `value` FROM `ps_product_lang` AS pl LEFT JOIN `ps_product_shop` AS ps ON (ps.`id_product` = pl.`id_product`) WHERE ( UPPER(pl.`description`) LIKE '%TAR%' OR UPPER(pl.`description_short`) LIKE '%TAR%' OR UPPER(pl.`link_rewrite`) LIKE '%TAR%' OR UPPER(pl.`name`) LIKE '%TAR%' OR UPPER(pl.`meta_title`) LIKE '%TAR%' OR UPPER(pl.`meta_description`) LIKE '%TAR%' OR UPPER(pl.`meta_keywords`) LIKE '%TAR%' ) AND pl.`id_lang` = 3 AND ps.`id_shop` = 1; LIMIT 1
I tried uninstalling it and installing again, but the problem persits. I asked the developers but they say it is not a problem of the module, it is a problem regarding the database.
Anyone has any clue? Can it be an incompatibility with other module, configuration?
Prestashop 1.5.6.2
Thank you!