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

backuplib uses an Oracle reserved word as a table alias

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 1.9.4
    • 1.9.3
    • Backup
    • None
    • Oracle
    • MOODLE_19_STABLE
    • MOODLE_19_STABLE

      'uid' is a reserved word on Oracle (see http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_keywd.htm)

      Here is the problematic query in backuplib:

      SELECT uif.shortname, uif.datatype, uid.data
      FROM {$CFG->prefix}user_info_field uif,
      {$CFG->prefix}user_info_data uid
      WHERE uif.id = uid.fieldid
      AND uid.userid = $user->id

      A simple solution is to simply rename the uid alias to uidata. The attached patch does this.

        1. backuplib_oracle_reserved_word.patch
          1 kB

            francois Francois Marier (Inactive)
            francois Francois Marier (Inactive)
            Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.