Delete all Quiz attempt

Delete all Quiz attempt

by Aleksandar Petic -
Number of replies: 1

Hi,

I use Moodle 1.99 and want delete all attemps in Quiz. But, table _states have 1.4GB and _attempt 870MB. In Result view "Nothing to display".

Please help, my site is down due to the full utilization of the space.

Average of ratings: -
In reply to Aleksandar Petic

Re: Delete all Quiz attempt

by Aleksandar Petic -

Solved,

TRUNCATE table mdl_question_sessions
TRUNCATE table mdl_question_states
TRUNCATE table mdl_question_attempts
TRUNCATE table mdl_quiz_attempts
TRUNCATE table mdl_quiz_grades

Average of ratings: -