Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

DB Error #1142

We have migration to new server and osTicket upgrade from 1.9.12 to 1.9.14
Currently we get errror message  like below.
Any help in solving the problem would be greatly appreciated.


I get this error log:
[INSERT INTO ost_ticket_event SET ticket_id=5751, staff_id='0', team_id=5, dept_id=1, topic_id=27, timestamp=NOW(), state='created', staff='SYSTEM']

SELECT command denied to user ''@'localhost' for table 'ost_form_field'<br />
<br />
---- Backtrace ----<br />
#0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1142', '[INSERT INTO os...')<br />
#1 (root)/include/class.ticket.php(2082): db_query('INSERT INTO ost...')<br />
#2 (root)/include/class.ticket.php(2932): Ticket->logEvent('created')<br />
#3 (root)/include/class.mailfetch.php(787): Ticket::create(Array, Array, 'Email')<br />
#4 (root)/include/class.mailfetch.php(835): MailFetcher->createTicket(1)<br />
#5 (root)/include/class.mailfetch.php(915): MailFetcher->fetchEmails()<br />
#6 (root)/include/class.cron.php(25): MailFetcher->run()<br />
#7 (root)/include/class.cron.php(98): Cron->MailFetcher()<br />
#8 (root)/include/api.cron.php(19): Cron->run()<br />
#9 (root)/include/api.cron.php(12): CronApiController->run()<br />
#10 [internal function]: CronApiController->execute()<br />
#11 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)<br />
#12 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('cron', Array)<br />
#13 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('cron', Array)<br />
#14 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tasks/cron', NULL)<br />
#15 (root)/api/http.php(35): Dispatcher->resolve('/tasks/cron')<br /> 
#16 {main}

My config:
osTicket Version v1.9.14 (8b927a0)
MySQL 10.0.26
PHP 5.6.24-0+deb8u1

Comments

  • SELECT command denied to user ''@'localhost'

    Your database user does not appear to have a user name...
  • Yes.
    I see that in this error log.

    But do you have any concept where I can check it in osTicket config ?
    This is little strange as all ticket are created.

  • The MySQL Username is stored in /include/ost-config.php
Sign In or Register to comment.