C1: Question from a course linked to a quiz in another course and invisible in this other course

[NicoDucou]

There are question that are related to a quiz but that do never appear in this quiz.

What happens is the in Chamilo 1.11.x some question are getting relations with exercises that are in different course, but in this case the question does not appear in the exercise but it can generate error in some filters because the question is considered part of the exercise even if it does not appear.
An exemple of that we have the following situation :

• in c_quiz_question we have a registry with c_id = 1 for question 11
• in c_quiz_rel_question we have a registry with c_id = 1 for question 11 and exercise 22
• in c_quiz we have a registry with c_id = 2 from exercise 22

To list all the references of questions and exercises that do have this problem you can use this query :

select cqrq.* from c_quiz_rel_question cqrq inner join c_quiz cq on cq.id = cqrq.exercice_id inner join c_quiz_question cqq on cqq.iid = cqrq.question_id and cqrq.c_id != cq.c_id;

If you are sure that none of them is usefull them you can remove them all.