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

Error in enrolment web service unit test with Oracle

    XMLWordPrintable

    Details

      Description

      The following failure is reported when running unit tests with Oracle (only). I found this error in the current master and 2.4.3+. I assume it has not been introduced by recent changes.

      1) core_enrol_external_testcase::test_get_users_courses
      dml_read_exception: Error reading from database (ORA-00933: SQL command not prop
      erly ended
      SELECT COUNT(*) FROM (SELECT DISTINCT eu2_u.id
                    FROM p_user eu2_u
                  JOIN p_user_enrolments eu2_ue ON eu2_ue.userid = eu2_u.id
      JOIN p_enrol eu2_e ON (eu2_e.id = eu2_ue.enrolid AND eu2_e.courseid = :o_eu2_cou
      rseid)
                 WHERE eu2_u.deleted = 0 AND eu2_u.id <> :o_eu2_guestid) AS enrolledus
      erids
      [array (
        'o_eu2_courseid' => '3',
        'o_eu2_guestid' => '1',
      )])
       
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:426
      D:\xampp\htdocs\master_integration\lib\dml\oci_native_moodle_database.php:272
      D:\xampp\htdocs\master_integration\lib\dml\oci_native_moodle_database.php:1114
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:1401
      D:\xampp\htdocs\master_integration\lib\dml\oci_native_moodle_database.php:1048
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:1474
      D:\xampp\htdocs\master_integration\lib\dml\moodle_database.php:1645
      D:\xampp\htdocs\master_integration\enrol\externallib.php:320
      D:\xampp\htdocs\master_integration\enrol\tests\externallib_test.php:113
      D:\xampp\htdocs\master_integration\lib\phpunit\classes\advanced_testcase.php:76
       
      To re-run:
       \xampp\php\phpunit core_enrol_external_testcase enrol\tests\externallib_test.php
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              salvetore Michael de Raadt
              Integrator:
              Eloy Lafuente (stronk7)
              Tester:
              Michael de Raadt
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Juan Leyva, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                13/May/13