alexwebgr

# Completely remove any previous config
sudo apt remove --purge mysql*
sudo apt autoremove
sudo find / -iname mysql

# install the server
sudo apt update
sudo apt install mysql-server
# run the wizard
sudo mysql_secure_installation

mikebuchanon

UPDATE mdl_grade_grades AS mgg
SET overridden=0
FROM mdl_grade_items mgi,
     mdl_user mu,
     mdl_course mc
WHERE mgi.id=mgg.itemid
    AND mu.id=mgg.userid
    AND mc.id=mgi.courseid
    AND mgg.overridden != 0
    AND mc.shortname='mdc03'

mikehas

select c.id as course_id, 
  c.visible as visible,
  c.shortname as course_name, 
  fac.userid as instructor,
  COALESCE(q.all_quizs,0) as all_quizs, 
  COALESCE(ass.all_assignments,0) as all_assignmenets, 
  COALESCE(wiki.all_wikis,0) as all_wikis,
  COALESCE(r.all_resources,0) as all_resources,
  COALESCE(u.all_urls,0) as all_urls,
  COALESCE(pa.all_pages,0) as all_pages,

mkolb

<?php
ob_start();
var_dump($this);
error_log(ob_get_clean());
?>