Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-29358

Error writing to database Debug: Duplicate entry for key 'user_mneuse_uix'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Not a bug
    • Affects Version/s: 2.1.1
    • Fix Version/s: None
    • Component/s: Authentication, Enrolments
    • Labels:
    • Environment:
      Openldap, mysql
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      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

      http://docs.moodle.org/20/en/DuplicateUsernames

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                moodle.com moodle.com
                Reporter:
                deconya marcos
                Participants:
                Component watchers:
                Jake Dallimore, Jun Pataleta, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: