Cannot get to competition screen after participant import. #89
Description
After a slight hiccup in pre-reg upload, can no longer get to competition show participants screen. I will restore backup and try again.
The hicckup is this, Choy being added twice, although it is for different categories in two different events.
`* Row 31: 10099823286 PR2306216 bib= 252, Finkenbine, Jennifer, North Vancouver, BC
- Row 32: 10048297896 BC090724 bib= 800, Benjamin, Blair, Langley, BC
**** Row 33: Error=duplicate key value violates unique constraint "core_participant_competition_id_category__70d4b6aa_uniq"
DETAIL: Key (competition_id, category_id, license_holder_id)=(390, 892, 8690) already exists.
Bib=819 Category=Master B License=BC42343 Name="Dickson Choy"
This LicenseHolder is already in this Category
819 Dickson, Choy, 10100690428, BC42343, Glotman Simpson Cycling`
`Environment:
Request Method: GET
Request URL: http://racedb.wimsey.online/RaceDB/Competitions/CompetitionDashboard/390/Participants/390/
Django Version: 5.1.1
Python Version: 3.10.15
Installed Applications:
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django_extensions',
'crispy_forms',
'crispy_bootstrap3',
'core')
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware']
Traceback (most recent call last):
File "/usr/local/lib/python3.10/site-packages/django/core/handlers/exception.py", line 55, in inner
response = get_response(request)
File "/usr/local/lib/python3.10/site-packages/django/core/handlers/base.py", line 197, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/RaceDB/core/views_common.py", line 108, in wrap
response = response or decorated_func( request, *args, **kwargs )
File "/RaceDB/core/WriteLog.py", line 89, in new_f
return f( *args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/django/contrib/auth/decorators.py", line 60, in _view_wrapper
return view_func(request, *args, **kwargs)
File "/RaceDB/core/participant.py", line 300, in Participants
Participant.objects.filter( category__id=category_id, license_holder__id__in=license_holders ).exclude( participant.license_checked ).update( license_checked=True )
Exception Type: NameError at /RaceDB/Competitions/CompetitionDashboard/390/Participants/390/
Exception Value: name 'participant' is not defined
`