Bug #3268

Article tab does not show articles immediately after creation (UTC articles timezone issue)

Added by krileon over 1 year ago. Updated over 1 year ago.

Status:ClosedStart date:02/14/2012
Priority:NormalDue date:
Assignee:beat% Done:

100%

Category:-Estimated time:1.00 hour
Target version:CB 1.8

Description

Due to the "publish_up" date always being in the future it seams the match of publish_up to $now is always wrong. Only after several hours have passed will it actually show.

Joomla 1.6+ is using "JFactory::getDate()->toSql()" to set the database date value.

3268.patch Magnifier (1.12 KB) krileon, 02/14/2012 08:47 pm

3268_alt.patch Magnifier (1.24 KB) krileon, 02/14/2012 08:47 pm

History

#1 Updated by krileon over 1 year ago

  • File 3268.patchMagnifier added
  • File 3268_alt.patchMagnifier added
  • Status changed from Assigned to Resolved
  • Assignee changed from krileon to beat
  • % Done changed from 0 to 100

2 proposed solutions. 1 just uses Joomla API and the other temporarily sets the timezone to UTC as Joomla does before constructing the date.

#2 Updated by beat over 1 year ago

  • Subject changed from Article tab does not show articles immediately after creation to Article tab does not show articles immediately after creation (UTC articles timezone issue)
  • Status changed from Resolved to Closed
  • Estimated time set to 1.00

Fixed in commit 1757 as suggested without JDate dependency.

Also available in: Atom PDF