jlb224 / moodle-mod_notetaker

Notetaker plugin for Moodle - allows students to take public or private notes within a course.
https://jlb224.github.io/moodle-mod_notetaker/
Other
2 stars 4 forks source link

Privacy provider SQL query error #18

Open matthewhilton opened 1 year ago

matthewhilton commented 1 year ago

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