Notifications
Clear all
6 Forums 829 Topics 3,280 Posts 2 Online 3,047 Members

Resolved DB Error #1146

4 Posts
3 Users
0 Reactions
92 Views
Posts: 2
Topic starter
(@airfiber)
Member
Joined: 8 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}

 


3 Replies
Posts: 1185
Admin
(@stevland)
Member
Joined: 10 years 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: 1185
Admin
(@stevland)
Member
Joined: 10 years 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: