Unable to set/reset password of user.
Software Version : osTicket-v1.12.2
MySql Version : 8.0.17
Getting following 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]+:291' AND NOT ost_session
.session_id
= '08o8sq8idor0ttf0cgueaevrce'] Incorrect description of a {min, max} interval.
---- Backtrace ----
#0 C:\retailapps\ticket\upload\include\mysqli.php(199): osTicket->logDBError('DB Error #3692', '[DELETE ost_se...')
#1 C:\retailapps\ticket\upload\include\class.orm.php(3455): db_query('DELETE
ost_ses...', true, true)
#2 C:\retailapps\ticket\upload\include\class.orm.php(1526): MySqlExecutor->execute()
#3 C:\retailapps\ticket\upload\include\class.auth.php(1343): QuerySet->delete()
#4 C:\retailapps\ticket\upload\include\class.signal.php(98): PasswordPolicy::cleanSessions(Object(User), Object(ClientSession))
#5 C:\retailapps\ticket\upload\include\class.client.php(474): Signal::send('auth.clean', Object(User), Object(ClientSession))
#6 C:\retailapps\ticket\upload\profile.php(33): ClientAccount->update(Array, Array)
#7 {main}
Log Date: 09/04/19 17:34:28 IP Address: ::1