Moodle 2 Ldap error writing to database...!

[wesleyw]

I've recently setup a development server for Moodle 2 I have configured the settings for LDAP to work (same as my Moodle 1.9 version) "I" try logging in and get an error stating error writing to database however if I log in as a test pupil this doesn't occur? I've created several Moodle 2 servers (all exhibiting this behaviour) so I thought it must be my fault and downloaded an ISO of TurnKey Moodle Appliance and tried this same error? I'll post up the debug error message in a minute.

Any thoughts?




Wes

[wesleyw]

Debug info:
Stack trace:

* line 394 of /lib/dml/moodle_database.php: dml_write_exception thrown
* line 843 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
* line 885 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
* line 3468 of /lib/moodlelib.php: call to mysqli_native_moodle_database->insert_record()
* line 3749 of /lib/moodlelib.php: call to create_user_record()
* line 133 of /login/index.php: call to authenticate_user_login()



interestingly if I try and login as myself or a staff member and deliberately enter the wrong password it just states invalid login as it should?


Wes

[wesleyw]

Think I may have tracked the offending thing down now I had set the ID Number to a special AD field setup by our MIS system if I remove this the issue goes away? I think postgre maybe needed here as it seems to be an issue caused by MySQL and the UTF8_collation?



Wes

[wesleyw]

Sadly even Postgresql didn't fix it but if I put the entity field in description not ID Number then it works obviously a problem with the ID number field between versions 1.9 and 2.1.2.


Solved!

Wes