User tests: Successful: Unsuccessful:
Pull Request for Issue #35204
Correctly re-translate the date/time string in the calendar based on language file
Also set the CORRECT en-GB value for the date/time string in PHP syntax DATE_FORMAT_CALENDAR_DATETIME as "%Y-%m-%d %H:%i:%s" - note this has been copied and pasted to other language packs and EVERY ONE will be broken... (Checked US and AU )
Install Joomla 4 with US language set as default
Try to create an article manually specifying a start publishing date and try to save
Article Saves
Status | New | ⇒ | Pending |
Category | ⇒ | Language & Strings Libraries |
Labels |
Added:
Language Change
?
|
Maybe this string is used later in php which it shouldn't?
Maybe this string is used later in php which it shouldn't?
Which is my exact fix. WHY ON EARTH have two different ways to specify dates....
so basically the bug is that the date/time is in US format coming out of the calendar and we have to convert that to SQL format to save it... in php....
So you are saying you rather keep %H:%M:%S
just because its been that way for 5 years, and stop reusing it in PHPthe way I proposed (which is the quick 2 line fix to the reported bug, the bug that means any language not using a SQL based date cannot save an article with a publish date......)
ok back to the drawing board...
Status | Pending | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2021-08-17 22:42:22 |
Closed_By | ⇒ | PhilETaylor | |
Labels |
Added:
?
Removed: ? |
The point is they should be translated so that Americans can have their crazy date format ;-)
Joomla should Display the American style when using US but internally we still use a standard that is compatible with sql as that's where all the dates end up.
Using M and S in JS instead of i and s just seems insane to me but I'm told it's been that way for 5 years.
My replacement PR to this one allows the US / translated date formats to be visible on calendars at the same time as allowing The data to be saved to sql
hmm hang on. Fixed PHP. Broke JS.