Creating a new ticket as an Agent results in an error.

sgps · 2018-07-20T11:06:40Z

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] Table 'sgpsweba_osticket.ost_user__cdata' doesn't exist ---- Backtrace ---- #0 (root)/include/mysqli.php(204): osTicket->logDBError('DB Error #1146', '[SELECT A1.id...') #1 (root)/include/class.orm.php(3136): db_query('SELECT A1.id,...', true, true) #2 (root)/include/class.orm.php(3192): MySqlExecutor->execute() #3 (root)/include/class.orm.php(1845): MySqlExecutor->getRow() #4 (root)/include/class.orm.php(1818): FlatArrayIterator->{closure}() #5 (root)/include/class.orm.php(1797): CallbackSimpleIterator->next() #6 (root)/include/class.orm.php(1806): CallbackSimpleIterator->rewind() #7 (root)/include/class.orm.php(1463): CallbackSimpleIterator->valid() #8 (root)/include/class.orm.php(1480): CachedResultSet->fillTo(9223372036854775807) #9 (root)/include/class.orm.php(1489): CachedResultSet->asArray() #10 (root)/include/ajax.users.php(94): CachedResultSet->getIterator() #11 [internal function]: UsersAjaxAPI->search('local') #12 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array) #13 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/local', Array) #14 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('/local', Array) #15 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/users/local', NULL) #16 (root)/scp/ajax.php(264): Dispatcher->resolve('/users/local') #17 {main} Reverted back to a backup copy of osTicket-Awesome-1.10.1-v1.4 and the function works.

Page 2 / 2 Prev

Bugs and display issues

Last Post by stevland 8 years ago

6 Posts

3 Users

0 Reactions

40 Views

RSS

Posts: 3

sgps

Topic starter

Jul 22, 2018 2:42 am

(@sgps)

Member

Joined: 8 years ago

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.

Posts: 1177

stevland

Admin

Oct 31, 2018 5:35 am

(@stevland)

Member

Joined: 2 months ago

@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!

Page 2 / 2 Prev

6 Forums
829 Topics
3,267 Posts
1 Online
3,042 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

New: TCO Calculator

10 Years. 83 Releases. Still Shipping.

Forum

Creating a new ticket as an Agent results in an error.