Morning folks, I'm running an SQL report using the Moodle Dashboard and it returns the 'Async Call Failed!' error. The SQL report is mainly targeting the logstore_standard_log and I only seem to get this error when trying to retrieve data from this table. I'm running Moodle 2.9.
Any thoughts or suggestions?
Thanks, Chris
By the way...here's the SQL:
select
mdl_course.shortname,
concat (mdl_user.firstname, ' ', mdl_user.lastname) as Who,
mdl_user.email,
mdl_logstore_standard_log.timecreated
From mdl_logstore_standard_log
Left join mdl_course on mdl_logstore_standard_log.courseid = mdl_course.id
Left join mdl_user on mdl_logstore_standard_log.userid = mdl_user.id
Left join mdl_course_categories on mdl_course.category = mdl_course_categories.id
WHERE mdl_course.shortname LIKE '%16WNCMP%' AND mdl_course.shortname LIKE '%201%'
AND mdl_logstore_standard_log.timecreated > unix_timestamp('2016-02-01 00:00:00')
AND mdl_logstore_standard_log.component = 'mod_lti'
AND mdl_logstore_standard_log. action = 'viewed'
ORDER by mdl_user.email, mdl_logstore_standard_log.timecreated