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

Chocobozzz / OpenVPN-Admin

Install and administrate OpenVPN with a web interface (logs visualisations, users managing...)

GNU Affero General Public License v3.0

947 stars 368 forks source link

Open mrbupu opened 2 years ago

mrbupu commented 2 years ago

**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 commented 1 year ago

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

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