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

PostgreSQL error in survey + recent activity block

    XMLWordPrintable

    Details

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

      Description

      This appears in my Recent activity block:

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

      SELECT sa.userid, sa.survey, sa.time, u.firstname, u.lastname, u.email, u.picture FROM mdl_survey_answers sa JOIN mdl_user u ON u.id = sa.userid WHERE sa.survey IN (9) AND sa.time > 1209238600 GROUP BY sa.userid, sa.survey ORDER BY sa.id ASC

      • line 686 of lib/dmllib.php: call to debugging()
      • line 162 of mod/survey/lib.php: call to get_recordset_sql()
      • line 942 of course/lib.php: call to survey_print_recent_activity()
      • line 27 of blocks/recent_activity/block_recent_activity.php: call to print_recent_activity()
      • line 317 of blocks/moodleblock.class.php: call to block_recent_activity->get_content()
      • line 341 of blocks/moodleblock.class.php: call to block_base->is_empty()
      • line 338 of lib/blocklib.php: call to block_base->_print_block()
      • line 284 of course/format/topics/format.php: call to blocks_print_group()
      • line 226 of course/view.php: call to require()

        Attachments

          Issue Links

            Activity

              People

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

                Dates

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