The SIO2 project
  1. The SIO2 project
  2. SIO-1854

IntegrityError when removing a contest after disabling gamification

    Details

    • Type: Bug Bug
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: Current Version
    • Fix Version/s: TAG 2016/17 Sprint 1
    • Component/s: OIOIOI
    • Labels:

      Description

      Internal Server Error: /c/2a_rozne/admin/contests/contest/2a_rozne/delete/
      Traceback (most recent call last):
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/core/handlers/base.py", line 132, in get_response
          response = wrapped_callback(request, *callback_args, **callback_kwargs)
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/utils/decorators.py", line 145, in inner
          return func(*args, **kwargs)
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/db/transaction.py", line 225, in __exit__
          connection.commit()
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 173, in commit
          self._commit()
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 142, in _commit
          return self.connection.commit()
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/db/utils.py", line 98, in __exit__
          six.reraise(dj_exc_type, dj_exc_value, traceback)
        File "/home/users/sio2/sio2/venv/local/lib/python2.7/site-packages/django/db/backends/base/base.py", line 142, in _commit
          return self.connection.commit()
      IntegrityError: update or delete on table "problems_problem" violates foreign key constraint "gamification_problem_id_6c405b0a31bad73a_fk_problems_problem_id" on table "gamification_problemdifficulty"
      DETAIL: Key (id)=(11080) is still referenced from table "gamification_problemdifficulty".

      The solution is to add ON CASCADE DELETE in the Django models for gamification.

        Issue Links

          Activity

          Connect your code to JIRA

          Link every code change to JIRA just by adding an issue keys in commit messages. Bridge the gap back to your source and know which changes fixed which JIRA issues.

          Git & Mercurial in the cloud

          Collaborate across unlimited private code repositories.

          Git behind the firewall

          Manage and collaborate on Git repositories behind a firewall.

          Browse and search code

          Browse, search, and track source code repositories.

            People

            • Assignee:
              Szymon Acedański
              Reporter:
              Szymon Acedański
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: