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

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

          Attachments

            Activity

            Hide
            lazyfish Yu Zhang added a comment -

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

            Show
            lazyfish Yu Zhang added a comment - Hi Shane, I see different code in 1.7, maybe backport the changes to 1.6?
            Hide
            paca@sci.fi 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
            paca@sci.fi 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
            stronk7 Eloy Lafuente (stronk7) added a comment -

            Seems correct. Thanks Petri!

            Marking as resolved now.

            Show
            stronk7 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:
                  Fix Release Date:
                  11/Jan/08