[Resolved] DB Error #1146

  • January 8, 2019 at 1:05 pm #2763
    A
    Airfiber
    Participant

    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}

     

  • January 9, 2019 at 9:42 am #2768
    stevland
    Keymaster

    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?

  • February 3, 2019 at 10:55 pm #2923
    Energy
    Participant

    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

  • March 15, 2019 at 5:41 pm #3211
    stevland
    Keymaster

    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!

You must be logged in to reply to this topic.