Forum

Notifications
Clear all

DB Error #1146

3 Posts
3 Users
0 Reactions
17 Views
Posts: 2
Topic starter
(@airfiber)
Member
Joined: 7 years ago

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}

 


2 Replies
Posts: 1177
Admin
(@stevland)
Member
Joined: 2 months ago

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?


Reply
Posts: 4
(@energy)
Member
Joined: 7 years ago

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


Reply
Posts: 1177
Admin
(@stevland)
Member
Joined: 2 months ago

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!


Reply
Share: