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

Non-oracle friendly query in availability backup

XMLWordPrintable

      Can be reproduced by running the backup behat tests against oracle (although the error isn't being properly captured - MDL-45202):

      Default exception handler: Error reading from database Debug: ORA-00923: FROM keyword not found where expected
      SELECT *, availability AS availabilityjson
                        FROM ecourse_sections WHERE id = :o_param1
      [array (\n  'o_param1' => 1,\n)]
      Error code: dmlreadexception
      * line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
      * line 271 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
      * line 1092 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      * line 54 of /backup/util/dbops/backup_structure_dbops.class.php: call to oci_native_moodle_database->get_recordset_sql()
      * line 359 of /backup/util/structure/backup_nested_element.class.php: call to backup_structure_dbops::get_iterator()
      * line 77 of /backup/util/structure/backup_nested_element.class.php: call to backup_nested_element->get_iterator()
      * line 97 of /backup/util/plan/backup_structure_step.class.php: call to backup_nested_element->process()
      * line 181 of /backup/util/plan/base_task.class.php: call to backup_structure_step->execute()
      * line 108 of /backup/moodle2/backup_section_task.class.php: call to base_task->execute()
      * line 177 of /backup/util/plan/base_plan.class.php: call to backup_section_task->execute()
      * line 120 of /backup/util/plan/backup_plan.class.php: call to base_plan->execute()
      * line 320 of /backup/controller/backup_controller.class.php: call to backup_plan->execute()
      * line 111 of /backup/util/ui/backup_ui.class.php: call to backup_controller->execute_plan()
      * line 131 of /backup/backup.php: call to backup_ui->execute()
      

            poltawski Dan Poltawski
            poltawski Dan Poltawski
            Petr Skoda Petr Skoda
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            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.