DateTime::__construct(): Failed to parse time string

[sshcli]

Steps to reproduce the behavior:

1. UserX has this value as birthday: 0000-00-00
2. Try to change the rank to UserX

Expected behavior
No error

Actual result
DateTime::__construct(): Failed to parse time string (11/30/-0001) at position 5 (/): Unexpected character

System information (please complete the following information)
Joomla version: 3.9.0-Beta2
Kunena version: 5.1.4-DEV
Php version: 7.2.9
Database version: MySQL 5.6.40

[xillibit]

You have the issue only on J!3.9.0 beta not on J!3.8.x ?

[sshcli]

I remember I saw the error once in 3.8

[xillibit]

Only in backend not in frontend ?

[sshcli]

All times I saw the error was in the backend, never in the front.

[sshcli]

Use this query to check if you have users with this problem in your website:

SELECT * FROM #_kunena_users WHERE birthdate = '0000-00-00'

[sshcli]

In frontend you will see it like this when editing the profile:

[sshcli]

Also, we need the option to show/hide birthday in profile:

[sshcli]

You get also the error in frontend when user click save button on profile edit:

[sshcli]

People having this error can't save/edit/remove other values from the profile like facebook, instagram, etc..

[sshcli]

1027 people that can't edit profile

[sshcli]

In the meanwhile, I have fixed the problem only for my website with the following query:

UPDATE prefix_kunena_usersSETbirthdate= '2018-10-26' WHEREbirthdate = '0000-00-00'

I prefer babies registered in my website than the error