Xdmod SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'NOW()' for column `moddb`.`Users`.`password_last_updated` at row 1

Hello,

I’m trying to configure xdmod 10 on CentOS 8 with PHP 7.2.24.
When I run xdmod-setup option 5 Create Admin User I’m getting this error:

SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘NOW()’ for column moddb.Users.password_last_updated at row 1

I tried manually adding Admin user to the database and it let me to add the user.
Also, I tried changing table format from timestamp to datetime and it didn’t help either.

I configured SimplePHPSaml but when It try to log in I get this error:
Access forbidden
You don’t have the needed privileges to access this application. Please contact the administrator if you find this to be incorrect.

I suspect it might be related.

Can you please advise?

We’re not entirely sure. I did find this support portal but I’ll now use back channels to see if that’s the appropriate way to get help.

Please can you ask this in the XDMoD help and we’ll try to get back to you quickly:
Support contact information is here: Open XDMoD - Support

Thank you so much for your responses. I emailed to ccr-xdmod-help at buffalo.edu