Just upgraded to version 1.10.2 and whenever I try to open a ticket as an agent, I get the popup window asking me to search for an existing user or create a new user. I want to search for a user, but the search does not work and displays nothing. After that I receive multiple system alert emails advising me a database error. I will post the first few e-mails here, but if you need additional e-mails, I will gladly post them. I have altered my personal information.Thank you for any help!
Unknown column 'A4.phone' in 'where clause'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(204):
osTicket->logDBError('DB Error #1054', '[SELECT A1.`id`...')<br />
#1 (root)/include/class.orm.php(3133): db_query('SELECT
A1.`id`,...', true, true)<br />
#2 (root)/include/class.orm.php(3189):
MySqlExecutor->execute()<br />
#3 (root)/include/class.orm.php(1842):
MySqlExecutor->getRow()<br />
#4 (root)/include/class.orm.php(1815):
FlatArrayIterator->{closure}()<br />
#5 (root)/include/class.orm.php(1794):
CallbackSimpleIterator->next()<br />
#6 (root)/include/class.orm.php(1803):
CallbackSimpleIterator->rewind()<br />
#7 (root)/include/class.orm.php(1463):
CallbackSimpleIterator->valid()<br />
#8 (root)/include/class.orm.php(1480):
CachedResultSet->fillTo(9223372036854775807)<br />
#9 (root)/include/class.orm.php(1489):
CachedResultSet->asArray()<br />
#10 (root)/include/ajax.users.php(94):
CachedResultSet->getIterator()<br />
#11 : UsersAjaxAPI->search()<br
/>
#12 (root)/include/class.dispatcher.php(145):
call_user_func_array(Array, Array)<br />
#13 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(false,
Array)<br />
#14 (root)/include/class.dispatcher.php(120):
Dispatcher->resolve(false, Array)<br />
#15 (root)/include/class.dispatcher.php(38):
UrlMatcher->dispatch('/users', NULL)<br />
#16 (root)/scp/ajax.php(262): Dispatcher->resolve('/users')<br
/>
#17 {main}