I recently upgraded to 1.17.3 and not long after I received 5 "DB Error #1062" errors and since that point I have not been able to receive new tickets.
This is one of the errors, they are all the same except for the specifics of the ID fields.
[INSERT INTO `ost_thread_referral` SET `thread_id` = 43486, `object_id` = 1, `object_type` = 'D', `created` = NOW()] Duplicate entry '1-D-43486' for key 'ref'
---- Backtrace ----
#0 {ROOT}\include\mysqli.php(211): osTicket->logDBError()
#1 {ROOT}\include\class.orm.php(3482): db_query()
#2 {ROOT}\include\class.orm.php(658): MySqlExecutor->execute()
#3 {ROOT}\include\class.thread.php(1961): VerySimpleModel->save()
#4 {ROOT}\include\class.thread.php(380): ThreadReferral::create()
#5 {ROOT}\include\class.ticket.php(3039): Thread->refer()
#6 {ROOT}\include\class.thread.php(1418): Ticket->systemReferral()
#7 {ROOT}\include\api.tickets.php(187): ThreadEntry::lookupByEmailHeaders()
#8 {ROOT}\include\class.mailfetch.php(84): TicketApiController->processEmail()
#9 {ROOT}\include\class.mailfetch.php(137): osTicket\Mail\Fetcher->processMessage()
#10 {ROOT}\include\class.email.php(1129): osTicket\Mail\Fetcher->processEmails()
#11 {ROOT}\include\class.mailfetch.php(254): MailBoxAccount->fetchEmails()
#12 {ROOT}\include\class.cron.php(25): osTicket\Mail\Fetcher::run()
#13 {ROOT}\include\class.cron.php(110): Cron::MailFetcher()
#14 {ROOT}\include\api.cron.php(15): Cron::run()
#15 {ROOT}\include\api.cron.php(45): CronApiController->run()
#16 {ROOT}\api\cron.php(23): LocalCronApiController::call()
#17 {main}
I'm not particularly skilled at PHP developer so not sure the best way to go about looking for a solution, any pointers would be very much appreciated
