[SELECT A1.id
, A1.name
, A6.address
FROM ost_user
A1 LEFT JOIN ost_user_email
A2 ON (A1.id
= A2.user_id
) LEFT JOIN ost_organization
A3 ON (A1.org_id
= A3.id
) LEFT JOIN ost_user_account
A4 ON (A1.id
= A4.user_id
) LEFT JOIN ost_user__cdata
A5 ON (A1.id
= A5.user_id
) LEFT JOIN ost_user_email
A6 ON (A1.default_email_id
= A6.id
) WHERE (A2.address
LIKE '%Kev%' OR A1.name
LIKE '%Kev%' OR A3.name
LIKE '%Kev%' OR A4.username
LIKE '%Kev%' OR A5.phone
LIKE '%Kev%') LIMIT 25]
Unknown column 'A5.phone' in 'where clause'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError()<br />
#1 (root)/include/class.orm.php(3466): db_query()<br />
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(2070): MySqlExecutor->getRow()<br />
#4 (root)/include/class.orm.php(2043): FlatArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo()<br />
#9 (root)/include/class.orm.php(1729): CachedResultSet->asArray()<br />
#10 (root)/include/ajax.users.php(98): CachedResultSet->getIterator()<br />
#11 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->search()<br />
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch()<br />
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve()<br />
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch()<br />
#15 (root)/scp/ajax.php(316): Dispatcher->resolve()<br />
#16 {main}