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!