- Edited
We are getting DB error 1054 when searching for a user.Error: Unknown column 'A4.phone' in 'where clause' ---- Backtrace ---- #0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1054', '[SELECT A1.`id`...') #1 (root)/include/class.orm.php(3136): db_query('SELECT A1.`id`, ...', true, true) #2 (root)/include/class.orm.php(3192): MySqlExecutor->execute() #3 (root)/include/class.orm.php(1845): MySqlExecutor->getRow() #4 (root)/include/class.orm.php(1818): FlatArrayIterator->{closure}() #5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next() #6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind() #7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid() #8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807) #9 (root)/include/class.orm.php(1489): CachedResultSet->asArray() #10 (root)/include/ajax.users.php(94): CachedResultSet->getIterator() #11 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->search() #12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('', Array) #13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('', Array) #14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users', NULL) #15 (root)/scp/ajax.php(262): Dispatcher->resolve('/users') #16 {main}Steps to duplicate:Open ticketClick name of person who submitted ticketClick change user buttontype in search window, no results show, db errors logged.System:osTicket v1.10.4Ubuntu 16.04.5 LTSMySQL 5.7.23Apache 2.4.18PHP 7.0.31