Hi,
New install of the latest version here.
I added a user manually to open a ticket, after i try to open another ticket with the same user it brings it brings up the search bar, when i search for the user nothing shows up.
This is the error:
DB Error #1054
[SELECT A1.`id`, A1.`name`, A6.`address` FROM `dram_user` A1 LEFT JOIN `dram_user_email` A2 ON (A1.`id` = A2.`user_id`) LEFT JOIN `dram_organization` A3 ON (A1.`org_id` = A3.`id`) LEFT JOIN `dram_user_account` A4 ON (A1.`id` = A4.`user_id`) LEFT JOIN `dram_user__cdata` A5 ON (A1.`id` = A5.`user_id`) LEFT JOIN `dram_user_email` A6 ON (A1.`default_email_id` = A6.`id`) WHERE (A2.`address` LIKE '%asdadas%' OR A1.`name` LIKE '%asdadas%' OR A3.`name` LIKE '%asdadas%' OR A4.`username` LIKE '%asdadas%' OR A5.`phone` LIKE '%asdadas%') LIMIT 25] Unknown column 'A5.phone' in 'where clause'
---- Backtrace ----
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT A1.`id`...')
#1 (root)/include/class.orm.php(3466): db_query('SELECT A1.`id`, ...', true, true)
#2 (root)/include/class.orm.php(3522): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2070): MySqlExecutor->getRow()
#4 (root)/include/class.orm.php(2043): FlatArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1729): CachedResultSet->asArray()
#10 (root)/include/ajax.users.php(98): CachedResultSet->getIterator()
#11 (root)/include/class.dispatcher.php(145): UsersAjaxAPI->search('local')
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/local', Array)
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('/local', Array)
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users/local', NULL)
#15 (root)/scp/ajax.php(316): Dispatcher->resolve('/users/local')
#16 {main}
Any help?