Skip to content

Error while retrieving skills. #2677

@DreadOp

Description

@DreadOp

pyfa v2.63.1
EVE Data Version: 2921941 (2025-05-28 06:06:09)

OS version: Windows-10-10.0.22000-SP0
Python version: 3.11.9 (tags/v3.11.9:de54cf5, Apr 2 2024, 10:12:12) [MSC v.1938 64 bit (AMD64)]
wxPython version: 4.2.1 (wxWidgets 3.2.2.1)
SQLAlchemy version: 1.4.50
Logbook version: 1.7.0.post0
Requests version: 2.31.0
Dateutil version: 2.8.2

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

Traceback (most recent call last):
File "sqlalchemy\engine\base.py", line 1910, in _execute_context
File "sqlalchemy\engine\default.py", line 736, in do_execute
sqlite3.IntegrityError: UNIQUE constraint failed: ssoCharacter.client, ssoCharacter.server, ssoCharacter.characterID

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

Traceback (most recent call last):
File "eos\db\saveddata\queries.py", line 565, in commit
File "sqlalchemy\orm\session.py", line 1454, in commit
File "sqlalchemy\orm\session.py", line 832, in commit
File "sqlalchemy\orm\session.py", line 811, in _prepare_impl
File "sqlalchemy\orm\session.py", line 3449, in flush
File "sqlalchemy\orm\session.py", line 3588, in flush
File "sqlalchemy\util\langhelpers.py", line 70, in exit
File "sqlalchemy\util\compat.py", line 211, in raise

File "sqlalchemy\orm\session.py", line 3549, in _flush
File "sqlalchemy\orm\unitofwork.py", line 456, in execute
File "sqlalchemy\orm\unitofwork.py", line 630, in execute
File "sqlalchemy\orm\persistence.py", line 245, in save_obj
File "sqlalchemy\orm\persistence.py", line 1238, in _emit_insert_statements
File "sqlalchemy\engine\base.py", line 1710, in _execute_20
File "sqlalchemy\sql\elements.py", line 334, in _execute_on_connection
File "sqlalchemy\engine\base.py", line 1577, in _execute_clauseelement
File "sqlalchemy\engine\base.py", line 1953, in _execute_context
File "sqlalchemy\engine\base.py", line 2134, in handle_dbapi_exception
File "sqlalchemy\util\compat.py", line 211, in raise

File "sqlalchemy\engine\base.py", line 1910, in _execute_context
File "sqlalchemy\engine\default.py", line 736, in do_execute
sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) UNIQUE constraint failed: ssoCharacter.client, ssoCharacter.server, ssoCharacter.characterID
[SQL: INSERT INTO "ssoCharacter" (client, "characterID", "characterName", server, "refreshToken", "accessToken", "accessTokenExpires", created, modified) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
[parameters: ('1af422d3f79adec6fcf2a41bb8cf56793ca90b0c1086a7181fe3b7160501ff30', '96386046', "Ginny A'Cyno", 'Tranquility', b'gAAAAABoO2d_PpCsYmUwiqrsURRXts5DR1l3x_JF02IKKNOuWcdeQuu1n6JXiHbtISGdEECvk2CGABJast90eXWO0BPjJbR4CFdsF80I0dM2PdLF2MwjwMQ=', 'eyJhbGciOiJSUzI1NiIsImtpZCI6IkpXVC1TaWduYXR1cmUtS2V5IiwidHlwIjoiSldUIn0.eyJzY3AiOlsiZXNpLXNraWxscy5yZWFkX3NraWxscy52MSIsImVzaS1maXR0aW5ncy5yZWFkX2Zpd ... (765 characters truncated) ... H0UwCEG-9286VQmmLkurygoPOop39Dctn96PGsAhh3jOPkj7RJTgmOLyNPp5oj8NvKLe0H-LF7inHCZ3oV1rzOTu6cI14iCzh-C_vbn7yW4Qu--P-SGopTUvfUVXU_HcNrNKIRydYwvPfi6uSSe7w', '2025-05-31 13:53:01.657683', '2025-05-31 13:33:03.658684', None)]
(Background on this error at: https://sqlalche.me/e/14/gkpj)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "gui\characterEditor.py", line 863, in addCharacter
File "service\esi.py", line 120, in login
File "service\esi.py", line 196, in handleServerRequest
File "service\esi.py", line 175, in handleLogin
File "eos\db\saveddata\queries.py", line 552, in save
File "eos\db\saveddata\queries.py", line 571, in commit
TypeError: DBAPIError.init() missing 2 required positional arguments: 'params' and 'orig'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions