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

Error upgrading (oauth2_issuer) - ORA-00932 inconsistent datatypes

    XMLWordPrintable

    Details

    • Database:
      Oracle
    • Testing Instructions:
      Hide

      Test on Oracle and one other database (e.g. MySQL or PostgreSQL)

      1. Check out the Moodle 3.5.2 tag
        • git checkout v3.5.2
      2. Install your Moodle instance.
      3. Log in as an admin and go to Site administration / Services / OAuth2 services
      4. Create a new Facebook service. (It doesn't matter what the Client ID and Secret are, you can put anything).
      5. Check out the latest version with this patch applied.
        • master: git checkout master
        • 36: git checkout MOODLE_36_STABLE
        • 35: git checkout MOODLE_35_STABLE
      6. Upgrade your Moodle site
      7. Confirm that the upgrade succeeds.
      8. Go back to the OAuth2 services page.
      9. Confirm that the Facebook logo is shown beside the OAuth2 issuer name.
      Show
      Test on Oracle and one other database (e.g. MySQL or PostgreSQL) Check out the Moodle 3.5.2 tag git checkout v3.5.2 Install your Moodle instance. Log in as an admin and go to Site administration / Services / OAuth2 services Create a new Facebook service. (It doesn't matter what the Client ID and Secret are, you can put anything). Check out the latest version with this patch applied. master: git checkout master 36: git checkout MOODLE_36_STABLE 35: git checkout MOODLE_35_STABLE Upgrade your Moodle site Confirm that the upgrade succeeds. Go back to the OAuth2 services page. Confirm that the Facebook logo is shown beside the OAuth2 issuer name.
    • Affected Branches:
      MOODLE_35_STABLE
    • Fixed Branches:
      MOODLE_35_STABLE, MOODLE_36_STABLE
    • Pull from Repository:
    • Pull 3.5 Branch:
    • Pull 3.6 Branch:
    • Pull Master Branch:
      MDL-64345-master

      Description

      I tried to upgrade Moodle to version 3.5.3 (using ORACLE).

      I got this error: 

      ORA-00932: inconsistent datatypes: expected - got CLOB

      The problem is caused by this query, because image field is a CLOB: 

      $updatesql = "UPDATE {oauth2_issuer}
       SET image = :newimage
       WHERE image = :oldimage";

      in file: lib/db/upgrade.php line: 2322

        Attachments

          Activity

            People

            • Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Fix Release Date:
                14/Jan/19

                Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 7 hours
                7h