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
    • Rank:
      29122

      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

        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: