Error in event creation Incorrect result size: expected 1, actual 2

Support - Assistance technique
1

Hello everyone, I received an error message when creating an event in the tracker module
“Error in event creation
Incorrect result size: expected 1, actual 2” could someone help me solve this please. I am using Version 2.36.6 and the problem started recently.

I followed @Markus ’ solution https://community.dhis2.org/t/unable-to-create-events-after-upgrade-from-2-33-to-2-35-1/42186 by running the SQL query “select * from categorycombo where name = 'default’;” but it doesn’t help me because I have only one default categorycombo

err event
err event1562×679 49.9 KB

2

Hello, @lebaldem2 . Scroll down to my comments on @Markus solution.

1 Like
3

Hello @mmpeete below in image the contents of the categorycombo and categorycombos_categories tables the default is created on 2020-03-24, the issu arrived in May 2022

2
21513×125 44 KB

1

4

Hello everyone my problem was solved by deleting the second default from the categoryoptioncombo table. Thank you

2 Likes