- Edited
Hi,
A user just made a ticket for a department while putting another department in the CC, this gave a big SQL DB error and the department in the CC couldnt do anything with the ticket, everything was denied, even deleting the ticket from the cc department wasnt possible. I know you're only able to email 1 department, but before on another osTicket version when someone did this it would not make a bugged ticket and spew out DB errors.
In a previous version of osTicket (1.10) the email would only create a ticket for 1 department, but now it spews out errors and tries to make it for both departments. I deleted the ticket by going to the original receiving department, but how can I prevent this from happening again?
DB Error #1062
ost_thread_referral
[INSERT INTOSET
thread_id= 14880,
object_id= 1,
object_type= 'D',
created= NOW()] Duplicate entry '1-D-14880' for key 'ost_thread_referral.ref'<br /> <br /> ---- Backtrace ----<br /> #0 C:\inetpub\wwwroot\osTicket\include\mysqli.php(211): osTicket->logDBError()<br /> #1 C:\inetpub\wwwroot\osTicket\include\class.orm.php(3482): db_query()<br /> #2 C:\inetpub\wwwroot\osTicket\include\class.orm.php(658): MySqlExecutor->execute()<br /> #3 C:\inetpub\wwwroot\osTicket\include\class.thread.php(1961): VerySimpleModel->save()<br /> #4 C:\inetpub\wwwroot\osTicket\include\class.thread.php(380): ThreadReferral::create()<br /> #5 C:\inetpub\wwwroot\osTicket\include\class.ticket.php(3039): Thread->refer()<br /> #6 C:\inetpub\wwwroot\osTicket\include\class.thread.php(1418): Ticket->systemReferral()<br /> #7 C:\inetpub\wwwroot\osTicket\include\api.tickets.php(187): ThreadEntry::lookupByEmailHeaders()<br /> #8 C:\inetpub\wwwroot\osTicket\include\class.mailfetch.php(84): TicketApiController->processEmail()<br /> #9 C:\inetpub\wwwroot\osTicket\include\class.mailfetch.php(137): osTicket\Mail\Fetcher->processMessage()<br /> #10 C:\inetpub\wwwroot\osTicket\include\class.email.php(1129): osTicket\Mail\Fetcher->processEmails()<br /> #11 C:\inetpub\wwwroot\osTicket\include\class.mailfetch.php(254): MailBoxAccount->fetchEmails()<br /> #12 C:\inetpub\wwwroot\osTicket\include\class.cron.php(25): osTicket\Mail\Fetcher::run()<br /> #13 C:\inetpub\wwwroot\osTicket\include\class.cron.php(110): Cron::MailFetcher()<br /> #14 C:\inetpub\wwwroot\osTicket\include\api.cron.php(15): Cron::run()<br /> #15 C:\inetpub\wwwroot\osTicket\include\api.cron.php(45): CronApiController->run()<br /> #16 C:\inetpub\wwwroot\osTicket\api\cron.php(23): LocalCronApiController::call()<br /> #17 {main}