Moodle
  1. Moodle
  2. MDL-27084

postgresql syntax error in mod/feedback

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.2
    • Fix Version/s: 2.0.3
    • Component/s: Feedback
    • Labels:
      None
    • Environment:
      postgresql database
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE
    • Rank:
      17137

      Description

      Under certain conditions a query is performed using "AND 1" which postgresql rejects as a syntax error.
      This causes an 'error reading from database' in Moodle.

      Patch exists, please see soon to arrive comment for github link.

        Activity

        Show
        Tony Levi added a comment - https://github.com/tlevi/moodle/tree/mdl27084
        Hide
        Andreas Grabs added a comment -

        Thank you Tony!
        I did a pull request and hope all goes right.

        Show
        Andreas Grabs added a comment - Thank you Tony! I did a pull request and hope all goes right.

          People

          • Votes:
            1 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: