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

Tags Postgress Group by error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9.1
    • Component/s: Tags
    • Labels:
      None
    • Database:
      PostgreSQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

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

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

      • line 686 of lib/dmllib.php: call to debugging()
      • line 944 of lib/dmllib.php: call to get_recordset_sql()
      • line 27 of tag/locallib.php: call to get_records_sql()
      • line 64 of blocks/tags/block_tags.php: call to tag_print_cloud()
      • line 240 of blocks/moodleblock.class.php: call to block_tags->get_content()
      • line 264 of blocks/moodleblock.class.php: call to block_base->is_empty()
      • line 338 of lib/blocklib.php: call to block_base->_print_block()
      • line 83 of admin/stickyblocks.php: call to blocks_print_group()

      Warning: Invalid argument supplied for foreach() in /var/www/html/jb23347/core19-moodle/tag/locallib.php on line 35

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                scyrma Mathieu Petit-Clair
                Reporter:
                jb23347 John Beedell
                Tester:
                Eloy Lafuente (stronk7)
                Participants:
                Component watchers:
                Amaia Anabitarte, Bas Brands, Carlos Escobedo, Sara Arjona (@sarjona), Víctor Déniz Falcón
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  15/May/08