• Icon: Sub-task Sub-task
    • Resolution: Fixed
    • Icon: Major Major
    • 1.9
    • 1.9
    • Other
    • None
    • Any
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

      I'm getting some SQL erros. The main cause seems to be that some queries use double-quotes to enclose literals.

      For example:

      ERROR: column "site" does not exist<br /><br />SELECT id,courseid,userid,content,format,created,lastmodified,usermodified,publishstate FROM mdl_post WHERE userid=2 AND publishstate="site" AND module="notes" ORDER BY lastmodified DESC

      in the note_list() function.

      It would be interesting to fix this and to perform a quick review to detect-and-kill such quoting.

      Ciao

            skodak Petr Skoda
            stronk7 Eloy Lafuente (stronk7)
            Nobody Nobody (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.