Problem with module Profesional Blog and database

[Originarte]

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!

[vekia]

there is a semicolor after 1

1; LIMIT 1

 

remove it