Menu ▾ ▴

#693 Duplicate primary verifications

v1.0 (example)
closed-fixed
Ahasuerus
None
5
2018-03-17
2018-03-15
Ahasuerus
No

As of 2018-03-10, we had 88 duplicate primary verifications. The SQL query was:

select pubid,count(),vertime from primaryverifications group by pubid,userid having count()>1

All but one were created prior ro 2017-04 when the verification system was last revamped. We need to merge these verifications.

2018-03-17 update: The old design had separate verification slots for "Primary1" through "Primary5" as well as "Transient". It allowed a single verifier to (inadvertently) claim multiple primary verification slots. When we converted to the new system, we ended up with the previously mentioned 88 duplicates.

Discussion

  • Ahasuerus

    Ahasuerus - 2018-03-17
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -3,3 +3,5 @@
 select pubid,count(*),vertime from  primaryverifications group by pubid,userid having count(*)>1

 All but one were created prior ro 2017-04 when the verification system was last revamped. We need to merge these verifications.
+
+2018-03-17 update: The old design had separate verification slots for "Primary1" through "Primary5" as well as "Transient". It allowed a single verifier to (inadvertently) claim multiple primary verification slots. When we converted to the new system, we ended up with the previously mentioned 88 duplicates.
     

  • Ahasuerus

    Ahasuerus - 2018-03-17
    • status: open --> closed-fixed
    • assigned_to: Ahasuerus
     

  • Ahasuerus

    Ahasuerus - 2018-03-17

    Fixed in scripts/fix_primary_verifications.py. Installe din SVN 89 on 2018-03-17. Closing.

     

Anonymous
Anonymous

Add attachments
Cancel