Birthday module give database error when member/contact is born on 29 february

[johnsonbrothers]

Describe the bug

I have a member born on february 29 1964. This gives the following error in my postgres log.

2023-12-14 13:54:46.594 UTC [3554] ERROR: date/time field value out of range: "2023-02-29"
2023-12-14 13:54:46.594 UTC [3554] STATEMENT: SELECT DISTINCT usr_id, usr_uuid, usr_login_name,
last_name.usd_value AS last_name, first_name.usd_value AS first_name,
birthday.bday AS birthday, birthday.bdate,
EXTRACT(DAY FROM TO_TIMESTAMP($1, 'YYYY-MM-DD') - birthday.bdate) * (-1) AS days_to_bdate, -- DATE_NOW
EXTRACT(YEAR FROM bdate) - EXTRACT(YEAR FROM TO_TIMESTAMP(bday, 'YYYY-MM-DD')) AS age,
email.usd_value AS email, gender.usd_value AS gender
FROM adm_users AS users
INNER JOIN ( (SELECT usd_usr_id, usd_value AS bday,
TO_DATE(EXTRACT(YEAR FROM TO_TIMESTAMP($2, 'YYYY-MM-DD')) || TO_CHAR(TO_TIMESTAMP(bd1.usd_value, 'YYYY-MM-DD'), '-MM-DD'), 'YYYY-MM-DD') AS bdate -- DATE_NOW
FROM adm_user_data AS bd1
WHERE EXTRACT(DAY FROM TO_TIMESTAMP($3, 'YYYY-MM-DD') - TO_TIMESTAMP(EXTRACT(YEAR FROM TO_TIMESTAMP($4, 'YYYY-MM-DD')) || TO_CHAR(TO_TIMESTAMP(bd1.usd_value, 'YYYY-MM-DD'), '-MM-DD'), 'YYYY-MM-DD')) -- DATE_NOW,DATE_NOW
BETWEEN $5 AND $6 -- -$plg_show_zeitraum AND $plg_show_future
AND usd_usf_id = $7) -- $fieldBirthday
UNION
(SELECT usd_usr_id, usd_value AS bday,
TO_DATE(EXTRACT(YEAR FROM TO_TIMESTAMP($8, 'YYYY-MM-DD'))-1 || TO_CHAR(TO_TIMESTAMP(bd2.usd_value, 'YYYY-MM-DD'), '-MM-DD'), 'YYYY-MM-DD') AS bdate -- DATE_NOW
FROM adm_user_data AS bd2
WHERE EXTRACT(DAY FROM TO_TIMESTAMP($9, 'YYYY-MM-DD') - TO_TIMESTAMP(EXTRACT(YEAR FROM TO_TIMESTAMP($10, 'YYYY-MM-DD')- INTERVAL '1 year') || TO_CHAR(TO_TIMESTAMP(bd2.usd_value, 'YYYY-MM-DD'), '-MM-DD'), 'YYYY-MM-DD')) -- DATE_NOW,DATE_NOW
BETWEEN $11 AND $12 -- -$plg_show_zeitraum AND $plg_show_future
AND usd_usf_id = $13) -- $fieldBirthday
UNION
(SELECT usd_usr_id, usd_value AS bday,
TO_DATE(EXTRACT(YEAR FROM TO_TIMESTAMP($14, 'YYYY-MM-DD'))+1 || TO_CHAR(TO_TIMESTAMP(bd3.usd_value, 'YYYY-MM-DD'), '-MM-DD'), 'YYYY-MM-DD') AS bdate -- DATE_NOW
FROM adm_user_data AS bd3
WHERE EXTRACT(DAY FROM TO_TIMESTAMP($15, 'YYYY-MM-DD') - TO_TIMESTAMP(EXTRACT(YEAR FROM TO_TIMESTAMP($16, 'YYYY-MM-DD')+ INTERVAL '1 year') || TO_CHAR(TO_TIMESTAMP(bd3.usd_value, 'YYYY-MM-DD'), '-MM-DD'), 'YYYY-MM-DD')) -- DATE_NOW,DATE_NOW
BETWEEN $17 AND $18 -- -$plg_show_zeitraum AND $plg_show_future
AND usd_usf_id = $19) -- $fieldBirthday
) AS birthday
ON birthday.usd_usr_id = usr_id
LEFT JOIN adm_user_data AS last_name
ON last_name.usd_usr_id = usr_id
AND last_name.usd_usf_id = $20 -- $gProfileFields->getProperty('LAST_NAME', 'usf_id')
LEFT JOIN adm_user_data AS first_name
ON first_name.usd_usr_id = usr_id
AND first_name.usd_usf_id = $21 -- $gProfileFields->getProperty('FIRST_NAME', 'usf_id')
LEFT JOIN adm_user_data AS email
ON email.usd_usr_id = usr_id
AND email.usd_usf_id = $22 -- $gProfileFields->getProperty('EMAIL', 'usf_id')
LEFT JOIN adm_user_data AS gender
ON gender.usd_usr_id = usr_id
AND gender.usd_usf_id = $23 -- $gProfileFields->getProperty('GENDER', 'usf_id')
LEFT JOIN adm_members
ON mem_usr_id = usr_id
AND mem_begin <= $24 -- DATE_NOW
AND mem_end > $25 -- DATE_NOW
INNER JOIN adm_roles
ON mem_rol_id = rol_id
AND rol_valid = true
INNER JOIN adm_categories
ON rol_cat_id = cat_id
AND cat_org_id = $26 -- $gCurrentOrgId
WHERE usr_valid = true
AND mem_rol_id IS NOT NULL
ORDER BY days_to_bdate DESC, last_name, first_name

I can imagine this happens somewhere if the birthday date is not handled with database-functions when a year is added or substracted. The year today is no leap year and the 29 of february 2023 don't exist.

To Reproduce
Steps to reproduce the behavior:

1. Go to Members
2. Click on a member and change birthday to 29 february a leap year.
3. save
4. click on another member and change birthday to any year and current month and day
5. go to overview and check birthday module
6. no birthdays is shown

Expected behavior
You should see the member that you changed birthday to this month and day

System (please complete the following information):

• Admidio-Version Container with tag 4.2.14
• PHP n/a - in Container
• Database PostgreSQL
• Browser firefox
• Browser-Version 120.0.1