mahara-contributors team mailing list archive

[Mahara Bot <1792638@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/9147
Committed: https://git.mahara.org/mahara/mahara/commit/00475c2a03d2a877f30fbc7df866dc7b390cda3a
Submitter: Robert Lyon (robertl@xxxxxxxxxxxxxxx)
Branch:    17.04_STABLE

commit 00475c2a03d2a877f30fbc7df866dc7b390cda3a
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
Date:   Sat Sep 15 08:47:22 2018 +1200

Bug 1792638: Problem with ldap sync temp table

And also with calling $USER->logout();

And also with showing missing ldap server info for a user

behatnotneeded

Change-Id: I03656d286bbf2e56416151a52b2051235f9364df
Signed-off-by: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
(cherry picked from commit 254103d61b9165c295ca9bfdab2f339d9a8d16cc)
(cherry picked from commit f2da0c00ad33b2b4e7bb8736ff9bb2570a9e0872)

-- 
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/1792638

Title:
  Problems with ldap user sync database error

Status in Mahara:
  Fix Committed
Status in Mahara 17.04 series:
  Fix Committed
Status in Mahara 17.10 series:
  Fix Committed
Status in Mahara 18.04 series:
  Fix Committed
Status in Mahara 18.10 series:
  Fix Committed

Bug description:
  When trying to use the LDAP user_sync() function there is this error

  [DBG] a0 (lib/dml.php:157) mysqli error: [1171: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead] in EXECUTE("CREATE TEMPORARY TABLE auth_ldap_extusers_temp (
  [DBG] a0 (lib/dml.php:157) extusername VARCHAR(64) DEFAULT NULL,
  [DBG] a0 (lib/dml.php:157) firstname TEXT,
  [DBG] a0 (lib/dml.php:157) lastname TEXT,
  [DBG] a0 (lib/dml.php:157) email VARCHAR(255) DEFAULT NULL,
  [DBG] a0 (lib/dml.php:157) studentid TEXT,
  [DBG] a0 (lib/dml.php:157) preferredname TEXT,
  [DBG] a0 (lib/dml.php:157) CONSTRAINT PRIMARY KEY (extusername)
  [DBG] a0 (lib/dml.php:157) )ENGINE=innodb")

  It looks like we need to make the 'extusername' column a not null
  column

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