What version # of Moodle are you running and are you using the standard gradebook?
Hi Donnie,
If you don't mind could you post the entries in the mdl_grade_item table for the corresponding course. My guess is there are duplicates there. The weird part is that this is only happening for your forums. I've seen this before and haven't been able to reproduce the error to troubleshoot why it is happening.
To get back up and running you need to cross-reference the entries in the table with the relevant entries in the mdl_course_modules table and delete the incorrect duplicate.
Jeff
If you don't mind could you post the entries in the mdl_grade_item table for the corresponding course. My guess is there are duplicates there. The weird part is that this is only happening for your forums. I've seen this before and haven't been able to reproduce the error to troubleshoot why it is happening.
To get back up and running you need to cross-reference the entries in the table with the relevant entries in the mdl_course_modules table and delete the incorrect duplicate.
Jeff
Strange thing, this is happening to me. I actually forgot about it because the grade exception feature is not something I use. When I saw Donnie's post though I remembered!
It's been awhile since my duplicates first appeard. I've just been passing them along from semester to semester.
My duplicates include more than just forums and there doesn't seem to be any pattern in what get's duplicated.
My thought is that it's an old bug that may have been fixed because I haven't noticed in any of my newly created courses.
It it will help in troubleshooting, I've uploaded a text file of a couple of queries and the corresponding output.
Scott
It's been awhile since my duplicates first appeard. I've just been passing them along from semester to semester.
My duplicates include more than just forums and there doesn't seem to be any pattern in what get's duplicated.
My thought is that it's an old bug that may have been fixed because I haven't noticed in any of my newly created courses.
It it will help in troubleshooting, I've uploaded a text file of a couple of queries and the corresponding output.
Scott
Your queries do help, but I'm unclear on how I identify the duplicates.
Hi Scott,
Sorry for the slow reply. Getting ready for the fall semester here.
It's hard to say which ones you should delete. I should have said you need to cross-reference mdl_grade_items with your mdl_grade_categories table. In your mdl_grade_items table take a look at the entries where cminstance=173 or cminstance=178 these are your duplicated entries. It is not quite clear which ones to delete due to the fact that some are in category 47 and some are in category 48. My guess is the category=48 entries are probably duplicated, and one of the two entries with category=47 (for each cminstance) is a duplicate.
You could also just delete all the entries where cminstance = 173 or cminstance = 178. The next time you visit the gradebook the entries will be recreated and you may have recategorize those two items.
Can you comment if those extraneous entries are for the forum module as well?
regards,
Jeff
Sorry for the slow reply. Getting ready for the fall semester here.
It's hard to say which ones you should delete. I should have said you need to cross-reference mdl_grade_items with your mdl_grade_categories table. In your mdl_grade_items table take a look at the entries where cminstance=173 or cminstance=178 these are your duplicated entries. It is not quite clear which ones to delete due to the fact that some are in category 47 and some are in category 48. My guess is the category=48 entries are probably duplicated, and one of the two entries with category=47 (for each cminstance) is a duplicate.
You could also just delete all the entries where cminstance = 173 or cminstance = 178. The next time you visit the gradebook the entries will be recreated and you may have recategorize those two items.
Can you comment if those extraneous entries are for the forum module as well?
regards,
Jeff
Hi Donnie,
Sorry for the slow reply
Taking a look at your data it appears that the entries corresponding to the following ids need to be deleted from your mdl_grade_items table.
1781,1772,1763,1754,1780,1771,1762,1753,1779,1770,1761,1752,1778,1769,1760,1751,1776,1767,1758,1749,1775,1766,1757,1748,1774,1765,1756,1747,1764,1755,1746,1744
you can issue the following SQL to clear these extra entries out;
delete from mdl_grade_items where id in (1781,1772,1763,1754,1780,1771,1762,1753,1779,1770,1761,1752,1778,1769,1760,1751,1776,1767,1758,1749,1775,1766,1757,1748,1774,1765,1756,1747,1764,1755,1746,1744);
This shouldn't cause any serious problems, but as always it is best practice to backup your db before performing anything like this.
This sounds like it is actually a problem with how the forum module interacts with the gradebook as it appears no other module is resulting in this same problem. Yet another reason to move to a centralized grades table with a clearly defined API.
Sorry for the slow reply
Taking a look at your data it appears that the entries corresponding to the following ids need to be deleted from your mdl_grade_items table.
1781,1772,1763,1754,1780,1771,1762,1753,1779,1770,1761,1752,1778,1769,1760,1751,1776,1767,1758,1749,1775,1766,1757,1748,1774,1765,1756,1747,1764,1755,1746,1744
you can issue the following SQL to clear these extra entries out;
delete from mdl_grade_items where id in (1781,1772,1763,1754,1780,1771,1762,1753,1779,1770,1761,1752,1778,1769,1760,1751,1776,1767,1758,1749,1775,1766,1757,1748,1774,1765,1756,1747,1764,1755,1746,1744);
This shouldn't cause any serious problems, but as always it is best practice to backup your db before performing anything like this.
This sounds like it is actually a problem with how the forum module interacts with the gradebook as it appears no other module is resulting in this same problem. Yet another reason to move to a centralized grades table with a clearly defined API.