I seem to be stumbling into a SQL/Interfacing bug when users try to create an account.
When the user submits their information to create an account, they are met with an HTTP/500 error, and the helpdesk log has the following DB error:
<DB Error #3692>
[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]+:74'] Incorrect description of a {min, max} interval.
---- Backtrace ----
#0 xxx\include\mysqli.php(200): osTicket->logDBError('DB Error #3692', '[DELETE ost_se...')
#1 xxx\include\class.orm.php(3459): db_query('DELETEost_ses...', true, true)
#2 xxx\include\class.orm.php(1534): MySqlExecutor->execute()
#3 xxx\include\class.auth.php(1380): QuerySet->delete()
#4 xxx\include\class.signal.php(98): PasswordPolicy::cleanSessions(Object(User), NULL)
#5 xxx\include\class.client.php(481): Signal::send('auth.clean', Object(User), NULL)
#6 xxx\account.php(97): ClientAccount->update(Array, Array)
#7 {main}
Could someone help me identify where to go and look for or fix the error?
**Current Versioning:
osTicket Version** - v1.14.1 (f1e9e88) — Up to date
Web Server Software - Microsoft-IIS/7.5
MySQL Version - 8.0.17
PHP Version - 7.3.8
