search

SINTEF / Geomaker

4 stars 4 forks source link

Thumbnail fails on sqlalchemy version 1.4 #51

Open VikingScientist opened 2 years ago

VikingScientist commented 2 years ago 
sqlalchemy.exc.StatementError: (builtins.RecursionError) maximum recursion depth exceeded while getting the str of an object
[SQL: SELECT thumbnail.id AS thumbnail_id, thumbnail.filename AS thumbnail_filename, thumbnail.project AS thumbnail_project, thumbnail.polygon_id AS thumbnail_polygon_id
FROM thumbnail
WHERE ? = thumbnail.polygon_id AND thumbnail.project = ?]
[parameters: [{}]]

At least in windows envinorement

TheBB commented 2 years ago

Can't reproduce on Linux using SqlAlchemy 1.4.36

VikingScientist commented 2 years ago

The fix is to run the following command

pip install sqlalchemy==1.3
TheBB commented 2 years ago

Or pip install 'sqlalchemy<1.4' to get you something newer than 1.3.0.

VikingScientist commented 2 years ago

/begin{nerdy voice}

well techincally sqlalchemy==1.3 will default to the newest patch version, which at the time of writing is 1.3.23

/end{nerdy voice}

Sorry, but this is the internet and you have to tell people when they're wrong :smirk:

TheBB commented 2 years ago

That's weird. I get 1.3.0 when I do it. But whatever works for you.