New Installation v1.15.3.1 - DB Error #1054

compumatter

I am getting this page of errors when trying to "search" on users.

I have followed other posts with this error but found no solution. I am not sure why it is being produced.

I am running a Linux server with php 7.2

Thank you.

Jay Lepore
CompuMatter

[SELECT A1.id, A1.name, A6.address FROM hm_user A1 LEFT JOIN hm_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN hm_organization A3 ON (A1.org_id = A3.id) LEFT JOIN hm_user_account A4 ON (A1.id = A4.user_id) LEFT JOIN hm_user__cdata A5 ON (A1.id = A5.user_id) LEFT JOIN hm_user_email A6 ON (A1.default_email_id = A6.id) WHERE (A2.address LIKE '%Help%' OR A1.name LIKE '%Help%' OR A3.name LIKE '%Help%' OR A4.username LIKE '%Help%' OR A5.phone LIKE '%Help%') 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}

compumatter

I believe I've solved my own problem here by finding further posts on this. This was my solution

Emails were not coming AND I was getting a face full of errors like this

[INSERT INTO hm_user__cdata SET notes='', user_id= 3 ON DUPLICATE KEY UPDATE notes='']

Unknown column 'notes' in 'field list'

Solution:

Go to your database and drop all tables ending with _cdata (it will be rebuilt automatically using the cron.php below)
Go to terminal and then navigate to the install directory of osticket ie; /public_html/api
Type: php cron.php
php takes about 45 seconds to rebuild the database and pull in the email

Done. No more errors, mail pulled in