search

fi-ksi / web-backend

Backend for KSI web written in Python.
MIT License
8 stars 3 forks source link

Vyhodnocení modulu selže při opakovaném zadání trofeje #162

Open esoadamo opened 2 years ago

esoadamo commented 2 years ago

Pokud uživatel zadá v modulu dvakrát stejnou odpověď, za kterou má dostat trofej, modul spadne. Problém je v duplikaci primárního klíče v DB.

Úloha: Debugger v Naskoč - src , web

Stacktrace:

 [2022-07-18 21:09:45] [IP ADDRESS] [POST] [500 Internal Server Error] /modules/53/submit
 [2022-07-18 21:09:45] Traceback (most recent call last):
 [2022-07-18 21:09:45]   File "/root/naskoc-web-backend/ksi-py3-venv/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
 [2022-07-18 21:09:45]     self.dialect.do_execute(
 [2022-07-18 21:09:45]   File "/root/naskoc-web-backend/ksi-py3-venv/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
 [2022-07-18 21:09:45]     cursor.execute(statement, parameters)
 [2022-07-18 21:09:45]   File "/root/naskoc-web-backend/ksi-py3-venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 206, in execute
 [2022-07-18 21:09:45]     res = self._query(query)
 [2022-07-18 21:09:45]   File "/root/naskoc-web-backend/ksi-py3-venv/lib/python3.9/site-packages/MySQLdb/cursors.py", line 319, in _query
 [2022-07-18 21:09:45]     db.query(q)
 [2022-07-18 21:09:45]   File "/root/naskoc-web-backend/ksi-py3-venv/lib/python3.9/site-packages/MySQLdb/connections.py", line 259, in query
 [2022-07-18 21:09:45]     _mysql.connection.query(self, query)
 [2022-07-18 21:09:45] MySQLdb._exceptions.IntegrityError: (1062, "Duplicate entry '[USER_ID]-2' for key 'PRIMARY'")