mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

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

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

** Affects: mahara/17.04
     Importance: High
         Status: Confirmed

** Affects: mahara/17.10
     Importance: High
         Status: Confirmed

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

** Affects: mahara/18.10
     Importance: High
         Status: 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