Hi all,
im new to osTicket and have the latest version installed on a Linux server. I am able to login via LDAP/AD but not able to update the profile information. I keep getting ERROR 500 on the profile.php page and am hesitant to put this in my production environment until I can do this update . Any help would be appreciated.

Error Log:
DB Error #3692
[DELETE qhp_session.* FROM qhp_session WHERE qhp_session.user_id = 0 AND qhp_session.session_data REGEXP '_auth\|.*\"user\";[a-z]+:[0-9]+:{[a-z]+:[0-9]+:\"id\";[a-z]+:7'] Incorrect description of a {min, max} interval.

---- Backtrace ----
#0 (root)/include/mysqli.php(200): osTicket->logDBError('DB Error #3692', '[DELETE qhp_se...')
#1 (root)/include/class.orm.php(3464): db_query('DELETE
qhp_ses...', true, true)
#2 (root)/include/class.orm.php(1528): MySqlExecutor->execute()
#3 (root)/include/class.auth.php(1344): QuerySet->delete()
#4 (root)/include/class.signal.php(98): PasswordPolicy::cleanSessions(Object(User), NULL)
#5 (root)/include/class.client.php(474): Signal::send('auth.clean', Object(User), NULL)
#6 (root)/account.php(97): ClientAccount->update(Array, Array)
#7 {main}

System Information:
About this osTicket Installation
Server Information
osTicket Version v1.12.6 (e351ba5) — Up to date
Web Server Software Apache/2.4.41 (Ubuntu)
MySQL Version 8.0.21
PHP Version 7.2.33-1+ubuntu20.04.1+deb.sury.org+1
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone America/Chicago
Database Information and Usage
Schema osticket (localhost)
Schema Signature 00c949a623b82848baaf3480b51307e3
Space Used 5.22 MiB
Space for Attachments 0.03 MiB
Timezone CDT (Interpreted as America/Chicago)

Installed Language Packs
English (United States)
en_US — include/i18n/en_US

I know you are busy but that answer was no help at all... I'll leave this for some who can decode what you wrote.

The offending line can be found in <site root>/include/class.auth.php line 1332

He's saying that the bug was reported and dealt with.
The patch to fix the issue that you are reporting is located at the URL he provided.
You can apply the patch, or wait until the next version is released.

Write a Reply...