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

Oracle error in unit tests

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.8
    • Fix Version/s: None
    • Component/s: Unit tests
    • Labels:
    • Affected Branches:
      MOODLE_28_STABLE

      Description

      Oracle is getting this error running unit tests. The datagenerator for grade items is new and is probably the cause.

      1) core_grade_scale_testcase::test_grade_scale
      dml_read_exception: Error reading from database (ORA-00932: inconsistent datatypes: expected - got CLOB
      SELECT * FROM xngrade_items WHERE courseid = :o_param1 AND categoryid = :o_param2 AND itemname = :o_param3 AND itemtype = :o_param4 AND itemnumber = :o_param5 AND needsupdate = :o_param6 AND gradetype = :o_param7 AND scaleid = :o_param8 AND iteminfo = :o_param9 AND timecreated = :o_paran0 AND timemodified = :o_paran1
      [array (
      'o_param1' => '450000',
      'o_param2' => 391001,
      'o_param3' => 'manual grade_item scale_1',
      'o_param4' => 'manual',
      'o_param5' => 0,
      'o_param6' => 0,
      'o_param7' => 2,
      'o_param8' => '262006',
      'o_param9' => 'Manual grade item used for unit testing',
      'o_paran0' => 1412167943,
      'o_paran1' => 1412167943,
      )])

      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/dml/moodle_database.php:443
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/dml/oci_native_moodle_database.php:271
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/dml/oci_native_moodle_database.php:1092
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/dml/moodle_database.php:1199
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/grade/grade_object.php:207
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/grade/grade_object.php:160
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/grade/grade_item.php:326
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/grade/grade_object.php:90
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/grade/tests/grade_scale_test.php:164
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/grade/tests/grade_scale_test.php:39
      /home/damyonw/Documents/Moodle/instances/im_oracle/moodle/lib/phpunit/classes/advanced_testcase.php:80

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              damyon Damyon Wiese
              Participants:
              Component watchers:
              Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: