Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when opening ship fits #2542

Open
OphiuchusPtolemy opened this issue Nov 25, 2023 · 0 comments
Open

Error when opening ship fits #2542

OphiuchusPtolemy opened this issue Nov 25, 2023 · 0 comments

Comments

@OphiuchusPtolemy
Copy link

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)

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

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\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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant