mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

This relates to the problem reported in
https://mahara.org/interaction/forum/topic.php?id=8343&offset=0&limit=10#post33323

** Changed in: mahara
    Milestone: None => 18.10.0

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

** Changed in: mahara
       Status: New => Confirmed

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

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

** Also affects: mahara/18.10
   Importance: High
       Status: Confirmed

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

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

** Changed in: mahara/17.10
    Milestone: None => 17.10.7

** Changed in: mahara/17.04
    Milestone: None => 17.04.10

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

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

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

** Changed in: mahara/18.04
       Status: New => Confirmed

** Changed in: mahara/17.10
       Status: New => Confirmed

** Changed in: mahara/17.04
       Status: New => Confirmed

** Changed in: mahara/18.10
       Status: Confirmed => In Progress

-- 
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:
  In Progress
Status in Mahara 17.04 series:
  Confirmed
Status in Mahara 17.10 series:
  Confirmed
Status in Mahara 18.04 series:
  Confirmed
Status in Mahara 18.10 series:
  In Progress

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