Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-34840

The fix for MDL-30515 broke the upgrade for PostgreSQL 8.3.17

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.2.4
    • Fix Version/s: 2.2.5
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Testing Instructions:
      Hide

      1/ install 1.9 on postgresql 8.3.x
      2/ upgrade to 2.2.x
      3/ no problem expected

      Show
      1/ install 1.9 on postgresql 8.3.x 2/ upgrade to 2.2.x 3/ no problem expected
    • Affected Branches:
      MOODLE_22_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE
    • Pull from Repository:

      Description

      Hi,

      While testing an upgrade from 1.9.19+20120712 to 2.2.*, I noticed that upgrading to 2.2.4+20120802 worked while upgrading from 2.2.4+20120809 failed with the following error:

      > Default exception handler: Error reading from database Debug: ERROR: syntax error at or near "count"
      > LINE 1: ...newestid, contextid, lowerboundary, letter, COUNT('x') count
      > ^
      > SELECT MAX(id) as newestid, contextid, lowerboundary, letter, COUNT('x') count
      > FROM mdl_grade_letters
      > GROUP BY contextid, lowerboundary, letter
      > HAVING COUNT('x') > 1
      > [array (
      > )]

      By git-blaming, I quickly found that this code was added to fix MDL-30515 but unfortunately, it makes the ugprade fail on its own.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              odyx Didier Raboud
              Integrator:
              Dan Poltawski
              Tester:
              Dan Poltawski
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Sep/12