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

Sorting elements by custom number leads to a mysql error in the relation table.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.0.6, 3.1.2
    • 3.1.1
    • Module: Survey Pro
    • None
    • MOODLE_31_STABLE
    • MOODLE_30_STABLE, MOODLE_31_STABLE

      Debug info: Unknown column 'customnumber' in 'order clause'

      SELECT id as itemid, plugin, type FROM head_surveypro_item WHERE surveyproid = ? ORDER BY customnumber ASC, sortindex DESC
      [array (
      0 => '152',
      )]

      Error code: dmlreadexception
      Stack trace:

      line 474 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 1027 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1250 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_recordset_sql()
      line 1198 of /lib/dml/moodle_database.php: call to moodle_database->get_recordset_select()
      line 705 of /mod/surveypro/classes/itemlist.php: call to moodle_database->get_recordset()
      line 101 of /mod/surveypro/layout_validation.php: call to mod_surveypro_itemlist->display_relations_table()

            daniss Daniele Cordella
            daniss Daniele Cordella
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

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