Adding a quiz to a skill that already has multiple passed attempts results in the error page

NationalSecurityAgency / skills-service

SkillTree is a micro-learning gamification platform supporting the rapid integration of a gamified tool training approach into new and existing applications.

https://skilltreeplatform.dev

Apache License 2.0

413 stars 96 forks source link

Adding a quiz to a skill that already has multiple passed attempts results in the error page #2968

Closed rmmayo closed 14 hours ago

rmmayo commented 2 days ago

Create a new quiz
create single choice question
enable "Allow Retakes After Completion"
take and pass the test more than once
assign the skill to a skill and the error page is displayed

this appears to cause a unique contraint violation:

ERROR: duplicate key value violates unique constraint "user_events_unique_row"
  Detail: Key (user_id, project_id, skill_ref_id, event_time, event_type)=(000000000003, movies, 487, 2024-11-12 00:00:00, DAILY) already exists.

rmmayo commented 14 hours ago

:+1: