moodle@moodle-VirtualBox:~$ sudo tail -f /tmp/mysql.log [sudo] password for moodle: FROM mdl_message_contacts WHERE userid = '2' OR contactid = '2' 2023-02-09T01:17:23.805127Z 93 Quit 2023-02-09T01:17:42.743972Z 89 Query SET global log_output = 'FILE' 2023-02-09T01:17:50.383159Z 89 Query SET global general_log_file='/tmp/mysql.log' /usr/sbin/mysqld, Version: 8.0.32-0ubuntu0.22.04.2 ((Ubuntu)). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument 2023-02-09T01:17:56.773633Z 89 Query SET global general_log = 1 2023-02-09T01:17:59.816605Z 89 Quit 2023-02-09T01:18:38.652863Z 94 Connect root@localhost on moodle using Socket 2023-02-09T01:18:38.653022Z 94 Query SET NAMES utf8mb4 2023-02-09T01:18:38.653113Z 94 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:38.654179Z 94 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:38.654772Z 94 Query SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = 'imu2bi67qam38cvb2vb2ubfkaf' 2023-02-09T01:18:38.655121Z 94 Query UPDATE mdl_sessions SET timemodified = '1675905518' WHERE id='2' 2023-02-09T01:18:38.664909Z 94 Query SELECT * FROM mdl_external_functions WHERE name = 'core_form_dynamic_form' 2023-02-09T01:18:38.665899Z 94 Query SELECT name,value FROM mdl_user_preferences WHERE userid = '2' 2023-02-09T01:18:38.668801Z 94 Query SELECT f.filter, fc.name, fc.value FROM mdl_filter_active f LEFT JOIN mdl_filter_config fc ON fc.filter = f.filter AND fc.contextid = f.contextid WHERE f.contextid = '1' AND f.active != '-9999' ORDER BY f.sortorder 2023-02-09T01:18:38.674495Z 94 Query SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '1' 2023-02-09T01:18:38.697659Z 94 Query INSERT INTO mdl_reportbuilder_report (name,source,type,uniquerows,conditiondata,settingsdata,contextid,component,area,itemid,usercreated,timecreated,timemodified,usermodified) VALUES('User','core_user\\reportbuilder\\datasource\\users','0','0',NULL,NULL,'1','','','0','2','1675905518','1675905518','2') 2023-02-09T01:18:38.708963Z 94 Query SELECT uif.*, uic.name AS categoryname FROM mdl_user_info_field uif LEFT JOIN mdl_user_info_category uic ON uif.categoryid = uic.id ORDER BY uic.sortorder ASC, uif.sortorder ASC 2023-02-09T01:18:38.713921Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.714258Z 94 Query SELECT uif.*, uic.name AS categoryname FROM mdl_user_info_field uif LEFT JOIN mdl_user_info_category uic ON uif.categoryid = uic.id ORDER BY uic.sortorder ASC, uif.sortorder ASC 2023-02-09T01:18:38.718397Z 94 Query SELECT MAX(columnorder) FROM mdl_reportbuilder_column WHERE reportid = '2' 2023-02-09T01:18:38.722582Z 94 Query SELECT MAX(sortorder) FROM mdl_reportbuilder_column WHERE reportid = '2' 2023-02-09T01:18:38.722795Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.723049Z 94 Query SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale, is_nullable, column_type, column_default, column_key, extra FROM information_schema.columns WHERE table_name = 'mdl_reportbuilder_column' AND table_schema = 'moodle' ORDER BY ordinal_position 2023-02-09T01:18:38.724629Z 94 Query INSERT INTO mdl_reportbuilder_column (reportid,uniqueidentifier,aggregation,heading,columnorder,sortenabled,sortdirection,sortorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:fullname',NULL,NULL,'1','0','4','1','2','1675905518','1675905518','2') 2023-02-09T01:18:38.732741Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.733092Z 94 Query UPDATE mdl_reportbuilder_column SET reportid = '2',uniqueidentifier = 'user:fullname',aggregation = NULL,heading = NULL,columnorder = '1',sortenabled = '1',sortdirection = '4',sortorder = '1',usercreated = '2',timemodified = '1675905518',usermodified = '2' WHERE id='1' 2023-02-09T01:18:38.737769Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.754091Z 94 Query SELECT MAX(columnorder) FROM mdl_reportbuilder_column WHERE reportid = '2' 2023-02-09T01:18:38.754324Z 94 Query SELECT MAX(sortorder) FROM mdl_reportbuilder_column WHERE reportid = '2' 2023-02-09T01:18:38.754530Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.754803Z 94 Query INSERT INTO mdl_reportbuilder_column (reportid,uniqueidentifier,aggregation,heading,columnorder,sortenabled,sortdirection,sortorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:username',NULL,NULL,'2','0','4','2','2','1675905518','1675905518','2') 2023-02-09T01:18:38.761268Z 94 Query UPDATE mdl_reportbuilder_column SET reportid = '2',uniqueidentifier = 'user:username',aggregation = NULL,heading = NULL,columnorder = '2',sortenabled = '0',sortdirection = '4',sortorder = '2',usercreated = '2',timemodified = '1675905518',usermodified = '2' WHERE id='2' 2023-02-09T01:18:38.761548Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.761782Z 94 Query SELECT MAX(columnorder) FROM mdl_reportbuilder_column WHERE reportid = '2' 2023-02-09T01:18:38.761959Z 94 Query SELECT MAX(sortorder) FROM mdl_reportbuilder_column WHERE reportid = '2' 2023-02-09T01:18:38.762138Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.762538Z 94 Query INSERT INTO mdl_reportbuilder_column (reportid,uniqueidentifier,aggregation,heading,columnorder,sortenabled,sortdirection,sortorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:email',NULL,NULL,'3','0','4','3','2','1675905518','1675905518','2') 2023-02-09T01:18:38.768691Z 94 Query UPDATE mdl_reportbuilder_column SET reportid = '2',uniqueidentifier = 'user:email',aggregation = NULL,heading = NULL,columnorder = '3',sortenabled = '0',sortdirection = '4',sortorder = '3',usercreated = '2',timemodified = '1675905518',usermodified = '2' WHERE id='3' 2023-02-09T01:18:38.768917Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.769620Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '0' 2023-02-09T01:18:38.770966Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.771244Z 94 Query SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale, is_nullable, column_type, column_default, column_key, extra FROM information_schema.columns WHERE table_name = 'mdl_reportbuilder_filter' AND table_schema = 'moodle' ORDER BY ordinal_position 2023-02-09T01:18:38.774116Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:fullname',NULL,'0','1','2','1675905518','1675905518','2') 2023-02-09T01:18:38.780588Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.780911Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '0' 2023-02-09T01:18:38.781138Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.781355Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:username',NULL,'0','2','2','1675905518','1675905518','2') 2023-02-09T01:18:38.789878Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.790164Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '0' 2023-02-09T01:18:38.790391Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.790634Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:email',NULL,'0','3','2','1675905518','1675905518','2') 2023-02-09T01:18:38.795691Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.796008Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '1' 2023-02-09T01:18:38.796240Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.796615Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:fullname',NULL,'1','1','2','1675905518','1675905518','2') 2023-02-09T01:18:38.802639Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.802926Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '1' 2023-02-09T01:18:38.803161Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.803473Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:username',NULL,'1','2','2','1675905518','1675905518','2') 2023-02-09T01:18:38.808110Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.808436Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '1' 2023-02-09T01:18:38.808673Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.808893Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:email',NULL,'1','3','2','1675905518','1675905518','2') 2023-02-09T01:18:38.813946Z 94 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:38.814451Z 94 Query SELECT MAX(filterorder) FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '1' 2023-02-09T01:18:38.814797Z 94 Query SELECT 'x' FROM mdl_reportbuilder_report WHERE id = '2' LIMIT 0, 1 2023-02-09T01:18:38.815319Z 94 Query INSERT INTO mdl_reportbuilder_filter (reportid,uniqueidentifier,heading,iscondition,filterorder,usercreated,timecreated,timemodified,usermodified) VALUES('2','user:suspended',NULL,'1','4','2','1675905518','1675905518','2') 2023-02-09T01:18:38.821684Z 94 Query UPDATE mdl_reportbuilder_report SET name = 'User',source = 'core_user\\reportbuilder\\datasource\\users',type = '0',uniquerows = '0',conditiondata = '{\"user:suspended_operator\":2}',settingsdata = NULL,contextid = '1',component = '',area = '',itemid = '0',usercreated = '2',timemodified = '1675905518',usermodified = '2' WHERE id='2' 2023-02-09T01:18:38.828421Z 94 Query SHOW VARIABLES LIKE 'max_allowed_packet' 2023-02-09T01:18:38.840907Z 94 Query INSERT INTO mdl_logstore_standard_log (eventname,component,action,target,objecttable,objectid,crud,edulevel,contextid,contextlevel,contextinstanceid,userid,courseid,relateduserid,anonymous,other,timecreated,origin,ip,realuserid) VALUES ('\\core_reportbuilder\\event\\report_created','core_reportbuilder','created','report','reportbuilder_report','2','c','0','1','10','0','2','0',NULL,'0','{\"name\":\"User\",\"source\":\"core_user\\\\reportbuilder\\\\datasource\\\\users\"}','1675905518','web','127.0.0.1',NULL),('\\core_reportbuilder\\event\\report_updated','core_reportbuilder','updated','report','reportbuilder_report','2','u','0','1','10','0','2','0',NULL,'0','{\"name\":\"User\",\"source\":\"core_user\\\\reportbuilder\\\\datasource\\\\users\"}','1675905518','web','127.0.0.1',NULL) 2023-02-09T01:18:38.849279Z 94 Quit 2023-02-09T01:18:38.876508Z 95 Connect root@localhost on moodle using Socket 2023-02-09T01:18:38.876694Z 95 Query SET NAMES utf8mb4 2023-02-09T01:18:38.876787Z 95 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:38.877590Z 95 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:38.878142Z 95 Query SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = 'imu2bi67qam38cvb2vb2ubfkaf' 2023-02-09T01:18:38.878650Z 95 Query SELECT name,value FROM mdl_user_preferences WHERE userid = '2' 2023-02-09T01:18:38.878916Z 95 Query UPDATE mdl_user SET lastip = '127.0.0.1',lastaccess = '1675905518' WHERE id='2' 2023-02-09T01:18:38.896297Z 95 Query SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '1' 2023-02-09T01:18:38.897304Z 95 Query SELECT * FROM mdl_role ORDER BY sortorder ASC 2023-02-09T01:18:38.902268Z 95 Query SELECT name, id, enabled FROM mdl_message_processors ORDER BY name DESC 2023-02-09T01:18:38.906551Z 95 Query SELECT * FROM mdl_user WHERE id = '2' AND deleted = '0' 2023-02-09T01:18:38.907566Z 95 Query SELECT * FROM mdl_oauth2_issuer WHERE showonloginpage<>'2' ORDER BY sortorder 2023-02-09T01:18:38.919976Z 95 Query SELECT f.filter, fc.name, fc.value FROM mdl_filter_active f LEFT JOIN mdl_filter_config fc ON fc.filter = f.filter AND fc.contextid = f.contextid WHERE f.contextid = '1' AND f.active != '-9999' ORDER BY f.sortorder 2023-02-09T01:18:38.960981Z 95 Query SELECT active.filter, fc.name, fc.value FROM (SELECT f.filter, MAX(f.sortorder) AS sortorder FROM mdl_filter_active f JOIN mdl_context ctx ON f.contextid = ctx.id WHERE ctx.id IN (1) GROUP BY filter HAVING MAX(f.active * ctx.depth) > -MIN(f.active * ctx.depth) ) active LEFT JOIN mdl_filter_config fc ON fc.filter = active.filter AND fc.contextid = 1 ORDER BY active.sortorder 2023-02-09T01:18:38.966638Z 95 Query SELECT * FROM mdl_oauth2_issuer WHERE showonloginpage<>'2' ORDER BY sortorder 2023-02-09T01:18:38.972379Z 95 Query SELECT * FROM mdl_portfolio_instance ORDER BY name 2023-02-09T01:18:38.990653Z 95 Query SELECT * FROM mdl_role ORDER BY sortorder ASC 2023-02-09T01:18:39.001343Z 95 Query SELECT r.* FROM mdl_role r WHERE r.id IN (SELECT rc.roleid FROM mdl_role_capabilities rc JOIN mdl_capabilities cap ON rc.capability = cap.name WHERE rc.capability = 'tool/dataprivacy:managedatarequests' ) 2023-02-09T01:18:39.001997Z 95 Query SELECT u.* FROM mdl_user u WHERE u.deleted = 0 AND u.id IN (2) 2023-02-09T01:18:39.003174Z 95 Query SELECT * FROM mdl_oauth2_issuer WHERE showonloginpage<>'2' ORDER BY sortorder 2023-02-09T01:18:39.012673Z 95 Query SELECT cc.id,cc.name,cc.idnumber,cc.parent,cc.sortorder,cc.coursecount,cc.visible,cc.depth,cc.path, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_course_categories cc JOIN mdl_context ctx ON cc.id = ctx.instanceid AND ctx.contextlevel = '40' WHERE cc.id = '1' ORDER BY cc.sortorder 2023-02-09T01:18:39.014738Z 95 Query SELECT * FROM mdl_context WHERE contextlevel = '30' AND instanceid = '2' 2023-02-09T01:18:39.015041Z 95 Query SELECT id,name,value FROM mdl_course_format_options WHERE courseid = '1' AND format = 'site' AND sectionid = '0' 2023-02-09T01:18:39.016047Z 95 Query SELECT ctx.* FROM mdl_context ctx WHERE ctx.path LIKE '/1/2/%' 2023-02-09T01:18:39.018412Z 95 Query SELECT c.* , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_course c JOIN ( SELECT DISTINCT e.courseid FROM mdl_enrol e JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '2') WHERE ue.status = '0' AND e.status = '0' AND ue.timestart <= '1675905519' AND (ue.timeend = 0 OR ue.timeend > '1675905519')) en ON (en.courseid = c.id) LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50') WHERE c.id <> 1 ORDER BY c.visible DESC,c.sortorder ASC 2023-02-09T01:18:39.019072Z 95 Query SELECT c.id,c.category,c.sortorder,c.shortname,c.fullname,c.idnumber,c.startdate,c.visible,c.defaultgroupingid,c.groupmode,c.groupmodeforce , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_course c JOIN (SELECT DISTINCT e.courseid FROM mdl_enrol e JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '2') WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1675905500 AND (ue.timeend = 0 OR ue.timeend > 1675905500) ) en ON (en.courseid = c.id) LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50') WHERE c.id <> 1 ORDER BY c.visible DESC,c.sortorder ASC 2023-02-09T01:18:39.027181Z 95 Query SELECT r.id, r.name, r.shortname, rn.name AS coursealias FROM mdl_role r JOIN mdl_role_context_levels rcl ON (rcl.contextlevel = '30' AND r.id = rcl.roleid) LEFT JOIN mdl_role_names rn ON (rn.contextid = '0' AND rn.roleid = r.id) ORDER BY r.sortorder ASC 2023-02-09T01:18:39.058503Z 95 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:39.058995Z 95 Query SELECT uif.*, uic.name AS categoryname FROM mdl_user_info_field uif LEFT JOIN mdl_user_info_category uic ON uif.categoryid = uic.id ORDER BY uic.sortorder ASC, uif.sortorder ASC 2023-02-09T01:18:39.063122Z 95 Query SELECT bi.id, COALESCE(bp.id, bs.id) AS blockpositionid, bi.blockname, bi.parentcontextid, bi.showinsubcontexts, bi.pagetypepattern, bi.requiredbytheme, bi.subpagepattern, bi.defaultregion, bi.defaultweight, COALESCE(bp.visible, bs.visible, 1) AS visible, COALESCE(bp.region, bs.region, bi.defaultregion) AS region, COALESCE(bp.weight, bs.weight, bi.defaultweight) AS weight, bi.configdata , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_block_instances bi JOIN mdl_block b ON bi.blockname = b.name LEFT JOIN mdl_block_positions bp ON bp.blockinstanceid = bi.id AND bp.contextid = '1' AND bp.pagetype = 'admin-reportbuilder-edit' AND bp.subpage = '' LEFT JOIN mdl_block_positions bs ON bs.blockinstanceid = bi.id AND bs.contextid = '1' AND bs.pagetype = 'admin-reportbuilder-edit' AND bs.subpage = '' LEFT JOIN mdl_context ctx ON (ctx.instanceid = bi.id AND ctx.contextlevel = '80') WHERE bi.parentcontextid IN ('1', '1') AND bi.pagetypepattern IN ('admin-reportbuilder-edit','admin-reportbuilder-edit-*','admin-reportbuilder-*','admin-*','*') AND (bi.subpagepattern IS NULL OR bi.subpagepattern = '') AND (bp.visible = 1 OR bp.visible IS NULL) AND (bs.visible = 1 OR bs.visible IS NULL) AND b.visible = 1 AND (bi.requiredbytheme = 0) ORDER BY COALESCE(bp.region, bs.region, bi.defaultregion), COALESCE(bp.weight, bs.weight, bi.defaultweight), bi.id 2023-02-09T01:18:39.077520Z 95 Query SELECT COUNT(mcr.id) FROM mdl_message_contact_requests mcr LEFT JOIN mdl_message_users_blocked mub ON mub.userid = mcr.requesteduserid AND mub.blockeduserid = mcr.userid WHERE mcr.requesteduserid = '2' AND mub.id IS NULL 2023-02-09T01:18:39.078065Z 95 Query SELECT COUNT(id) FROM mdl_message_contacts WHERE userid = '2' OR contactid = '2' 2023-02-09T01:18:39.108039Z 95 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:39.108412Z 95 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:39.108644Z 95 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:39.108877Z 95 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:39.117747Z 95 Quit 2023-02-09T01:18:40.197279Z 96 Connect root@localhost on moodle using Socket 2023-02-09T01:18:40.197416Z 96 Query SET NAMES utf8mb4 2023-02-09T01:18:40.197553Z 96 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:40.198341Z 96 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:40.198881Z 96 Query SELECT id, sid, state, userid, lastip, timecreated, timemodified FROM mdl_sessions WHERE sid = 'imu2bi67qam38cvb2vb2ubfkaf' 2023-02-09T01:18:40.199346Z 96 Query SELECT * FROM mdl_external_functions WHERE name = 'core_dynamic_tabs_get_content' 2023-02-09T01:18:40.200029Z 96 Query SELECT name,value FROM mdl_user_preferences WHERE userid = '2' 2023-02-09T01:18:40.202055Z 96 Query SELECT f.filter, fc.name, fc.value FROM mdl_filter_active f LEFT JOIN mdl_filter_config fc ON fc.filter = f.filter AND fc.contextid = f.contextid WHERE f.contextid = '1' AND f.active != '-9999' ORDER BY f.sortorder 2023-02-09T01:18:40.204188Z 96 Query SELECT * FROM mdl_context WHERE contextlevel = '50' AND instanceid = '1' 2023-02-09T01:18:40.205816Z 96 Query SELECT cc.id,cc.name,cc.idnumber,cc.parent,cc.sortorder,cc.coursecount,cc.visible,cc.depth,cc.path, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_course_categories cc JOIN mdl_context ctx ON cc.id = ctx.instanceid AND ctx.contextlevel = '40' WHERE cc.id = '1' ORDER BY cc.sortorder 2023-02-09T01:18:40.211962Z 96 Query SELECT * FROM mdl_context WHERE contextlevel = '30' AND instanceid = '2' 2023-02-09T01:18:40.212407Z 96 Query SELECT id,name,value FROM mdl_course_format_options WHERE courseid = '1' AND format = 'site' AND sectionid = '0' 2023-02-09T01:18:40.212773Z 96 Query SELECT ctx.* FROM mdl_context ctx WHERE ctx.path LIKE '/1/2/%' 2023-02-09T01:18:40.213294Z 96 Query SELECT c.* , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_course c JOIN ( SELECT DISTINCT e.courseid FROM mdl_enrol e JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '2') WHERE ue.status = '0' AND e.status = '0' AND ue.timestart <= '1675905520' AND (ue.timeend = 0 OR ue.timeend > '1675905520')) en ON (en.courseid = c.id) LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50') WHERE c.id <> 1 ORDER BY c.visible DESC,c.sortorder ASC 2023-02-09T01:18:40.216395Z 96 Query SELECT c.id,c.category,c.sortorder,c.shortname,c.fullname,c.idnumber,c.startdate,c.visible,c.defaultgroupingid,c.groupmode,c.groupmodeforce , ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM mdl_course c JOIN (SELECT DISTINCT e.courseid FROM mdl_enrol e JOIN mdl_user_enrolments ue ON (ue.enrolid = e.id AND ue.userid = '2') WHERE ue.status = '0' AND e.status = '0' AND ue.timestart < 1675905500 AND (ue.timeend = 0 OR ue.timeend > 1675905500) ) en ON (en.courseid = c.id) LEFT JOIN mdl_context ctx ON (ctx.instanceid = c.id AND ctx.contextlevel = '50') WHERE c.id <> 1 ORDER BY c.visible DESC,c.sortorder ASC 2023-02-09T01:18:40.230138Z 96 Query SELECT r.id, r.name, r.shortname, rn.name AS coursealias FROM mdl_role r JOIN mdl_role_context_levels rcl ON (rcl.contextlevel = '30' AND r.id = rcl.roleid) LEFT JOIN mdl_role_names rn ON (rn.contextid = '0' AND rn.roleid = r.id) ORDER BY r.sortorder ASC 2023-02-09T01:18:40.230727Z 96 Query SELECT * FROM mdl_repository ORDER BY sortorder 2023-02-09T01:18:40.236334Z 96 Query SELECT r.id, r.name, r.shortname, rn.name AS coursealias FROM (SELECT DISTINCT rc.roleid FROM mdl_role_capabilities rc ) idlist JOIN mdl_role r ON r.id = idlist.roleid LEFT JOIN mdl_role_names rn ON (rn.contextid = '2' AND rn.roleid = r.id) ORDER BY r.sortorder 2023-02-09T01:18:40.245891Z 96 Query SELECT count(id) FROM mdl_notifications WHERE id IN (SELECT notificationid FROM mdl_message_popup_notifications) AND useridto = '2' AND timeread is NULL 2023-02-09T01:18:40.250937Z 96 Query SELECT COUNT(DISTINCT(m.conversationid)) FROM mdl_messages m INNER JOIN mdl_message_conversations mc ON m.conversationid = mc.id INNER JOIN mdl_message_conversation_members mcm ON mc.id = mcm.conversationid LEFT JOIN mdl_message_user_actions mua ON (mua.messageid = m.id AND mua.userid = '2' AND mua.action = '1') WHERE mcm.userid = '2' AND mc.enabled = '1' AND mcm.userid != m.useridfrom AND mua.id is NULL 2023-02-09T01:18:40.253673Z 96 Query SELECT COUNT(mcr.id) FROM mdl_message_contact_requests mcr LEFT JOIN mdl_message_users_blocked mub ON mub.userid = mcr.requesteduserid AND mub.blockeduserid = mcr.userid WHERE mcr.requesteduserid = '2' AND mub.id IS NULL 2023-02-09T01:18:40.262578Z 96 Query SELECT COUNT(mcr.id) FROM mdl_message_contact_requests mcr LEFT JOIN mdl_message_users_blocked mub ON mub.userid = mcr.requesteduserid AND mub.blockeduserid = mcr.userid WHERE mcr.requesteduserid = '2' AND mub.id IS NULL 2023-02-09T01:18:40.262896Z 96 Query SELECT COUNT(id) FROM mdl_message_contacts WHERE userid = '2' OR contactid = '2' 2023-02-09T01:18:40.287066Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.290121Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.290628Z 96 Query SELECT uif.*, uic.name AS categoryname FROM mdl_user_info_field uif LEFT JOIN mdl_user_info_category uic ON uif.categoryid = uic.id ORDER BY uic.sortorder ASC, uif.sortorder ASC 2023-02-09T01:18:40.301396Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.301973Z 96 Query SELECT * FROM mdl_reportbuilder_column WHERE reportid = '2' ORDER BY columnorder ASC 2023-02-09T01:18:40.302644Z 96 Query SELECT * FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '1' ORDER BY filterorder ASC 2023-02-09T01:18:40.307713Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.308213Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.317713Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.318681Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.319511Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.324038Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.337548Z 96 Query SELECT * FROM mdl_reportbuilder_filter WHERE reportid = '2' AND iscondition = '0' ORDER BY filterorder ASC 2023-02-09T01:18:40.338984Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.343557Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.346882Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.348664Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.352471Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.359303Z 96 Query SELECT COUNT(1) FROM (SELECT u.firstname AS c0_firstname, u.lastname AS c0_lastname, u.username AS c1_username, u.email AS c2_email FROM mdl_user u WHERE u.id != '1' AND u.deleted = 0 AND (u.suspended = '0') ) rbalias0 2023-02-09T01:18:40.359694Z 96 Query SELECT u.firstname AS c0_firstname, u.lastname AS c0_lastname, u.username AS c1_username, u.email AS c2_email FROM mdl_user u WHERE u.id != '1' AND u.deleted = 0 AND (u.suspended = '0') ORDER BY c0_firstname ASC, c0_lastname ASC LIMIT 0, 30 2023-02-09T01:18:40.360332Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.360834Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.371176Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.371545Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.377606Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.378049Z 96 Query SELECT * FROM mdl_reportbuilder_report WHERE id = '2' 2023-02-09T01:18:40.393494Z 96 Quit 2023-02-09T01:18:40.412990Z 97 Connect root@localhost on moodle using Socket 2023-02-09T01:18:40.413131Z 97 Query SET NAMES utf8mb4 2023-02-09T01:18:40.413224Z 97 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:40.414035Z 97 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:40.414784Z 97 Query SELECT * FROM mdl_external_functions WHERE name = 'core_output_load_template_with_dependencies' 2023-02-09T01:18:40.415416Z 97 Query SELECT f.filter, fc.name, fc.value FROM mdl_filter_active f LEFT JOIN mdl_filter_config fc ON fc.filter = f.filter AND fc.contextid = f.contextid WHERE f.contextid = '1' AND f.active != '-9999' ORDER BY f.sortorder 2023-02-09T01:18:40.432698Z 97 Quit 2023-02-09T01:18:40.810319Z 98 Connect root@localhost on moodle using Socket 2023-02-09T01:18:40.810491Z 98 Query SET NAMES utf8mb4 2023-02-09T01:18:40.810586Z 98 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:40.811354Z 98 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:40.812036Z 98 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.812531Z 98 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.812905Z 98 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.813217Z 98 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.817744Z 98 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.818168Z 98 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.818510Z 98 Quit 2023-02-09T01:18:40.868274Z 99 Connect root@localhost on moodle using Socket 2023-02-09T01:18:40.868404Z 99 Query SET NAMES utf8mb4 2023-02-09T01:18:40.868494Z 99 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:40.869490Z 99 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:40.870249Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.870733Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.871101Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.873907Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.874286Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.874615Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.874966Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.875273Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.875574Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.875926Z 99 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.876230Z 99 Quit 2023-02-09T01:18:40.884415Z 100 Connect root@localhost on moodle using Socket 2023-02-09T01:18:40.884549Z 100 Query SET NAMES utf8mb4 2023-02-09T01:18:40.884668Z 100 Query SET SESSION sql_mode = 'STRICT_ALL_TABLES' 2023-02-09T01:18:40.885452Z 100 Query SELECT * FROM mdl_course WHERE category = '0' 2023-02-09T01:18:40.886395Z 100 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.887078Z 100 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.887408Z 100 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.889821Z 100 Query SELECT * FROM mdl_external_functions WHERE name = 'core_get_string' 2023-02-09T01:18:40.890177Z 100 Quit