Have you checked these first?
Help us help you: include your environment details. We've made this easy for you. Use the Copy System Info button in Admin Panel › osAwesome › Diagnostics, then paste below.
Note: Never paste the contents of your ost-config.php file here; it holds your database credentials.
Two quick checks before posting: try clearing your browser cache, and press SHIFT+O on any Staff Panel page to enter Safe Mode (a stock osTicket with no enhancements). If the problem still shows in Safe Mode, it's in osTicket itself, not osTicket Awesome. But let us know about the issue either way.
Help us help you: include your environment details. We've made this easy for you. Use the Copy System Info button in Admin Panel › osAwesome › Diagnostics, then paste below.
This forum is public. Never post order numbers, full license keys, email addresses, or payment details.
This is the place for general questions about how billing and licensing work — renewals, activation, staging slots, plan differences, and what happens when a license lapses.
For anything tied to your specific account, refund, or payment, contact us directly instead.
osTicket: v1.10.1 (9ae093d)
osTicket-Awesome-1.10.4-v1.0
When attempting to create a new ticket as an agent, the search for existing user does not work. Getting a database error:
[SELECT A1.id, A1.name, A5.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__cdata A4 ON (A1.id = A4.user_id) LEFT JOIN ost_user_email A5 ON (A1.default_email_id = A5.id) WHERE (A2.address LIKE '%suga%' OR A1.name LIKE '%suga%' OR A3.name LIKE '%suga%' OR A4.phone LIKE '%suga%') LIMIT 25]
<br /> Table 'sgpsweba_osticket.ost_user__cdata' doesn't exist<br /><br /> <br /><br /> ---- Backtrace ----<br /><br /> #0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.id...')<br /><br /> #1 (root)/include/class.orm.php(3136): db_query('SELECT A1.id,...', true, true)<br /><br /> #2 (root)/include/class.orm.php(3192): MySqlExecutor->execute()<br /><br /> #3 (root)/include/class.orm.php(1845): MySqlExecutor->getRow()<br /><br /> #4 (root)/include/class.orm.php(1818): FlatArrayIterator->{closure}()<br /><br /> #5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next()<br /><br /> #6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind()<br /><br /> #7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid()<br /><br /> #8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807)<br /><br /> #9 (root)/include/class.orm.php(1489): CachedResultSet->asArray()<br /><br /> #10 (root)/include/ajax.users.php(94): CachedResultSet->getIterator()<br /><br /> #11 [internal function]: UsersAjaxAPI->search('local')<br /><br /> #12 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)<br /><br /> #13 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/local', Array)<br /><br /> #14 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('/local', Array)<br /><br /> #15 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users/local', NULL)<br /><br /> #16 (root)/scp/ajax.php(264): Dispatcher->resolve('/users/local')<br /><br /> #17 {main}
Reverted back to a backup copy of osTicket-Awesome-1.10.1-v1.4 and the function works.
osTicket Awesome 1.10.4-v1.0 is for osTicket 1.10.4 meaning you must upgrade your osticket from 1.10.1 to 1.10.4 in order for osticket awesome 1.10.4-v1.0 to function correctly.
Thank you for pointing that out. I can't believe I hadn't yet noticed that the user search is broken.
It isn't an osTicket Awesome problem though... it is also happening in osTicket 1.10.2 core and osTicket 1.10.4 core.
I may not have time to open an Issue on Github as I am catching a plane this afternoon. But I will as soon as I can if you don't beat me to it!
Updated to osTicket: v1.10.4 (035fd0a) and installed osTicket-Awesome-1.10.1-v1.4 still the same error.
UPDATE: This issue occurs on both of my unmodified 1.10.2 and 1.10.4 installations which both use my demo database.
https://osticketawesome.com/u-1.10.2/scp/tickets.php?a=open
https://osticketawesome.com/u-1.10.4/scp/tickets.php?a=open
Therefore I thought it was pretty clear that the issue is with these versions of osTicket core.
But ntozier (from the osTicket Forum) tested a 1.10.4 installation and reports that there is no issue on his end.
So I am confused as the source of this problem and actually I am mortified.
As it happens I am about to board my 2nd flight and I am starting a two-week vacation. I will have limited connectivity but I will try to look into this deeper as soon as possible.
In the meanwhile, unless you can think of a work-around I imagine that this would prevent your agents from working efficiently. The only suggestion I can offer is to revert back to osTicket-Awesome-1.10.1-v1.4 for now.
I am sorry for the inconvenience!
No worries brother. Your vacation is deserved. Don't worry too much about this. That is what backups are for. We will be here when you return. Hopefully it is an easier fix than what it seems.
Yikes, it has been 3 months... I have been meaning to get back to you. Sorry for the delay.
If you're still having this issue, it turns out that it is a glitch with osTicket core.
I fixed it by following the tips in the following thread in the osTicket forum:
Upgraded to 1.10.4, can't search users
I hope this helps!