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

Duplicate key value violates unique constraint "mdl_badgback_useext_uix"

XMLWordPrintable

    • MOODLE_310_STABLE
    • MOODLE_310_STABLE
    • MDL-70059-master
    • Hide

      It's covered by PHPUnit tests but if required, the following testing instructions can be used:

      1. Login as admin.
      2. Go to "Site administration / Badges / Manage backpacks"
      3. Create a backpack with the following details:
      4. Save changes.
      5. Create another backpack with the following details:
      6. Save changes
      7. Check no error is displayed.
      Show
      It's covered by PHPUnit tests but if required, the following testing instructions can be used: Login as admin. Go to "Site administration / Badges / Manage backpacks" Create a backpack with the following details: Backpack API -  https://api.eu.badgr.io/v2 Backpack URL -  https://eu.badgr.io API Version - Open Badges v2.0 Include authentication details with the backpack - Disabled Save changes. Create another backpack with the following details: Backpack API -  https://api.ca.badgr.io/v2   Backpack URL -  https://ca.badgr.io   API Version - Open Badges v2.0 Include authentication details with the backpack - Disabled Save changes Check no error is displayed.
    • Moppies Kanban

      Steps to reproduce

      1. Login as admin.
      2. Go to "Site administration / Badges / Manage backpacks"
      3. Create a backpack with the following details:
      4. Save changes.
      5. Create another backpack with the following details:
      6. Save changes

      Expected behaviour

      Backpack is saved and no error is displayed.

       

      Current behaviour

      Backpack is saved but the following error is displayed:

      ERROR: duplicate key value violates unique constraint "mdl_badgback_useext_uix"
      		 
      DETAIL: Key (userid, externalbackpackid)=(0, 0) already exists.
      		 
      INSERT INTO mdl_badge_backpack (email,password,externalbackpackid,userid,backpackuid,autosync) VALUES($1,$2,$3,$4,$5,$6) RETURNING id
      		 
      [array (
      		 
      'email' => '',
      		 
      'password' => '',
      		 
      'externalbackpackid' => 0,
      		 
      'userid' => 0,
      		 
      'backpackuid' => 0,
      		 
      'autosync' => 0,
      		 
      )]

        1. screenshot-1.png
          screenshot-1.png
          85 kB

            sarjona Sara Arjona (@sarjona)
            sarjona Sara Arjona (@sarjona)
            Carlos Escobedo Carlos Escobedo
            Andrew Lyons Andrew Lyons
            Janelle Barcega Janelle Barcega
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 4 hours, 10 minutes
                4h 10m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.