Quote

We're also available for Custom Joomla Development

Hire us now

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é
Resolved
The discussion has been resolved.
Locked
The discussion has been locked.
15 responses Add Yours
       
  • Replied by admin on Wednesday, October 19 2016, 12:22 AM · Hide· #1
    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 https://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?
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  • Replied by kurtmanos@gmail.com on Wednesday, October 19 2016, 01:48 AM · Hide· #2
    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.
  •  
  • Replied by admin on Wednesday, October 19 2016, 02:00 AM · Hide· #3
    @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.
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  • Replied by kurtmanos@gmail.com on Wednesday, October 19 2016, 02:38 AM · Hide· #4
    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.
  •  
  • Replied by admin on Wednesday, October 19 2016, 02:45 AM · Hide· #5
    @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
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  • Replied by kurtmanos@gmail.com on Wednesday, October 19 2016, 03:00 AM · Hide· #6
    I apologize, but do you mean to go into mod_pagepeel_banner directory?
  •  
  • Replied by kurtmanos@gmail.com on Wednesday, October 19 2016, 03:07 AM · Hide· #7
    I altered the line as requested, published the component, cleared my caches, refreshed the site, and nothing at all comes up :) It's just a blank white screen
  •  
  • Replied by kurtmanos@gmail.com on Wednesday, October 19 2016, 03:15 AM · Hide· #8
    I've included screenshots for the actual configuration of the component, as well as the configuration of the banner client
  •  
  • Replied by admin on Wednesday, October 19 2016, 04:00 AM · Hide· #9
    Can you try to change Banner Ads Source to Joomla Banner ads? https://www.dropbox.com/s/v7g7n0w2gzvn43e/yaqb6.jpg?raw=1
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  • Replied by kurtmanos@gmail.com on Wednesday, October 19 2016, 04:06 AM · Hide· #10
    It made no difference. Exact same error
  •  
  • Replied by admin on Wednesday, October 19 2016, 04:34 AM · Hide· #11
    Hmm, please consider to upload the backup to sub domain as you mentioned above. Because I'm still unable to replicate the issue at my end. Please see this https://www.dropbox.com/s/rufe0bpzg13427k/peel88.mp4?raw=1
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  • Replied by jjnxpct on Wednesday, October 19 2016, 09:10 AM · Hide· #12
    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?
  •  
  • Replied by admin on Wednesday, October 19 2016, 09:42 AM · Hide· #13
    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
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  • Replied by admin on Wednesday, October 19 2016, 02:37 PM · Hide· #14
    Ok, we have published the update here https://www.templateplazza.com/items/pagepeel-banner-joomla-module . Please reinstall the module
    Please post rating at the Joomla! Extensions Directory - http://extensions.joomla.org/profile/profile/details/264
  •  
  •  
    Replied by jjnxpct on Monday, October 24 2016, 07:37 AM · Hide· #15
    Thanks!:D
Discussions are now locked. You will not be able to reply to this discussion