There is an existing ticket that is my exact issue, "DB Error 1054 When Searching for User"
I don't exactly understand the solution.
As a DB admin, I should drop the table, and then run the cron job which will recreate the missing table?
The solution posted on the other ticket appears to be for a newly installed system (perhaps without any production data)
If the solution still applies to our environment, I just want to make sure this won't lose any of our production data.
OST v1.15.3.1
php 7.4 (can replicate the problem with 7.3 also)
Error Log:
[SELECT A1.id, A1.name, A6.address FROM ost7i_user A1 LEFT JOIN ost7i_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN ost7i_organization A3 ON (A1.org_id = A3.id) LEFT JOIN ost7i_user_account A4 ON (A1.id = A4.user_id) LEFT JOIN ost7i_user__cdata A5 ON (A1.id = A5.user_id) LEFT JOIN ost7i_user_email A6 ON (A1.default_email_id = A6.id) WHERE (A2.address LIKE '%test2%' OR A1.name LIKE '%test2%' OR A3.name LIKE '%test2%' OR A4.username LIKE '%test2%' OR A5.phone LIKE '%test2%') LIMIT 25]
Unknown column 'A5.phone' in 'where clause'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT A1.id...')<br />
#1 (root)/include/class.orm.php(3466): db_query('SELECT A1.id,...', true, true)<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(9223372036854775807)<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('local')<br />
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/local', Array)<br />
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('/local', Array)<br />
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users/local', NULL)<br />
#15 (root)/scp/ajax.php(316): Dispatcher->resolve('/users/local')<br />
#16 {main}
