Here is my server environment.
OS: Server 2019 + IIS 10
osTicket version: 1.15.4
PHP: v7.2
MYSQL 5.5
I would like to search user in "User Directory". However it got DB error after searching.
The error code as below.
[SELECT COUNT(*) FROM (SELECT A1.
idFROM
ost_userA1 LEFT JOIN
ost_user_emailA2 ON (A1.
id= A2.
user_id) LEFT JOIN
ost_organizationA3 ON (A1.
org_id= A3.
id) LEFT JOIN
ost_user__cdataA4 ON (A1.
id= A4.
user_id) WHERE (A2.
addressLIKE '%Issac%' OR A1.
nameLIKE '%Issac%' OR A3.
nameLIKE '%Issac%' OR A4.
phone` LIKE '%Issac%')) __]
Unknown column 'A4.phone' in 'where clause'<br /> <br />
---- Backtrace ----<br />
#0 C:\inetpub\wwwroot\helpdesk\include\mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(...')<br />
#1 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(3466): db_query('SELECT COUNT()...', true, true)<br />
#2 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(3522): MySqlExecutor->execute()<br />
#3 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(2952): MySqlExecutor->getRow()<br />
#4 C:\inetpub\wwwroot\helpdesk\include\class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))<br />
#5 C:\inetpub\wwwroot\helpdesk\include\staff\users.inc.php(47): QuerySet->count()<br />
#6 C:\inetpub\wwwroot\helpdesk\scp\users.php(212): require('C:\inetpub\wwwr...')<br />
#7 {main}`