Hello all,

After we added a few custom fields to the Contact Information form, we started to get the below errors. I tried to reset the fields, and also remove the custom fields we added, but we still get the DB errors.

Has anyone encountered this before, and what can be done to correct this? Thanks for your help.

[SELECT A1.id, A1.name, A5.address FROM helpdesk_user A1 LEFT JOIN helpdesk_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN helpdesk_organization A3 ON (A1.org_id = A3.id) LEFT JOIN helpdesk_user__cdata A4 ON (A1.id = A4.user_id) LEFT JOIN helpdesk_user_email A5 ON (A1.default_email_id = A5.id) WHERE (A2.address LIKE '%mar%' OR A1.name LIKE '%mar%' OR A3.name LIKE '%mar%' OR A4.phone LIKE '%mar%') LIMIT 25]

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('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(262): Dispatcher->resolve('/users/local') 
#16 {main}