Installation of v3.3.1 on Ubuntu 24.04 with MySQL 8.0 fails

Installing ISPconfig on a fresh vServer with Ubuntu 24.04.4 LTS with PHP 8.3 (standard APT packages) and MySQL 8.0.45 (standard APT packages) "fails" (better: does not install correctly) during the database migration step with the following error:

Code:

Checking MySQL or compatible version 8.0.45-0ubuntu0.24.04.1 .. OK
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1064 (42000) at line 1852: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURDATE(),
  PRIMARY KEY  (`userid`)
) DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1' at line 28

The problem comes from the "`last_password_change` DATE NULL DEFAULT CURDATE()," line in the CREATE TABLE statement for the "sys_user" table.
To fix this issue, I had to surround the "CURDATE()" function with another pair of round brackets, like so:

Code:

`last_password_change` DATE NULL DEFAULT (CURDATE()),

Same applies for the "incremental" migration file "upd_0102.sql".

See discussion on StackOverflow on this topic -> unfortunately I cannot post links ...

 

"Google" for "stackoverflow current-date-curdate-not-working-as-default-date-value" and the first result shows the related discussion

 

Alright, I wasn't aware of that ISPconfig does not officially support MySQL anymore. Sorry...