I received the following error in an email when I tried logging in as a new test user. This is on version 1.12.2 running PHP 5.6.31 and mysql 8.0.17 all running on Windows 7.

[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]+:3']

Incorrect description of a {min,max} interval.<br />
<br />
---- Backtrace ----<br />
#0 C:\inetpub\wwwroot\helpdesk\include\mysqli.php(199): osTicket->logDBError('DB Error #3692', '[DELETE ost_se...')<br />
#1 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(3455): db_query('DELETEost_ses...', true, true)<br />
#2 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1526): MySqlExecutor->execute()<br />
#3 C:\inetpub\wwwroot\helpdesk\include\class.auth.php(1343): QuerySet->delete()<br />
#4 [internal function]: PasswordPolicy::cleanSessions(Object(User), NULL)<br />
#5 C:\inetpub\wwwroot\helpdesk\include\class.signal.php(98): call_user_func_array(Array, Array)<br />
#6 C:\inetpub\wwwroot\helpdesk\include\class.client.php(474): Signal::send('auth.clean', Object(User), NULL)<br />
#7 C:\inetpub\wwwroot\helpdesk\account.php(97): ClientAccount->update(Array, Array)<br />
#8 {main}

@bsargent

Do me a favor, please login to MySQL and run the following (make sure you copy the entire thing):

SELECT * 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]+:3';

The above query should produce the same error as you originally posted. Now, after that run the following:

SELECT * 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]+:3';

(it may look like the same query but it's not)

This should run successfully and possibly return some data. If this is the case please report back with your findings.

Cheers.

They both seem to generate the same error message.

SQL Error (3692): Incorrect description of a {min,max} interval.uery

a month later

Hey...
You can change this Code in OSTicket\include\class.auth.php row 1331.
From
$regexp = '_auth\|.*"user";[a-z]+:[0-9]+:{[a-z]+:[0-9]+:"id";[a-z]+:'.$model->getId();

to
$regexp = '_auth\|.*"user";[a-z]+:[0-9]+:\{[a-z]+:[0-9]+:"id";[a-z]+:'.$model->getId();

It works fine for me :-)

At this point, I would also like to mention again that the editing of the source code of OSTicket absolutely NO WARRANTY and at your own risk.
This is NOT an OFFICIAL SOLUTION by the manufacturer!

    a year later
    Write a Reply...