I'm getting an error in the Cron Job since upgrading to Totara v1.0.10:
Starting the completion cron... Error: more than one record returned (table 'course_completion_aggr_methd')
The cron doesn't continue after this error message and therefore won't comnplete
I have recently been playing around with Course completions and conditonal activies.
So i'm wondering if this is an error/bug with the update or is it something i have switched on since working with the updated version of Totara?
We recently discovered a bug in a particular library that causes errors like this. We're in the process of fixing it at the moment, and hope to have a fix ready for next week.
At the moment the only fix is to manually delete the duplicate records from the database.
Simon
how do I go about manually deleting the duplicate records from the database? Also, importantly without breaking the database...
I'm assuming this will be done through Terminal on our Linux server in the postgresql database shell script...?
If you can wait a few more days the latest release will automatically remove the duplicates. If you'd rather do it yourself before then, I'll ask Aaron to post the SQL commands that you need to enter into the postgres console. Please make sure you have a backup before modifying the database directly though!
Simon
