- Edited
osTicket Version: v1.10 (901e5ea)Web Software: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.23MySQL Version: 10.1.13PHP Version: 5.6.23OS: Win2k8r2Browsers used: IE11 and ChromeOther discussions seem to indicate the error occurs after updating. Whatever happened here, I did it to myself. I wanted to do a search through all tickets based on a custom field. I created the search (screenshot attached). As soon as I hit search, I got an Internal Server Error (http 500). Everything still works fine through Chrome. Clearing cache in IE does nothing. Every time I attempt to login as an Agent through IE, I get the DB error:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') __' at line 1<br /> <br />---- Backtrace ----<br />#0 C:\xampp\htdocs\Support\include\mysqli.php(204): osTicket->logDBError('DB Error #1064', '[SELECT COUNT(*...')<br />#1 C:\xampp\htdocs\Support\include\class.orm.php(3133): db_query('SELECT COUNT(*)...', true, true)<br />#2 C:\xampp\htdocs\Support\include\class.orm.php(3189): MySqlExecutor->execute()<br />#3 C:\xampp\htdocs\Support\include\class.orm.php(2644): MySqlExecutor->getRow()<br />#4 C:\xampp\htdocs\Support\include\class.orm.php(1193): MySqlCompiler->compileCount(Object(QuerySet))<br />#5 C:\xampp\htdocs\Support\scp\tickets.php(422): QuerySet->count()<br />#6 C:\xampp\htdocs\Support\scp\index.php(17): require('C:\\xampp\\htdocs...')<br />#7 {main}I know this is a syntax error, but I have no idea where to find and resolve the issue. Any help towards explaining the behavior and coming up with a solution would be most appreciated.