Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.7
-
Fix Version/s: 1.7.1
-
Component/s: Authentication, Roles / Access
-
Labels:None
-
Database:MySQL
-
Affected Branches:MOODLE_17_STABLE
-
Fixed Branches:MOODLE_17_STABLE
Description
If ldap_creators field is filled out in LDAP Authentication, LDAP users are unable to log in.
Error message:
This SQL relies on obsolete tables! Your code must be fixed by a developer.
Debug mode:
array(4) { [0]=> array(4) { ["file"]=> string(42) "/moodle/lib/dmllib.php" ["line"]=> int(280) ["function"]=> string(17) "get_recordset_sql" ["args"]=> array(3) { [0]=> &string(56) "SELECT * FROM mdl_user_coursecreators WHERE userid = '3'" [1]=> ?(0) [2]=> ?(1) } } [1]=> array(4) { ["file"]=> string(42) "/moodle/lib/dmllib.php" ["line"]=> int(244) ["function"]=> string(17) "record_exists_sql" ["args"]=> array(1) { [0]=> &string(56) "SELECT * FROM mdl_user_coursecreators WHERE userid = '3'" } } [2]=> array(4) { ["file"]=> string(45) "/moodle/lib/moodlelib.php" ["line"]=> int(2380) ["function"]=> string(13) "record_exists" ["args"]=> array(3) { [0]=> &string(19) "user_coursecreators" [1]=> &string(6) "userid" [2]=> &string(1) "3" } } [3]=> array(4) { ["file"]=> string(43) "/moodle/login/index.php" ["line"]=> int(120) ["function"]=> string(23) "authenticate_user_login" ["args"]=> array(2) { [0]=> &string(7) "username" [1]=> &string(8) "password" } } }
I suspect the problem is in /auth/ldap/lib.php, lines 553-610, but I don't know roles well enough yet to troubleshoot it.
Issue Links
| This issue will help resolve: | ||||
| MDL-6660 | Update enrol/ldap for Moodle 1.7 using new roles functions |
|
|
|
Also, this error occurs for ANY user with authentication set to LDAP, not just the users who belong to the course creators group.