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

Error upgrading (oauth2_issuer) - ORA-00932 inconsistent datatypes

    XMLWordPrintable

Details

    • Oracle
    • MOODLE_35_STABLE
    • MOODLE_35_STABLE, MOODLE_36_STABLE
    • MDL-64345-master
    • 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.

    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

        1. image-2019-01-10-16-47-41-991.png
          198 kB
          Janelle Barcega
        2. image-2019-01-10-16-47-55-372.png
          284 kB
          Janelle Barcega

        Activity

          People

            sara.cenni Sara Cenni
            sara.cenni Sara Cenni
            Jun Pataleta Jun Pataleta
            Jake Dallimore Jake Dallimore
            Janelle Barcega Janelle Barcega
            David Woloszyn, Huong Nguyen, Jake Dallimore, Michael Hawkins, Stevani Andolo
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              14/Jan/19

              Time Tracking

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