Hello all,I just noticed our ticket counts are no longer working. I have attached a screenshot to explain what I mean.Also, I noticed we are getting the following errors in our logs:Got error 'PHP message: PHP Fatal error: Uncaught exception 'ObjectNotUnique' with message 'One object was expected; however multiple objects in the database matched the query.In fact, there are 1209 matching objects.' in /include/class.orm.php\nStack trace:\n#0 /include/ajax.search.php(395): QuerySet->one()\n#1 : SearchAjaxAPI->collectQueueCounts()\n#2 /include/class.dispatcher.php(145): call_user_func_array(Array, Array)\n#3 /include/class.dispatcher.php(38): UrlMatcher->dispatch('counts', Array)\n#4 /include/class.dispatcher.php(120): Dispatcher->resolve('counts', Array)\n#5 /include/class.dispatcher.php(38): UrlMatcher->dispatch('/queue/counts', NULL)\n#6 /scp/ajax.php(277): Dis...\n', referer: scp/tickets.php?queue=1I started off with replacing all files without any luck. I now assume there is a problem with the database.Where to look? I hope you guys can help me out.Julian

ticket_count.png

Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance.  The more information you give us the better we will be able to assist you. Thank you.No screen shot.No environment details.

Of course, sorry about that.PHP version: currently 5.6. Also tried 7.0.Operating System: Debian 9.When using staff side of the UI the errors mentioned above pop up in the logs. URLs: when clicking 'Open' or any of the other queues.When using the client side of the UI we do not get any errors in the logs although when people create a ticket but they do not send it in and come back later, their draft is stuck. The next time they create a new ticket, the draft from last time pops up and they can not remove it.I did try going back to the English language-settings, but that did not help.Tried attaching screenshots again.

ticket_count.png

db.png

I would recommend that you download the official version from osticket.com/download You appear to be running some unknown version from github.

Unfortunately that is not an option for us as we rely on the custom queues with specific colors and all extra options that come with that release.(https://github.com/greezybacon/osTicket-1.8/tree/feature/custom-queues)Do you have any other suggestions?

I do not.  I will ask the devs if they do though.

@[deleted]Please wait for the actual release of v1.11 to get the updated CC&CQ code.Cheers.

Thanks for your replies, is there any info on a 1.11 release date?As we are kinda stuck right now.

I'm told to expect 1.11 soon.

What is 'soon'? The problems I mentioned are causing huge issues for us so I am looking for a quick solution.

You're not going to get a better answer than that.  

Unfortunately that is not an option for us as we rely on the customs queues with specific colors and all extra options that come with that release. URL Removed

@[deleted] you appear to have posted a URL that looks suspiciously like spam in your response.  I have removed the URL.  Since the URL you posted pops up a Zen Desk chat client I presume that you are a spammer.  

Write a Reply...