User Tools

Site Tools


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