Create a quiz through sql

Create a quiz through sql

par Syed Irtaza Ali,
Nombre de réponses : 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?



Moyenne des évaluations  -
En réponse à Syed Irtaza Ali

Re: Create a quiz through sql

par Tim Hunt,
Avatar Core developers Avatar Documentation writers Avatar Particularly helpful Moodlers Avatar Peer reviewers Avatar 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.
En réponse à Tim Hunt

Re: Create a quiz through sql

par 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