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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Critical Critical
    • 2.2.5
    • 2.2.4
    • 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

      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.

            skodak Petr Skoda
            odyx Didier Raboud
            Dan Poltawski Dan Poltawski
            Dan Poltawski Dan Poltawski
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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