Hello everyone,

We want to make sure we get all our users registered with a work address, and that login is required for them to access the system. We add users manually into osTicket, and either we send a registration email when we activate them, or we ask them to use the "forgot password" the first time they log in.

Once we create the account, select register, an email is received by the user who proceeds to enter a new password. After the password is entered the user receives an HTTP 500 error, and we have this in the system logs:

[DELETE ost_session.* FROM ost_session WHERE ost_session.user_id = 0 AND ost_session.session_data REGEXP '_auth\|.*\"user\";[a-z]+:[0-9]+:{[a-z]+:[0-9]+:\"id\";[a-z]+:9' AND NOT ost_session.session_id = '424e387beca0635c439ce4512b980ea4']

Incorrect description of a {min,max} interval.<br /> <br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #3692', '[DELETE ost_se...')<br />
#1 (root)/include/class.orm.php(3466): db_query('DELETEost_ses...', true, true)<br />
#2 (root)/include/class.orm.php(1534): MySqlExecutor->execute()<br />
#3 (root)/include/class.auth.php(1380): QuerySet->delete()<br />
#4 (root)/include/class.signal.php(98): PasswordPolicy::cleanSessions(Object(User), Object(ClientSession))<br />
#5 (root)/include/class.client.php(481): Signal::send('auth.clean', Object(User), Object(ClientSession))<br />
#6 (root)/profile.php(33): ClientAccount->update(Array, Array)<br />
#7 (root)/client.inc.php(91): require('/home/site/wwwr...')<br />
#8 (root)/secure.inc.php(18): require_once('/home/site/wwwr...')<br />
#9 (root)/profile.php(19): require('/home/site/wwwr...')<br />
#10 {main}

Does anyone knows what the problem could be?

Thank you,

Mark

Our settings:
allowed password resets in Settings > Agents > Settings
require user registration in Settings > Users > Settings
required email verification to check ticket status

Server Information
osTicket Version: v1.14.2 (cba6035) — Up to date
Web Server Software: Apache
MySQL Version: 8.0.15
PHP Version: 7.3.12