Issue 221: Attendance still not perfect
Status:  Invalid
Owner: ----
Closed:  Dec 2011
Project Member Reported by dmbs...@gmail.com, Oct 19, 2011
Traceback (most recent call last):

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/core/handlers/base.py", line 111, in get_response
   response = callback(request, *callback_args, **callback_kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/contrib/admin/options.py", line 307, in wrapper
   return self.admin_site.admin_view(view)(*args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/utils/decorators.py", line 93, in _wrapped_view
   response = view_func(request, *args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/views/decorators/cache.py", line 79, in _wrapped_view_func
   response = view_func(request, *args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/contrib/admin/sites.py", line 197, in inner
   return view(request, *args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/utils/decorators.py", line 28, in _wrapper
   return bound_func(*args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/utils/decorators.py", line 93, in _wrapped_view
   response = view_func(request, *args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/utils/decorators.py", line 24, in bound_func
   return func(self, *args2, **kwargs2)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/contrib/admin/options.py", line 1116, in changelist_view
   self.save_model(request, obj, form, change=True)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/contrib/admin/options.py", line 665, in save_model
   obj.save()

 File "/opt/sword/ecwsp/sis/models.py", line 717, in save
   super(StudentAttendance, self).save(*args, **kwargs)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/base.py", line 460, in save
   self.save_base(using=using, force_insert=force_insert, force_update=force_update)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/base.py", line 526, in save_base
   rows = manager.using(using).filter(pk=pk_val)._update(values)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/query.py", line 491, in _update
   return query.get_compiler(self.db).execute_sql(None)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/sql/compiler.py", line 869, in execute_sql
   cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/models/sql/compiler.py", line 735, in execute_sql
   cursor.execute(sql, params)

 File "/usr/local/lib/python2.6/dist-packages/Django-1.3.1-py2.6.egg/django/db/backends/mysql/base.py", line 86, in execute
   return self.cursor.execute(query, args)

 File "/usr/lib/pymodules/python2.6/MySQLdb/cursors.py", line 166, in execute
   self.errorhandler(self, exc, value)

 File "/usr/lib/pymodules/python2.6/MySQLdb/connections.py", line 35, in defaulterrorhandler
   raise errorclass, errorvalue

IntegrityError: (1062, "Duplicate entry '77-2011-10-17-8' for key 'student_id'")
Dec 27, 2011
Project Member #1 dmbs...@gmail.com
Can't reproduce. I tried:
Enter attendance after teacher pulls up take attendance
 - Both same and different
Enter attendance before teacher pulls up take attendance.

I see no other way. Haven't seen these error in a long time either.
Status: Invalid