AttributeError: module 'sqlalchemy_mate' has no attribute 'ExtendedBase'

Deployment
,
1

This app worked fine a week ago. Now I get this error:

AttributeError: module ‘sqlalchemy_mate’ has no attribute ‘ExtendedBase’

points to this line in my code which runs fine in Jupyter Lab Notebook

from uszipcode import SearchEngine

sqlalchemy is not in my requirements.txt but it never was when the code worked.

2

You may be using a different version of sqlalchemy_mate or uszipcode or some other related package.

3

Reran pip-compile which created an entirely different requirements.txt file. Still same error.

This file is autogenerated by pip-compile with Python 3.9

by the following command:

pip-compile --strip-extras requirements.in

atomicwrites==1.4.1
# via uszipcode
attrs==23.2.0
# via uszipcode
certifi==2024.2.2
# via requests
charset-normalizer==3.3.2
# via requests
contourpy==1.2.1
# via matplotlib
cycler==0.12.1
# via matplotlib
et-xmlfile==1.1.0
# via openpyxl
fonttools==4.52.4
# via matplotlib
fuzzywuzzy==0.18.0
# via uszipcode
greenlet==3.0.3
# via sqlalchemy
haversine==2.8.1
# via uszipcode
idna==3.7
# via requests
importlib-resources==6.4.0
# via matplotlib
kiwisolver==1.4.5
# via matplotlib
matplotlib==3.9.0
# via
# -r requirements.in
# seaborn
numpy==1.26.4
# via
# -r requirements.in
# contourpy
# matplotlib
# pandas
# seaborn
openpyxl==3.1.3
# via -r requirements.in
packaging==24.0
# via matplotlib
pandas==2.2.2
# via
# -r requirements.in
# seaborn
pathlib-mate==1.3.2
# via uszipcode
pillow==10.3.0
# via matplotlib
prettytable==3.10.0
# via sqlalchemy-mate
pyparsing==3.1.2
# via matplotlib
python-dateutil==2.9.0.post0
# via
# matplotlib
# pandas
pytz==2024.1
# via pandas
requests==2.32.3
# via uszipcode
seaborn==0.13.2
# via -r requirements.in
six==1.16.0
# via python-dateutil
sqlalchemy==2.0.30
# via
# sqlalchemy-mate
# uszipcode
sqlalchemy-mate==2.0.0.2
# via uszipcode
typing-extensions==4.12.0
# via sqlalchemy
tzdata==2024.1
# via pandas
urllib3==2.2.1
# via requests
uszipcode==1.0.1
# via -r requirements.in
wcwidth==0.2.13
# via prettytable
zipp==3.19.0
# via importlib-resources

4

Those are not necessarily the same versions you are using when running the notebook.

5

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.