moodle-nettoyage-requete
Cours qui n'existent plus mais referencés dans table des logs
SELECT DISTINCT courseid FROM mdl_logstore_standard_log WHERE courseid NOT IN (SELECT DISTINCT id FROM mdl_course);
Effacage des cours qui n'existent plus mais referencés dans table des logs
DELETE FROM mdl_logstore_standard_log WHERE courseid NOT IN (SELECT DISTINCT id FROM mdl_course) AND courseid != 0;
moodle-nettoyage-requete.txt · Last modified: 2024/03/22 12:20 by 195.221.243.131 · Currently locked by: 158.69.55.82