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

2.5.1 Course Restore - ORA-00932: inconsistent dataypes

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 2.5, 2.5.1
    • Fix Version/s: None
    • Component/s: Backup
    • Labels:
    • Affected Branches:
      MOODLE_25_STABLE

      Description

      Recent upgrade to 2.5.1 on Oracle 11.2.0.3.0
      Restore of a blank course works... with anything in the course I receive:

      Error Reading from Database

      Debug info: ORA-00932: inconsistent datatypes: expected - got CLOB
      SELECT *
      FROM (SELECT id FROM m_event WHERE name = :o_param1 AND courseid = :o_param2 AND
      repeatid = :o_param3 AND modulename = :o_param4 AND timestart = :o_param5 AND timeduration =:o_param6
      AND dbms_lob.substr(description, 255,1) = dbms_lob.substr(:o_param7, 255,1))
      WHERE rownum <= :o_oracle_num_rows
      [array (
      'o_param1' => 'Test Thursday',
      'o_param2' => 1405,
      'o_param3' => '0',
      'o_param4' => '0',
      'o_param5' => 1352401200,
      'o_param6' => '0',
      'o_param7' => '<p>Study for the test</p>',
      'o_oracle_num_rows' => 1,
      )]
      Error code: dmlreadexception

      Name and Description are both CLOB fields, which return this error when compared with the :o_param variables (strings) with an =

      Possible fix: Change the datatype of the column?
      Possible fix 2: FROM (SELECT id FROM m_event WHERE dbms_lob.substr(name,4000,1) = dbms_lob.substr(:o_param1,4000,1)

      Trevor

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              malachai Trevor Wilson
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: