Hello Tim,
Even I expected the same. I could fire some queries listed below :
select courseid, count(*) from mdl_grade_items where itemtype = 'course' group by courseid having count(*) > 1;
select * from mdl_grade_categories where courseid in (select courseid from mdl_grade_items where itemtype = 'course' group by courseid having count(*) > 1);
I could find duplicate records in mdl_grade_items and mdl_grade_categories.
Can you kindly guide me to proceed further?
Even I expected the same. I could fire some queries listed below :
select courseid, count(*) from mdl_grade_items where itemtype = 'course' group by courseid having count(*) > 1;
select * from mdl_grade_categories where courseid in (select courseid from mdl_grade_items where itemtype = 'course' group by courseid having count(*) > 1);
I could find duplicate records in mdl_grade_items and mdl_grade_categories.
Can you kindly guide me to proceed further?