Error when opening ship fits

Open OphiuchusPtolemy opened this issue 2 years ago • 0 comments

I reinstalled Pyfa yesterday after a long break from Eve and it worked fine.

Now I'm getting the below error whenever I try to open a fitting.

I've tried uninstalling and reinstalling but the error is still coming up.

pyfa v2.55.0 EVE Data Version: 2420589 (2023-11-14 12: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.OperationalError: no such column: prices.status

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

Traceback (most recent call last): File "gui\builtinViews\fittingView.py", line 611, in fitChanged File "gui\builtinViews\fittingView.py", line 742, in refresh File "gui\display.py", line 219, in refresh File "gui\builtinViewColumns\price.py", line 66, in getText File "eos\gamedata.py", line 457, in price File "eos\db\saveddata\queries.py", line 84, in checkAndReturn File "eos\db\saveddata\queries.py", line 58, in setCache File "eos\db\saveddata\queries.py", line 344, in getPrice File "site-packages\sqlalchemy\orm\query.py", line 1018, in get File "site-packages\sqlalchemy\orm\query.py", line 1135, in _get_impl File "site-packages\sqlalchemy\orm\loading.py", line 286, in load_on_pk_identity File "site-packages\sqlalchemy\orm\query.py", line 3490, in one File "site-packages\sqlalchemy\orm\query.py", line 3459, in one_or_none File "site-packages\sqlalchemy\orm\query.py", line 3535, in iter File "site-packages\sqlalchemy\orm\query.py", line 3560, in _execute_and_instances 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_dbapi_exception 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.OperationalError: (sqlite3.OperationalError) no such column: prices.status [SQL: SELECT prices."typeID" AS "prices_typeID", prices.price AS prices_price, prices.time AS prices_time, prices.status AS prices_status FROM prices WHERE prices."typeID" = ?] [parameters: (486,)] (Background on this error at: http://sqlalche.me/e/13/e3q8)

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

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

Traceback (most recent call last): File "gui\statsPane.py", line 79, in fitChanged File "gui\builtinStatsViews\priceViewFull.py", line 88, in refreshPanel File "service\price.py", line 179, in getPrices File "eos\gamedata.py", line 457, in price File "eos\db\saveddata\queries.py", line 84, in checkAndReturn File "eos\db\saveddata\queries.py", line 58, in setCache File "eos\db\saveddata\queries.py", line 344, in getPrice File "site-packages\sqlalchemy\orm\query.py", line 1018, in get File "site-packages\sqlalchemy\orm\query.py", line 1135, in _get_impl File "site-packages\sqlalchemy\orm\loading.py", line 286, in load_on_pk_identity File "site-packages\sqlalchemy\orm\query.py", line 3490, in one File "site-packages\sqlalchemy\orm\query.py", line 3459, in one_or_none File "site-packages\sqlalchemy\orm\query.py", line 3535, in iter File "site-packages\sqlalchemy\orm\query.py", line 3560, in _execute_and_instances 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_dbapi_exception 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.OperationalError: (sqlite3.OperationalError) no such column: prices.status [SQL: SELECT prices."typeID" AS "prices_typeID", prices.price AS prices_price, prices.time AS prices_time, prices.status AS prices_status FROM prices WHERE prices."typeID" = ?] [parameters: (587,)] (Background on this error at: http://sqlalche.me/e/13/e3q8)

Nov 25 '23 18:11 OphiuchusPtolemy