Page Peel Banner not working on joomla 3.6.3

Hi! I had the same problem with this module.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 SQL=UPDATE #__banners SET impmade = (impmade + 1) WHERE id IN ()

I changed the helper.php as suggested by admin. This solved the problem for me. Thanks.

Will this be fixed in a new version?
8 years 7 months ago #13 by Jip Jonker
The topic has been marked as resolved.
  • Posted by TemplatePlazza (5318) Offline

Hi! I had the same problem with this module.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3 SQL=UPDATE #__banners SET impmade = (impmade + 1) WHERE id IN ()

I changed the helper.php as suggested by admin. This solved the problem for me. Thanks.

Will this be fixed in a new version?


@jjnxpct yes I will update the extension if the fix is confirmed
@kurtmagnos are you sure you have edited the correct file? Additionally, please clear your joomla cache (System-> Clear Cache) to make sure the code change is applied
8 years 7 months ago #14 by TemplatePlazza
The topic has been marked as resolved.
  • Posted by TemplatePlazza (5318) Offline
Ok, we have published the update here www.templateplazza.com/items/pagepeel-banner-joomla-module . Please reinstall the module
8 years 7 months ago #15 by TemplatePlazza
The topic has been marked as resolved.
Thanks!:D
8 years 7 months ago #16 by Jip Jonker
The topic has been marked as resolved.
Powered by Kunena Forum