Set up a Joomla site with timezone != UTC
Publish a banner with 'Finish Publishing' set to some datetime.
Banner should stop showing in frontend at exactly the 'Finish Publishing' datetime: not before, not after.
E.g.:
Server set to TZ: CEST (UTC+2).
Joomla Global config Server Time Zone: *** (should resolve to CEST).
Banners with 'Finish Publishing' set to aaaa-mm-dd 00:00:00
(i) will actually stop showing in frontend at aaaa-mm-(dd-1) 22:00:00 CEST
(ii) oddly enough, in backend list they will show as 'Published and is Current' / 'Published, but has Expired' as per local time, not per actual behavior.
System info:
PHP Built On Linux *** 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt25-2+deb8u3 (2016-07-02) x86_64
Database Version 5.5.50-0+deb8u1
Database Collation utf8mb4_general_ci
Database Connection Collation utf8mb4_general_ci
PHP Version 5.6.24-0+deb8u1
Web Server Apache
WebServer to PHP Interface apache2handler
Joomla! Version Joomla! 3.6.2 Stable [ Noether ] 4-August-2016 23:41 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Database publish_up and publish_down fields are UTC. Obviously, this info is adjusted to local time for some operations but not for other.
Issue seems related to these posts in Joomla Forum:
http://forum.joomla.org/viewtopic.php?t=712377
http://forum.joomla.org/viewtopic.php?t=893105
both unanswered.
No, articles will publish up and down as scheduled. This affects only banners, both start and finish times.
Thank you for clarifying that - it will help to isolate the issue
On 6 September 2016 at 21:42, ersaloz notifications@github.com wrote:
No, articles will publish up and down as scheduled. This affects only
banners, both start and finish times.
This comment was created with the J!Tracker Application
https://github.com/joomla/jissues at issues.joomla.org/joomla-cms/11929
https://issues.joomla.org/tracker/joomla-cms/11929.—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
#11929 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABPH8Q_MChOjrFvFb3ZFR0PBlGq5hcGMks5qndBPgaJpZM4J0odr
.
Brian Teeman
Co-founder Joomla! and OpenSourceMatters Inc.
http://brian.teeman.net/
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2016-09-07 19:23:41 |
Closed_By | ⇒ | brianteeman |
Man, this is efficiency!
Don't forget to test the fix
I don't know how to test a pre-release fix.
@ersaloz please have a look here: https://docs.joomla.org/Testing_Joomla!_patches#Preparing_to_test ;)
Thanks. Testing now.
Can you please test and see if the same is true for articles
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/11929.