Page Peel Banner not working on joomla 3.6.3

I have upgraded my Joomla-Site from 3.6.2 to 3.6.3 and now I get the following message:

500 - 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 ()

If I disable the PagePeel module, then everything is fine and the site works ok.

Maybe you can fix it?
Regards, René
8 years 6 months ago #1 by renoo99
The topic has been marked as resolved.
  • Posted by TemplatePlazza (5310) Offline
Hi I'm unable to replicate the issue and looks like it's more related to joomla banner component where publishing time does not honor timezone. See this github.com/joomla/joomla-cms/issues/11969

To make it sure, can you try to publish a (default) joomla banner module and check whether the same issue is happening or not?
8 years 6 months ago #2 by TemplatePlazza
The topic has been marked as resolved.
I followed directions, published the banner with no expiration date, and it showed fine. I then changed the expiration date to last week, and it no longer displayed. I received no error. I experimented more with other banners, but received no errors.
I only receive the error if I publish the pagepeel module. As I said, it's been working beautifully since I first started using it, but broke as soon as I applied the latest Joomla update.
8 years 6 months ago #3 by Kurt Manos
The topic has been marked as resolved.
  • Posted by TemplatePlazza (5310) Offline
@kurtmanos
Do you have any development server with the the same issue so I can make some test on it?
Or Is it possible for you to provide temporary access to your website so I can make some tests? If it's possible you can enter the details using the "You Site Details" tab below. Only support team who are able to see that.
8 years 6 months ago #4 by TemplatePlazza
The topic has been marked as resolved.
In the interest of resolving this issue, I tried it on one of our other company sites, with the exact same result.
Unfortunately, I can't grant you access to our corporate sites, but I will speak to our CEO to see if I can't publish a backup on a subdomain for you to access.
8 years 6 months ago #5 by Kurt Manos
The topic has been marked as resolved.
  • Posted by TemplatePlazza (5310) Offline
@kurtmagnos I'm fully understand with the situation. No problem with that.;)
Anyway, can you try to open file ../modules/mod_responsivebannerslider/helper.php with your favorite php editor find this code below at line 68 :
$model->impress();

try to change that to :
if ($banners)
		{
			$model->impress();
		}

then let me know the result
8 years 6 months ago #6 by TemplatePlazza
The topic has been marked as resolved.
Powered by Kunena Forum