Moodle
  1. Moodle
  2. MDL-8614

Blog - keywords: - when switched on, error message appears

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6.4
    • Fix Version/s: 1.6.6
    • Component/s: Blog
    • Labels:
      None
    • Environment:
      Linux, Apache, PostgreSQL8.1

      Description

      Blog - keywords
      1.6.4.+, PostgreSQL8.1

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

      SELECT t.*, COUNT(DISTINCT bt.id) as ct FROM mdl_tags as t, mdl_blog_tag_instance as bt, mdl_post as p WHERE t.id = bt.tagid AND p.id = bt.entryid AND (p.publishstate = 'site' or p.publishstate='public') AND bt.timemodified > 7776000 GROUP BY bt.tagid ORDER BY ct DESC, t.text ASC LIMIT 20

        Gliffy Diagrams

          Activity

          Hide
          Yu Zhang added a comment -

          Hi Shane, I see different code in 1.7, maybe backport the changes to 1.6?

          Show
          Yu Zhang added a comment - Hi Shane, I see different code in 1.7, maybe backport the changes to 1.6?
          Hide
          Petri Asikainen added a comment -

          I merged code from MOODLE_17_STABLE to MOODLE_16_STABLE and commited fix to CVS.
          So this bug can be closed.

          Show
          Petri Asikainen added a comment - I merged code from MOODLE_17_STABLE to MOODLE_16_STABLE and commited fix to CVS. So this bug can be closed.
          Hide
          Eloy Lafuente (stronk7) added a comment -

          Seems correct. Thanks Petri!

          Marking as resolved now.

          Show
          Eloy Lafuente (stronk7) added a comment - Seems correct. Thanks Petri! Marking as resolved now.

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: