OpenVPN-Admin

OpenVPN-Admin copied to clipboard

• **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

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 = '';