Privacy provider SQL query error
Opened this issue · 0 comments
matthewhilton commented
In Moodle 4.1:
4) tool_dataprivacy\expired_contexts_test::test_process_course_context_with_user_in_both_lists_expired
Unexpected debugging() call detected.
Debugging: Error reading from database (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'notetaker_notes) nn
JOIN phpu3_notetaker nt ON nn.notetakerid
' at line 4
SELECT DISTINCT u.id
FROM phpu3_user u
JOIN (SELECT nn.userid
FROM {notetaker_notes) nn
JOIN phpu3_notetaker nt ON nn.notetakerid
JOIN phpu3_course_modules cm ON cm.instance = nt.id AND cm.module = ?
JOIN phpu3_context ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = ?
WHERE ctx.id = ?) target ON u.id = target.userid
[array (
0 => '23',
1 => 70,
2 => 162001,
)])
This looks like there is a )
instead of a }
causing the query error