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

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 2.2.4
    • 2.2.5
    • Database SQL/XMLDB
    • None
    • MOODLE_22_STABLE
    • MOODLE_22_STABLE
    • 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

    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

              skodak Petr Skoda
              odyx Didier Raboud
              Dan Poltawski Dan Poltawski
              Dan Poltawski Dan Poltawski
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Sep/12