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
[INSERT INTO
ost_thread_referralSETthread_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}

    kwekker

    It's trying to refer a department that is already referred. You can ignore this error unless it happens a lot or every single time.

    Cheers.

      KevinTheJedi

      Would it help if I changed mail fetch timings between all departments? Since they all have the exact same timing right now.

        kwekker

        No, it goes through each email separately. So it’ll login to mailbox 1, fetch emails, login to mailbox 2, etc.

        Cheers.

        a month later

        kwekker

        Are you by chance still experiencing this issue? If so, can you please provide example headers for me to test with or at least steps to replicate the issue? I can't seem to replicate this at all. My system just refers as it should with no errors.

        Cheers.

          13 days later

          KevinTheJedi

          Sorry for the late response, havent seen it happen anymore, but I can replicate it by putting two of the osticket "departments" in CC.

            KevinTheJedi

            Yes, but it would also do it if someone emailed someone directly in the To section and than put two departments in the CC.

            Write a Reply...