vt740: Calendar load issue

Something is broken... When logging in to a clean vt740 and opening the Calendar view - there is a problem with the format of the date being fed to the DateTime::_construct():

Note how the date sent in the request to the feed action is 2021-05-02 (Y-m-d) but the date fed to the constructor is 02-2021-05 (d-Y-m)...

If I change my user's date format from mm-dd-yyyy to dd-mm-yyyy then the problem goes away. Change it back and the error returns.

@uma.s This is still a problem. I would consider this a blocker to release.

I found a similar issue when creating new reports in a 7.3 instance:

{"success":false,"error":{"code":"DateTime::__construct(): Failed to parse time string (16-2021-07 19:00:00) at position 0 (1): Unexpected character","message":"DateTime::__construct(): Failed to parse time string (16-2021-07 19:00:00) at position 0 (1): Unexpected character","title":null}}

Notice the awkward date format being used: "16-2021-07"

I found the exact same issue in the forum: https://discussions.vtiger.com/discussion/192635/7-3-error-when-saving-generating-reports

but in my case, changing the user's date format doesn't solve the problem.

@lord_alan blocker or not, 7.4 release is out ;)

@ruben.estrada GA release is not yet done, I think we have addressed a similar issue with data formats. Will be validating this.

@lord_alan Thanks! for the notification. But i think it's not a blocker as the business can still go on :) Will make sure to rectify the issue.

@uma.s But you cannot load the calendar at all if your date formate is mm-dd-yyyy.

@ruben.estrada @lord_alan Addressed! Will make this to 7.4.0 :)

mentioned in merge request !829 (merged)

Status changed to closed by commit 9b8e7bdc

@uma.s There was a new release on Friday (16-07-2021):

Are you going to make this fix into a patch?

@ruben.estrada This is not officially published, As we came through this blocker issue. Will be going with GA release soon.

Milestone changed to 7.4.0

Reassigned to @vtiger

Added bug label

mentioned in issue #1629 (closed)

@ruben.estrada

I got the exact same error as you had (error during generate report):

{"success":false,"error":{"code":"DateTime::__construct(): Failed to parse time string (03-2022-07 00:00:00) at position 0 (0): Unexpected character","message":"DateTime::__construct(): Failed to parse time string (03-2022-07 00:00:00) at position 0 (0): Unexpected character","title":null}}

And changing the user's date format doesn't solve the problem. Have you got this issue solved ?

@wei.huang what version are you using? it it is not 7.4, try upgrading.

@ruben.estrada It is 7.4 (7.3 original installation then upgraded to 7.4), I actually opened an issue because I notice this is not the same other others who can change the data format and get back to work. More descriptions are here: #1716 (closed)