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}
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?
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}
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!