Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-4043

Incompatible postgres sql crash the hub search

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • None
    • 2.4
    • Local: Hub
    • None

      Install the hub on postgres. Publish a course to the hub. In the hub admin, search for any course. It breaks:

      Debug info: ERROR: column "site.id" must appear in the GROUP BY clause or be used in an aggregate function
      LINE 1: SELECT site.* FROM mdl_hub_course_directory course, mdl_hub_...
      ^
      SELECT site.* FROM mdl_hub_course_directory course, mdl_hub_site_directory site WHERE course.id IN (1) AND site.id = course.siteid GROUP BY siteid
      [array (
      )]
      Error code: dmlreadexception

            jerome Jérôme Mouneyrac
            jerome Jérôme Mouneyrac
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

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