Login as administrator and go to user -> notes. Try to change the review time of a user note.
The entered date will be saved and shown as the new review date.
After entering and saving the new date, it gets converted like:
The day will ever be converted to the 20th.
The month stays the same as entered.
The year changes irregularly depending on the entry. (e.g. 2013, 2020,...)
Example: I enter 13.02.2019 and get the result 20.02.2013.
Joomla 3.9.2
Mysql 5.7.24
PHP 7.2.15
Apache localhost
In administrator/components/com_users/tables/note.php
before storing to database "return parent::store($updateNulls);"
The value of $this->review_time has the proper value.
In database the review time in table _user_notes has the inproper value.
Changing it manually changes the displayed review time in user notes.
Labels |
Added:
?
|
Status | New | ⇒ | Information Required |
Title |
|
Status | Information Required | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-03-03 11:39:48 |
Closed_By | ⇒ | infograf768 |
The date format entered should be correctly entered if done manually. It depends on the format used by the language.
The first time it is saved as it has no date yet, it will pick the language defined format.
When editing thereafter and whatever the language, the format should be similar to the one displayed in the field.
In French, it would be 03-03-2011 while in en-GB it will be 2011-03-03
Not a bug.
thanks @infograf768
Hello,
firstly i want to thank you for answering. But the problem still exists.
I have tried to enter it manually but still the same happens.
Even in a fresh Joomla installation without custom code there is the same behaviour.
I've also tried different formats, but every time i get the same result like described above.
Do you have any ideas?
@HLeithner can you please comment?