search

pyfa-org / Pyfa

Python fitting assistant, cross-platform fitting tool for EVE Online
GNU General Public License v3.0
1.61k stars 406 forks source link

Error when viewing fit after deleting character #2541

Open kriskog opened 10 months ago

kriskog commented 10 months ago

Bug Report

Expected behavior:

Actual behavior:

Detailed steps to reproduce:

Deleted a character via character editor Changed active tab to a fit using the deleted character Got error Afterwards, the fit is set to use character All 0

Fits involved in EFT format (Edit > To Clipboard > EFT):

Release or development git branch? Please note the release version or commit hash:

Release

Operating system and version (eg: Windows 10, OS X 10.9, OS X 10.11, Ubuntu 16.10):

Windows 10

Other relevant information:

pyfa v2.55.0 EVE Data Version: 2420589 (2023-11-14 13:22:08)

OS version: Windows-10-10.0.19041-SP0 Python version: 3.7.9 (tags/v3.7.9:13c94747c7, Aug 17 2020, 18:58:18) [MSC v.1900 64 bit (AMD64)] wxPython version: 4.0.6 (wxWidgets 3.0.5) SQLAlchemy version: 1.3.23 Logbook version: 1.6.0 Requests version: 2.28.1 Dateutil version: 2.8.2

####################

Traceback (most recent call last): File "site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context File "site-packages\sqlalchemy\engine\default.py", line 608, in do_execute sqlite3.IntegrityError: NOT NULL constraint failed: characterSkills.characterID

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "eos\db\saveddata\queries.py", line 562, in commit File "site-packages\sqlalchemy\orm\session.py", line 1046, in commit File "site-packages\sqlalchemy\orm\session.py", line 504, in commit File "site-packages\sqlalchemy\orm\session.py", line 483, in _prepare_impl File "site-packages\sqlalchemy\orm\session.py", line 2540, in flush File "site-packages\sqlalchemy\orm\session.py", line 2682, in flush File "site-packages\sqlalchemy\util\langhelpers.py", line 70, in exit File "site-packages\sqlalchemy\util\compat.py", line 182, in raise File "site-packages\sqlalchemy\orm\session.py", line 2642, in _flush File "site-packages\sqlalchemy\orm\unitofwork.py", line 422, in execute File "site-packages\sqlalchemy\orm\unitofwork.py", line 589, in execute File "site-packages\sqlalchemy\orm\persistence.py", line 245, in save_obj File "site-packages\sqlalchemy\orm\persistence.py", line 1136, in _emit_insert_statements File "site-packages\sqlalchemy\engine\base.py", line 1011, in execute File "site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection File "site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement File "site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context File "site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapiexception File "site-packages\sqlalchemy\util\compat.py", line 182, in raise File "site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context File "site-packages\sqlalchemy\engine\default.py", line 608, in do_execute sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: characterSkills.characterID [SQL: INSERT INTO "characterSkills" ("itemID", "_Skill__level", created, modified) VALUES (?, ?, ?, ?)] [parameters: (43702, None, '2023-11-25 10:58:31.902635', None)] (Background on this error at: http://sqlalche.me/e/13/gkpj)

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "gui\builtinAdditionPanes\notesView.py", line 53, in fitChanged File "service\fit.py", line 264, in editNotes File "eos\db\saveddata\queries.py", line 568, in commit TypeError: init() missing 2 required positional arguments: 'params' and 'orig'