Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#79680 - [pychess] sqlalchemy package errors

Attached to Project: Arch Linux
Opened by Robert (lurker333) - Wednesday, 13 September 2023, 17:17 GMT
Last edited by Toolybird (Toolybird) - Wednesday, 13 September 2023, 22:02 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To No-one
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description:
Can't create/load database thus a lot of functionality (lessons, puzzles, etc) is blocked.

Additional info:
Version: 1.0.4 (Steinitz)
Log:
Exception in thread Thread-1 (opening):
Traceback (most recent call last):
File "/usr/lib/python3.11/site-packages/sqlalchemy/sql/selectable.py", line 3105, in __init__
cols_present = bool(columns)
^^^^^^^^^^^^^
File "/usr/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 535, in __bool__
raise TypeError("Boolean value of this clause is not defined")
TypeError: Boolean value of this clause is not defined

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

Traceback (most recent call last):
File "/usr/lib/python3.11/threading.py", line 1038, in _bootstrap_inner
self.run()
File "/usr/lib/python3.11/threading.py", line 975, in run
self._target(*self._args, **self._kwargs)
File "/usr/lib/python3.11/site-packages/pychess/perspectives/database/__init__.py", line 267, in opening
chessfile = PGNFile(protoopen(filename), self.progressbar)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/site-packages/pychess/Savers/pgn.py", line 485, in __init__
self.engine = dbmodel.get_engine(self.sqlite_path)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/site-packages/pychess/Database/model.py", line 120, in get_engine
path is None or get_schema_version(engine) != SCHEMA_VERSION
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/site-packages/pychess/Database/model.py", line 91, in get_schema_version
result = connection.execute(select(schema_version.c.version)).scalar()
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<string>", line 2, in select
File "<string>", line 2, in __init__
File "/usr/lib/python3.11/site-packages/sqlalchemy/util/deprecations.py", line 139, in warned
return fn(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3.11/site-packages/sqlalchemy/sql/selectable.py", line 3107, in __init__
util.raise_(
File "/usr/lib/python3.11/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
sqlalchemy.exc.ArgumentError: columns argument to select() must be a Python list or other iterable
Similar on github: https://github.com/pychess/pychess/issues/2102
Steps to reproduce:
launch pychess -> create database
This task depends upon

Closed by  Toolybird (Toolybird)
Wednesday, 13 September 2023, 22:02 GMT
Reason for closing:  Works for me
Additional comments about closing:  See comemnts
Comment by Robert (lurker333) - Wednesday, 13 September 2023, 17:22 GMT
Yay, forgot to add package name in summary.
[pychess]
Comment by Toolybird (Toolybird) - Wednesday, 13 September 2023, 22:01 GMT
Works fine here i.e. cannot repro. It seems you have something amiss with your local python setup.

Loading...