[sgps]

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.

[City of Alton]

@sgps

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.  

[stevland]

@sgps

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!

[sgps]

Updated to osTicket: v1.10.4 (035fd0a) and installed osTicket-Awesome-1.10.1-v1.4 still the same error.

[stevland]

@sgps,

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! 

[sgps]

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.

[stevland]

@sgps,

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!