[Airfiber]

I get these error every now and again and not sure why as this is a clean install.

Table ‘hsde_osti832.ost_ticket__cdata’ doesn’t exist

—- Backtrace —-

#0 (root)/include/mysqli.php(204): osTicket->logDBError(‘DB Error #1146’, ‘[SELECT * FROM …’)

#1 (root)/include/staff/templates/priority.tmpl.php(28): db_query(‘SELECT * FROM o…’)

#2 (root)/include/ajax.tickets.php(206): include(‘/home/hsde/publ…’)

#3 [internal function]: TicketsAjaxAPI->previewPriority(’91’)

#4 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)

#5 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(’91/priority’, Array)

#6 (root)/include/class.dispatcher.php(120): Dispatcher->resolve(’91/priority’, Array)

#7 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘/tickets/91/pri…’, NULL)

#8 (root)/scp/ajax.php(264): Dispatcher->resolve(‘/tickets/91/pri…’)

#9 {main}

 

[stevland]

Database errors do occur in osTicket from time to time and are not necessarily related to osTicket Awesome.

One thing that jumps out at me though is this atypical prefix:

Table ‘hsde_osti832.ost_ticket__cdata’ doesn’t exist

Does ‘hsde_osti832‘ mean anything to you?

[Energy]

Not to hijack this thead but i have the same DB Error #1146<br />
<br />
This happen each time i try manual select to Choose Priority.<br />
<br />

Theme Information<br />
osTicket v1.10.4 // osTicket-Awesome-1.10.4-v1.0<br />
<br />

Your Software Environment<br />
PHP 5.5.38-1~dotdeb+7.1 // MySQL 5.5.60 // Apache/2.2.22 (Debian) web server<br />
<br />
Log error is the same each time.

[SELECT * FROM ost_ticket__cdata WHERE ticket_id = ‘12636’]

 

Table ‘localhost.ost_ticket__cdata’ doesn’t exist<br /> <br />

—- Backtrace —-<br />

#0 (root)/include/mysqli.php(204): osTicket->logDBError(‘DB Error #1146’, ‘[SELECT * FROM …’)<br />

#1 (root)/include/staff/templates/priority.tmpl.php(28): db_query(‘SELECT * FROM o…’)<br />

#2 (root)/include/ajax.tickets.php(206): include(‘(root)/includ…’)<br />

#3 [internal function]: TicketsAjaxAPI->previewPriority(‘12636’)<br />

#4 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)<br />

#5 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘12636/priority’, Array)<br />

#6 (root)/include/class.dispatcher.php(120): Dispatcher->resolve(‘12636/priority’, Array)<br />

#7 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch(‘/tickets/12636/…’, NULL)<br />

#8 (root)/scp/ajax.php(264): Dispatcher->resolve(‘/tickets/12636/…’)<br />

#9 {main}

http://osticket

[stevland]

Ah, yes. 

The ability to change the ticket priority from the ticket list is an osTicket Awesome-only mod that has been troublesome. It is being removed temporarily from the next release and will return better than ever in a future release… with a no db-error guarantee!