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

Feedback analsysis causes ORA-00932: inconsistent datatypes: expected - got CLOB

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 2.1.4
    • Fix Version/s: None
    • Component/s: Feedback
    • Labels:
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      Description:
      The feedback analysis tab appears to be showing errors. This will probably only affect those courses that have already had feedback submitted.

      More information about this error
       
      Debug info: ORA-00932: inconsistent datatypes: expected - got CLOB
      SELECT * FROM m_feedback_value WHERE item = :o_param1 AND value != '' 
      [array (
      'o_param1' => '104',
      )]
      Stack trace:
      line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 268 of /lib/dml/oci_native_moodle_database.php: call to moodle_database->query_end()
      line 1093 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      line 1122 of /lib/dml/moodle_database.php: call to oci_native_moodle_database->get_records_sql()
      line 2159 of /mod/feedback/lib.php: call to moodle_database->get_records_select()
      line 116 of /mod/feedback/item/multichoice/lib.php: call to feedback_get_group_values()
      line 208 of /mod/feedback/item/multichoice/lib.php: call to feedback_item_multichoice->get_analysed()
      line 140 of /mod/feedback/analysis.php: call to feedback_item_multichoice->print_analysed()

      I have fixed this error by replacing a line in the library file with an Oracle-specific SQL statement

      file: /moodle/mod/feedback/lib.php, line 2150

      $ignore_empty_select = "AND value != ''";

      replaced with the following line:

      $ignore_empty_select = "AND value is not null";

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: