[smc.pbs]

Although we can create, and delete users. If we attempt to create a password for a user the account hangs, I get the following error message:

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]+:75’ AND NOT ost_session.session_id = ‘5e5hom1huof9f94aqjcd2kab90’]

Incorrect description of a {min,max} interval.

—- Backtrace —-
#0 D:\websites\newhelpdesk.peoplebasedhr.co.uk\include\mysqli.php(200): osTicket->logDBError()
#1 D:\websites\newhelpdesk.peoplebasedhr.co.uk\include\class.orm.php(3466): db_query()
#2 D:\websites\newhelpdesk.peoplebasedhr.co.uk\include\class.orm.php(1534): MySqlExecutor->execute()
#3 D:\websites\newhelpdesk.peoplebasedhr.co.uk\include\class.auth.php(1380): QuerySet->delete()
#4 D:\websites\newhelpdesk.peoplebasedhr.co.uk\include\class.signal.php(98): PasswordPolicy::cleanSessions()
#5 D:\websites\newhelpdesk.peoplebasedhr.co.uk\include\class.client.php(481): Signal::send()
#6 D:\websites\newhelpdesk.peoplebasedhr.co.uk\profile.php(33): ClientAccount->update()
#7 D:\websites\newhelpdesk.peoplebasedhr.co.uk\client.inc.php(91): require(‘D:\\websites\\new…’)
#8 D:\websites\newhelpdesk.peoplebasedhr.co.uk\secure.inc.php(18): require_once(‘D:\\websites\\new…’)
#9 D:\websites\newhelpdesk.peoplebasedhr.co.uk\profile.php(19): require(‘D:\\websites\\new…’)
#10 {main}

osTicket v1.14.2 // osTicket-1.14.2-Awesome-103
PHP 7.4.1 // MySQL 8.0.11 // Microsoft-IIS/10.0 web server

 

[stevland]

Sounds like an osTicket issue, rather than an osTicket Awesome issue.

What happens if you try it from vanilla osTicket? (press Shift + O)

Actually, see this:
https://forum.osticket.com/d/97597-resolved-user-reg-error-incorrect-description-of-a-min-max-interval

[stevland]

P.S. It sounds like it will be fixed by upgrading. So maybe start there.