← Back to team overview

mahara-contributors team mailing list archive

[Bug 1837660] [NEW] Error in Ldap user sync

 

Public bug reported:

When there is an existing matching email on the
artefact_internal_profile_email but not on the usr.email field there is
an error thrown on line 1334 of auth/ldap/lib.php

 EXECUTE("SELECT * FROM "usr" WHERE "id" = ? LIMIT 2")Command was:
SELECT * FROM "usr" WHERE "id" = ?

See
https://mahara.org/interaction/forum/topic.php?id=8483&offset=0&limit=10#post33840

This is because we only check for email and return boolean and then try
to fetch info based on an object.

Will fix

** Affects: mahara
     Importance: High
         Status: In Progress

** Affects: mahara/18.04
     Importance: High
         Status: New

** Affects: mahara/18.10
     Importance: High
         Status: New

** Affects: mahara/19.04
     Importance: High
         Status: New

** Affects: mahara/19.10
     Importance: High
         Status: In Progress

** Changed in: mahara
       Status: New => In Progress

** Changed in: mahara
   Importance: Undecided => High

** Also affects: mahara/18.04
   Importance: Undecided
       Status: New

** Also affects: mahara/19.10
   Importance: High
       Status: In Progress

** Also affects: mahara/19.04
   Importance: Undecided
       Status: New

** Also affects: mahara/18.10
   Importance: Undecided
       Status: New

** Changed in: mahara/19.04
   Importance: Undecided => High

** Changed in: mahara/18.10
   Importance: Undecided => High

** Changed in: mahara/18.04
   Importance: Undecided => High

** Changed in: mahara/19.10
    Milestone: None => 19.10.0

** Changed in: mahara/19.04
    Milestone: None => 19.04.2

** Changed in: mahara/18.10
    Milestone: None => 18.10.3

** Changed in: mahara/18.04
    Milestone: None => 18.04.6

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1837660

Title:
  Error in Ldap user sync

Status in Mahara:
  In Progress
Status in Mahara 18.04 series:
  New
Status in Mahara 18.10 series:
  New
Status in Mahara 19.04 series:
  New
Status in Mahara 19.10 series:
  In Progress

Bug description:
  When there is an existing matching email on the
  artefact_internal_profile_email but not on the usr.email field there
  is an error thrown on line 1334 of auth/ldap/lib.php

   EXECUTE("SELECT * FROM "usr" WHERE "id" = ? LIMIT 2")Command was:
  SELECT * FROM "usr" WHERE "id" = ?

  See
  https://mahara.org/interaction/forum/topic.php?id=8483&offset=0&limit=10#post33840

  This is because we only check for email and return boolean and then
  try to fetch info based on an object.

  Will fix

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1837660/+subscriptions


Follow ups