Edit Certain Users or Creating a New User Results in an Error

[Marc]

A new problem has popped up for me. When creating a new user or when trying to edit certain users I get a 500 Internal Server Error response. When I looked at the Apache logs I see this, though I'm not sure what it means specifically.

[Wed May 10 16:32:39.177178 2023] [php:error] [pid 950] [client 10.103.5.77:53651] PHP Fatal error:  Uncaught ErrorException: /var/www/html/pages/team/team_user_edit.php line 176: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/html/pages/team/team_user_edit.php:176\nStack trace:\n#0 [internal function]: errorhandler(8192, '...', '...', 176)\n#1 /var/www/html/pages/team/team_user_edit.php(176): strtotime(NULL)\n#2 {main}\n  thrown in /var/www/html/pages/team/team_user_edit.php on line 176, referer: http://media-relations-server/pages/team/team_user.php

It looks like it might be a date/time inconsistency, but I'm not really sure. That said, the server's time is correct and matches the systems. There are no errors in the Installation Check.

Any ideas?

[Marc]

After troubling shooting for a week, I noticed something today. If the server is rebooted I can create new accounts and access the accounts generating the error, but after 5-10 min. the error returns.

Has anyone experienced something like this?

[Marc]

Well I spoke too soon. After another reboot the error happens immediately. No idea why it worked for about 10 min the last time.

[Marc]

Figured it out. I had to dig into the database but the issue is the users I can't edit have are set to NULL (checkbox) in "login_try_last". Once I add a date it fixes the problem. Now I need to figure out how to fix when creating a new user.

[Marc]

It turns out it's PHP 8.1 or higher. I got user creation working with 7.4 and 8.0 but any higher results in the error. This is with an existing database. I have yet to test a new installation, but if you have an existing install and upgrade you might have problems.