I deleted a Quiz question directly from node and the quiz_node_relationship table was not cleaned up. The deleted quiz question still had an entry in the quiz_node_relationship table.

Maybe that is because quiz results existed that included the quiz question? But then why keep the relationship if the question is deleted?

Also the question I deleted was an H5P question and after deleting all quiz results the quiz_h5p_user_results table was likewise not cleaned up. It also contained entries for the deleted question.

Comments

webservant316 created an issue. See original summary.

webservant316’s picture

webservant316 CreditAttribution: webservant316 commented
Issue summary: View changes
djdevin’s picture

djdevin
Location Philadelphia
CreditAttribution: djdevin at Cadmium commented
Version: 7.x-4.0-rc7 » 7.x-5.x-dev

Similar to #2402535: Disabling a quiz question type module leaves quizes with an existing question of that type unusable - the question is what to do, and I think the answer is to prevent deletions when there are quizzes or results that contain the question.

webservant316’s picture

webservant316 CreditAttribution: webservant316 commented

I am in favor of whatever maintains the table relationships. Preventing deletion seems the simplest.

djdevin’s picture

djdevin
Location Philadelphia
CreditAttribution: djdevin at Cadmium commented
Status: Active » Closed (duplicate)

Moved to #2923829: Deal with deleted questions