Quiz and question banks

Hi,

After having corrected my problems related to "Question categories should belong to a valid context" (on my 3 Moodle plateforms), i still have other problems, but only on my main plateform.

My main platform was installed in june 2013, with a new Moodle 2.4, but we used backups from our old 1.9 Moodle (started with Moodle 1.4 or 1.5, and upgraded with 1.6 and 1.8). Last year, we upgraded to 2.7. So, it's now Moodle 2.7.4.

When i run moodle/admin/tool/health, i have these problems :

• "Multi-answer questions data consistency"
• "Only multianswer and random questions should be the parent of another question"
• "Question categories should belong to the same context as their parent"

For the last one, 2 courses are involved, with the same (6) question category names for parent and child. One was certainly a copy of the other one.

Possible solution for these problems say to ask here, so do i.

I've found this discussion about "Multi-answer questions data consistency", but with no real solution...

SELECT * FROM mdl_question q JOIN mdl_question parent_q ON parent_q.id = q.parent
WHERE parent_q.qtype NOT IN ('random', 'multianswer')
ORDER BY parent_q.id, q.id;

returns 10 rows : all shortanswer, and 2 different questions, with 5 occurrences of each (i suppose there as been copies...)

SELECT q.id, q.category, qma.sequence
FROM mdl_question q JOIN mdl_question_multianswer qma ON q.id = qma.question;

returns 143 rows.

What can i do exactly to solve each of these problems? Is there a (good) order to respect to fix it all?
More details the better...

Séverin