-
Bug
-
Resolution: Not a bug
-
Critical
-
None
-
2.1.1
-
Openldap, mysql
-
MySQL
-
MOODLE_21_STABLE
Hi
I migrated from 1.9.4 moodle to 2.1.1+ and using Openldap to import users appears this error. It's more similar to other issue (number 24666) but it's closed.
When I syncronize appears:
Database transaction aborted automatically in /usr/share/moodle/auth/ldap/cli/sync_users.php
Default exception handler: Error writing to database Debug: Duplicate entry '3-joan@admi.escola.es' for key 'user_mneuse_uix'
INSERT INTO user (firstname,lastname,email,idnumber,username,confirmed,auth,mnethostid,lang) VALUES(?,?,?,?,?,?,?,?,?)
[array (
0 => 'Joan',
1 => 'Escola',
2 => 'joan@admi.escola.es',
3 => '00265',
4 => 'joan@admi.escola.es',
5 => 1,
6 => 'ldap',
7 => '3',
8 => 'en',
)]
- line 397 of /lib/dml/moodle_database.php: dml_write_exception thrown
- line 878 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 920 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->insert_record_raw()
- line 853 of /auth/ldap/auth.php: call to mysqli_native_moodle_database->insert_record()
- line 65 of /auth/ldap/cli/sync_users.php: call to auth_plugin_ldap->sync_users()
!!! Error writing to database !!!
Potential coding error - existing temptables found when disposing database. Must be dropped!
Could be relation with:
http://tracker.moodle.org/browse/MDL-24666
My platform is debian squeeze with mysql 5.1.49 and php 5.3.3
I used this guide but not appears values