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

Blog block sql error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9, 2.0
    • Component/s: Blog
    • Labels:
      None
    • Environment:
      Linux, PostgreSQL
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE, MOODLE_20_STABLE

      Description

      This is not dissimilar to the resolved MDL-8614, but this error is generated with Moodle 1.9 beta code on a PostgreSQL database (more fussy than MySQL I think):

      ERROR: column "tg.rawname" must appear in the GROUP BY clause or be used in an aggregate function

      SELECT tg.rawname, tg.id, tg.name, COUNT(ti.id) AS count, tg.flag FROM hlearn_tag_instance ti INNER JOIN hlearn_tag tg ON tg.id = ti.tagid GROUP BY tagid ORDER BY count DESC

      • line 779 of lib/dmllib.php: call to debugging()
      • line 1020 of lib/dmllib.php: call to get_recordset_sql()
      • line 1125 of tag/lib.php: call to get_records_sql() ....

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                nfreear Nick Freear
                Reporter:
                jb23347 John Beedell
                Tester:
                Nobody
                Participants:
                Component watchers:
                Adrian Greeve, Mihail Geshoski, Peter Dias
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  3/Mar/08