Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-9034

Custom Certificate Plugin: If you have a custom user profile field selected in Show User Identity viewing cert report throws the following error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 4.0.2
    • None
    • MOODLE_400_STABLE

      Debug info: Unknown column 'uf1d_1.data' in 'field list'
      SELECT u.id, u.picture, u.firstname, u.lastname, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.imagealt, u.email, u.username, uf1d_1.data AS profile_field_attendancedate, ci.id as issueid, ci.code, ci.timecreated
      FROM mdl_user u
      INNER JOIN mdl_customcert_issues ci
      ON u.id = ci.userid
      WHERE u.deleted = 0
      AND ci.customcertid = ?
      AND NOT u.id IN (?,?)
      ORDER BY CONCAT(firstname, ' ', lastname) LIMIT 0, 50
      [array (
      0 => '52',
      1 => 4,
      2 => 2,
      )]
      Error code: dmlreadexception

            Unassigned Unassigned
            moley Lynn Daley
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:

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