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

PostgreSQL error in survey + recent activity block

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.9.1
    • 1.9
    • Survey
    • None
    • MOODLE_19_STABLE / PostgreSQL 8.1
    • PostgreSQL
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

      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()

            mudrd8mz David Mudrák (@mudrd8mz)
            mudrd8mz David Mudrák (@mudrd8mz)
            Petr Skoda Petr Skoda
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.