Hello All -

I when searching for a user, it returns no results and I see this (or sim) errors in the Admin:

DB Error #1054

[SELECT A1.id, A1.name, A6.address FROM ost_user A1 LEFT JOIN ost_user_email A2 ON (A1.id = A2.user_id) LEFT JOIN ost_organization A3 ON (A1.org_id = A3.id) LEFT JOIN ost_user_account A4 ON (A1.id = A4.user_id) LEFT JOIN ost_user__cdata A5 ON (A1.id = A5.user_id) LEFT JOIN ost_user_email A6 ON (A1.default_email_id = A6.id) WHERE (A2.address LIKE '%amy%' OR A1.name LIKE '%amy%' OR A3.name LIKE '%amy%' OR A4.username LIKE '%amy%' OR A5.phone LIKE '%amy%') 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()
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('', Array)
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('', Array)
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users', NULL)
#15 (root)/scp/ajax.php(316): Dispatcher->resolve('/users')
#16 {main}

This query runs fine on my production sites.

The error says Unknown column 'A5.phone' in 'where clause'

Did someone delete the phone variable from Admin panel -> Manage -> Forms -> Contact Information?

That should look like this:

a month later

Hi Ntozier,

We have the same issue. It a new installation of OSticket.
I check Contact Information form it the same as your screenshot.

Try dropping the ost_user__cdata table and then search for a user.

I dropped the ost_user__cdata table. But now i get the message Missing CDATA table.

Run cron manually to recreate it.

windows
C:\path\to\php\php.exe -f C:\path\to\osTicket\api\cron.php

*nix
\path\to\php\version\php -f \path\to\osTicket\api\cron.php

Very welcome.

I'll mark this as resolved and close the thread. Please feel free to open a new thread if you have another question.

ntozier changed the title to [resolved] DB Error 1054 When Searching for User.
Write a Reply...