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

Oracle error on the language editing page

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1, 2.2, 2.3.2, 2.4
    • Fix Version/s: 2.2.6, 2.3.3
    • Component/s: Administration
    • Labels:
    • Environment:
      Moodle 2.0.1
      DB Oracle 11.2.0.2.0
      PHP 5.3.2
      Apache 2.0 Handler
    • Database:
      Oracle
    • Testing Instructions:
      Hide
      1. Test under Oracle + any other DB.
      2. Log in as an admin
      3. Browse to Settings > Language > Language customisations.
      4. Choose a language.
      5. Open the language pack for editing (may take some time).
      6. Select a lang file and click "Show strings"
      7. Make sure the page loads.
      Show
      Test under Oracle + any other DB. Log in as an admin Browse to Settings > Language > Language customisations. Choose a language. Open the language pack for editing (may take some time). Select a lang file and click "Show strings" Make sure the page loads.
    • Difficulty:
      Moderate
    • Affected Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE, MOODLE_24_STABLE
    • Fixed Branches:
      MOODLE_22_STABLE, MOODLE_23_STABLE
    • Pull Master Branch:
      wip-MDL-26348-m24

      Description

      Debug info: ORA-00918: column ambiguously defined
      SELECT s.id, s.*, c.name AS component FROM m_report_customlang_components c
      JOIN m_report_customlang s ON s.componentid = c.id
      WHERE s.lang = :lang
      AND c.name = :param0000 AND LOWER(s.stringid) NOT LIKE LOWER(:link) ESCAPE '\' ORDER BY c.name, s.stringid
      [array (
      'lang' => 'es',
      'param0000' => 'core',
      'link' => '%
      _link',
      'oracle_num_rows' => 100,
      )]
      Stack trace:

      • line 391 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 1042 of /lib/dml/oci_native_moodle_database.php: call to oci_native_moodle_database->query_end()
      • line 512 of /admin/report/customlang/locallib.php: call to oci_native_moodle_database->get_records_sql()
      • line 115 of /admin/report/customlang/edit.php: call to report_customlang_translator->__construct()

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    12/Nov/12