KevinTheJedi umh in the database i have to search for 12-D-158
?
I found this only in the error logs.
I don't know how to find the duplicate in the database and remove, i don't know the steps as usually i do not navigaste into database. Is OsTicket that caused this duplicate error :S
What steps i have to follow?
Logs say:
(49, 'Error', 'DB Error #1062', '[INSERT INTO `LVti_thread_referral` SET `thread_id` = 157, `object_id` = 12, `object_type` = \'D\', `created` = NOW()] Duplicate entry \'12-D-157\' for key \'ref\'<br /><br /> ---- Backtrace ----<br /> #0 (root)/include/mysqli.php(199): osTicket->logDBError(\'DB Error #1062\', \'[INSERT INTO `L...\')<br /> #1 (root)/include/class.orm.php(3455): db_query(\'INSERT INTO `LV...\', true, true)<br /> #2 (root)/include/class.orm.php(658): MySqlExecutor->execute()<br /> #3 (root)/include/class.thread.php(1824): VerySimpleModel->save()<br /> #4 (root)/include/class.thread.php(362): ThreadReferral::create(Array)<br /> #5 (root)/include/class.ticket.php(2602): Thread->refer(Object(Dept))<br /> #6 (root)/include/class.thread.php(570): Ticket->systemReferral(Array)<br /> #7 (root)/include/class.thread.php(844): Thread->postEmail(Array, Object(ThreadEntry))<br /> #8 (root)/include/class.mailfetch.php(861): ThreadEntry->postEmail(Array)<br /> #9 (root)/include/class.mailfetch.php(933): MailFetcher->createTicket(1)<br /> #10 (root)/include/class.mailfetch.php(1013): MailFetcher->fetchEmails()<br /> #11 (root)/include/class.cron.php(25): MailFetcher::run()<br /> #12 (root)/scp/autocron.php(69): Cron::MailFetcher()<br /> #13 {main}', '', '***', '2019-10-25 18:18:23', '2019-10-25 18:18:23'),
(50, 'Error', 'DB Error #1062', '[INSERT INTO `LVti_thread_referral` SET `thread_id` = 158, `object_id` = 12, `object_type` = \'D\', `created` = NOW()] Duplicate entry \'12-D-158\' for key \'ref\'<br />