1292 Incorrect date value: '0000-00-00' for column 'user_start_date' at row 1

[mrbupu]

• **PHP version: PHP 8.1.3
• **MySQL version: mysql Ver 8.0.26
• **Webserver (Nginx, Apache...): Apache/2.4.37
• PHP logs on pastebin:
  SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: '0000-00-00' for column 'user_start_date' at row 1

I cloned new version . Everything is fine untile install admin user. I got above MySQL error

[eetsceeck1]

that's because the new mysql / mariadb servers locking the date tables
that can be fixed by two ways,

1. install old mysql server (between 2017 to 2019)
2. install the latest mysql server and log into mysql and run the command: SET GLOBAL sql_mode = '';