Tag Archives: SQL

Moodle Structure Problems

Recently I discovered our Moodle gradebook was playing up and not correctly recording marks from assignments as well as been unable to assign categories from quizes.
I tracked the problem down to the Moodle database losing all its default entries for its tables. Continue reading

Posted in Moodle | Tagged , , , , | Leave a comment

Some useful Moodle SQL Queries

I occasionally use the following SQL statements to clean-up our Moodle system and identify old courses. I recommend backing up your database before using any and knowing enough SQL to understand what they are doing before running them. I usually … Continue reading

Posted in Moodle | Tagged , , , , , | 5 Comments