KevinTheJedi Hi Kevin,
Below is a recent log.
DB Error #1054
[SELECT COUNT(*) FROM (SELECT A1.id FROM ostn7_user A1 LEFT JOIN ostn7_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN ostn7_organization A3 ON (A1.org_id = A3.id) LEFT JOIN ostn7_user__cdata A4 ON (A1.id = A4.user_id) WHERE (A2.address LIKE '%ryan%' OR A1.name LIKE '%ryan%' OR A3.name LIKE '%ryan%' OR A4.phone LIKE '%ryan%')) __] Unknown column 'A4.phone' in 'where clause'
---- Backtrace ----
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT COUNT(...')
#1 (root)/include/class.orm.php(3466): db_query('SELECT COUNT()...', true, true)
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2952): MySqlExecutor->getRow()
#4 (root)/include/class.orm.php(1380): MySqlCompiler->compileCount(Object(QuerySet))
#5 (root)/include/staff/users.inc.php(47): QuerySet->count()
#6 (root)/scp/users.php(212): require('/home/superchan...')
#7 {main}
We are receiving alot of these every time we do something with a ticket.
Kind regards,
