can't delete all attempts on quiz

can't delete all attempts on quiz

by Dave Murray -
Number of replies: 2
Hi,

Moodle 2.8.5

My provider (siteground.com) tells me that my database has exceeded their size limit.

The largest tables are

mdl_question_attempt_step_data with 170.4MB

mdl_logstore_standard_log with 70.3MB

mdl_question_attempts with 59.3MB

mdl_question_attempt_steps with 40MB


I deleted all attempts in last semester's quizzes but each quiz still seems to have a lot of remaining attempts not related to any users at all.

Any idea on how I can check or remove these attempts?

I ran cron jobs and looked in tables to confirm, but I'm currently at a dead end.

Thanks,

Dave

Average of ratings: -
In reply to Dave Murray

Re: can't delete all attempts on quiz

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

In the quiz reports, in the options where it says "Attempts from", try setting that to "All users who have attempted the quiz".

Average of ratings: -
In reply to Tim Hunt

Re: can't delete all attempts on quiz

by Dave Murray -

Thanks Tim.


I tried that yesterday, but the report still came up with "Nothing to display".


However, some users were not in any of the course groups.

I set it to "All participants" AND "All users who have attempted the quiz", everything worked smoothly.

Problem solved. The system works fine, another case of human error!


Average of ratings: -