[SELECT ticket_id FROM ost_ticket T1 INNER JOIN ost_ticket_status status ON (status.id=T1.status_id AND status.state="open") LEFT JOIN ost_sla T2 ON (T1.sla_id=T2.id AND T2.isactive=1) WHERE isoverdue=0 AND ((reopened is NULL AND duedate is NULL AND TIME_TO_SEC(TIMEDIFF(NOW(),T1.created))>=T2.grace_period*3600) OR (reopened is NOT NULL AND duedate is NULL AND TIME_TO_SEC(TIMEDIFF(NOW(),reopened))>=T2.grace_period*3600) OR (duedate is NOT NULL AND duedate<NOW()) ) ORDER BY T1.created LIMIT 50]
Table 'osticket.ost_ticket_status' doesn't exist<br /> <br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1146', '[SELECT ticket_...')<br /> #1 (root)/include/class.ticket.php(2998): db_query('SELECT ticket_i...')<br /> #2 (root)/include/class.cron.php(31): Ticket->checkOverdue()<br /> #3 (root)/include/class.cron.php(99): Cron->TicketMonitor()<br /> #4 (root)/include/api.cron.php(19): Cron->run()<br /> #5 (root)/include/api.cron.php(40): CronApiController->run()<br /> #6 (root)/api/cron.php(23): LocalCronApiController::call()<br /> #7 {main}
Moin,
hängt mit den DB Umzügen zusammen, daher keine Gedanken machen ;)
Stefan
Am 30.09.2016 um 12:10 schrieb osTicket Benachrichtigungen via Admin:
[SELECT ticket_id FROM ost_ticket T1 INNER JOIN ost_ticket_status status ON (status.id=T1.status_id AND status.state="open") LEFT JOIN ost_sla T2 ON (T1.sla_id=T2.id AND T2.isactive=1) WHERE isoverdue=0 AND ((reopened is NULL AND duedate is NULL AND TIME_TO_SEC(TIMEDIFF(NOW(),T1.created))>=T2.grace_period*3600) OR (reopened is NOT NULL AND duedate is NULL AND TIME_TO_SEC(TIMEDIFF(NOW(),reopened))>=T2.grace_period*3600) OR (duedate is NOT NULL AND duedate<NOW()) ) ORDER BY T1.created LIMIT 50]
Table 'osticket.ost_ticket_status' doesn't exist<br />
<br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1146', '[SELECT ticket_...')<br /> #1 (root)/include/class.ticket.php(2998): db_query('SELECT ticket_i...')<br /> #2 (root)/include/class.cron.php(31): Ticket->checkOverdue()<br /> #3 (root)/include/class.cron.php(99): Cron->TicketMonitor()<br /> #4 (root)/include/api.cron.php(19): Cron->run()<br /> #5 (root)/include/api.cron.php(40): CronApiController->run()<br /> #6 (root)/api/cron.php(23): LocalCronApiController::call()<br /> #7 {main}
https://support.nordwest.freifunk.net _______________________________________________ Admin mailing list Admin@lists.ffnw.de https://lists.ffnw.de/mailman/listinfo/admin
-
osTicket Benachrichtigungen -
Stefan