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

Non-oracle friendly query in availability backup

    XMLWordPrintable

Details

    Description

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

      Attachments

        Issue Links

          Activity

            People

              poltawski Dan Poltawski
              poltawski Dan Poltawski
              Petr Skoda Petr Skoda
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Sam Marshall, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona), Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                12/May/14