if admin selected a past time (less then current time)in Finish Publishing field then banner should not be displayed.
Getting following error :
"jos-Error: 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 ')' at line 3 SQL=UPDATE #__banners SET impmade = (impmade + 1) WHERE id IN ()"
PHP Version 5.5.9-1ubuntu4
Joomla! Version Joomla! 3.6.3-dev Development [ Noether ] 5-August-2016 00:32 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
No Code Attached Yet
No Code Attached Yet
How did you do step 2 - I always get
Save failed with the following error: Item start publishing date must be before finish publishing date
OK so having manually set the banner to be expired and then displaying the banners on the front end I can not replicate your issue and get the expected result you identified.
Please can you retest and confirm that you can replicate this with one of the default templates and on a clean install of the latest staging release
This has something to do with timezones. I believe there is a fringe case still a problem in 3.6.3, and I have at least one other customer with it at the moment, Im waiting for their site logins to look myself deeper.
What EXACT timezone are you using in Joomla Global Config
What EXACT time are you testing your site at (including where are you physically in the world, and whats your computer time/date at that time of testing)
What EXACT times are you inputting for the start/finishing times
scratch that - I unpublished all banners and still I get the error
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 ')' at line 3 SQL=UPDATE #__banners SET impmade = (impmade + 1) WHERE id IN ()
I'll have to wait for the FTP details from the client to debug whats going on.
Same problem here, exept in my case I don't use banners and then the same SQL-error appears. But after adding a dummy-banner the error is gone. Deleting the banner causes the error again.
Funny you should say that you dont use banners, because when I trashed all the banners on this customers site, I still got the sql error too... which is strange. I did check caching was off...
I still dont have access to that customers site to debug this, waiting on FTP details, their site is still down because of it.
@peterwouda do you have a screenshot of the error? was it just the error? or a formatted page? did it mention jos-Error or not? Do you have any template overides in your /templates/[templatename]/html/com_banners/ ?
It would help nail this issue down if I could get access to play with your site later on tonight (UK Time) if that were at all possible. I understand if you do not wish to provide access, however there is obviously an issue that needs identifying and the easiest way is for an experienced developer to debug on a site that can replicate the issue time and time again.
Please send me your site details using the form at https://fix.myjoomla.com/now and I'll take a look as soon as I can. There is no charge for this at all and your details will be encrypted and only used for the above purpose.
OK, thanks! I will send it to you in about an hour or so. First I will recover the live-site.
Excellent - Im travelling all day anyway (at an airport now) so there is no rush - if you can provide exact details on how to replicate the issue (and how to remove the issue on your live site, I think you said by adding a dummy banner) in the secure form when submitting the details as I need to see it "broken" and with the error message in order to debug the problem.
I have raised a PR #12508 - that addresses a code quality issue, that causes this exception, Please test this - I have applied this on @peterwouda site and on another and it fixes both sites - its a fringe case to replicate, but the code was of poor quality in this area anyway - the PR makes it more reliable.
It works fine now, no exceptions after testing with adding and deleting
Op 22-10-2016 om 15:03 schreef Phil Taylor:
I have raised a PR #12508
#12508 - that addresses a
code quality issue, that causes this exception, Please test this - I
have applied this on @peterwouda https://github.com/peterwouda site
and on another and it fixes both sites - its a fringe case to
replicate, but the code was of poor quality in this area anyway - the
PR makes it more reliable.
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
or mute the thread
So does that mean you were using a custom template? Do you/did you have any custom template overrides for com_banners in your templates html folder?
No there were no overrides for banners. The theme was "University" by Gavick which I reinstalled again to see if this was the issue but the error persisted. Also no relevant apache errors. Switching theme removed the issues. Only when I finally disabled Gavick's custom error page and got a more verbose error was I able to actually view the specific error..which led me here..
Disabling the banner STILL causes the issue unless I switch to Beez or similar default theme. I can provide URL if you're curious.
the fact that changing themes fixes this issue, means that its highly likely to be a theme override of sorts.
Im manic busy today but if you want to provide your site details securely at https://fix.myjoomla.com/now I'll take a quick look at your site to see if we can further nail this down - there is no charge, and no commitment - this is not official support, Im just looking to nail the issue down
Please also see the workaround in #12508 which will fix the issue for you, but is not the best practice fix, more a belt and braces thing we can add in core.
No problem Phil - publishing a non-visible banner is as good a fix as I need for the moment!
I understand you needed a quick fix to get your siteonline, but providing a broken site as a test site for someone like me to replicate the issue every time is invaluable in debugging the root cause of the issue so it can be identified and fixed for the good of everyone - even if its not a Joomla core issue we can then put this to bed.
Of course - I just meant that the site is online and working. I've added the site to myjoomla.com. ID: 11195130 if you're interested.
that doesnt help me sorry - I need FTP access to debug this issue :)
|Closed_Date||0000-00-00 00:00:00||⇒||2016-11-20 10:01:40|