mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

** Changed in: mahara/18.04
       Status: Fix Committed => Fix Released

-- 
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 Released
Status in Mahara 17.04 series:
  Fix Committed
Status in Mahara 17.10 series:
  Fix Committed
Status in Mahara 18.04 series:
  Fix Released
Status in Mahara 18.10 series:
  Fix Released

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