Create a quiz through sql

Create a quiz through sql

by Syed Irtaza Ali -
Number of replies: 2

I have created a quiz by entering relevant data in the following tables

mdl_quiz
mdl_course_modules
mdl_course_sections
mdl_question
mdl_question_answers
mdl_quiz_slots
mdl_grade_items

but the quiz is not appearing on the course page in the Topic

Any help on the missing table entry?



Average of ratings: -
In reply to Syed Irtaza Ali

Re: Create a quiz through sql

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
Clear caches?

I woud not do it that way. I would to it using the Moodle API functions. Likely to be more reliable and more future-proof.
In reply to Tim Hunt

Re: Create a quiz through sql

by Syed Irtaza Ali -

Thanks Tim.

Purge All Caches worked!

I am trying to insert google forms quiz and the grade appears fine after insert in mdl_grade_grades

But the Course Total is not adding up the inserted grade. Do I have to manually update it? Any help where this CourseTotal column can be found