Duplicate object error in php logs

TPE

I'd like to correct this problem that I see in the php log file:

[01-Feb-2023 17:03:07 UTC] PHP Fatal error: Uncaught ObjectNotUnique: One object was expected; however multiple objects in the database matched the query. In fact, there are 2 matching objects. in /home/domainname/public_html/service/include/class.orm.php:1364
Stack trace:
#0 /home/usaadmin/public_html/service/include/class.orm.php(606): QuerySet->one()
#1 /home/usaadmin/public_html/service/scp/tickets.php(36): VerySimpleModel::lookup(Array)
#2 {main}
thrown in /home/usaadmin/public_html/service/include/class.orm.php on line 1364

Thanks

KevinTheJedi

TPE

You will need to post the full stack trace.

Cheers.

TPE

Can you tell me specifically where to look.

I see nothing in the application nor php logs, other than what I copied out of the php log above.

Thank you!

KevinTheJedi

TPE

It's saying it's looking up a Ticket by ID (which should be unique) but there are two matches when there should be one. Go to your database, go to the ticket table, and run the following:

SELECT `ticket_id`, COUNT(*) FROM `ost_ticket` GROUP BY `ticket_id`;

You should see a record with the COUNT being 2 and you then need to figure out which one is errant and delete it.

Cheers.