CODEWITHSUNDEEP
pythonsqliteflaskweb-hostinguwsgi
hantaray
hantaray

Reputation: 1

After modifying the schema Flask with wsgi tells me there is no such column, but it's there

I followed the Flask tutorial (https://flask.palletsprojects.com/en/3.0.x/tutorial/) and created a Flask app with factory and a SQLite database. I run the app on a server via uwsgi and added github actions for CI/CD.

I modified the schema.sql, reinitialized my SQLite database and reinstalled the app. Now I can still run it on production server, but when I start it with uwsgi, I get sqlite3.OperationalError: column not found (one of the columns that have I changed/added). When I check my SQLite file, the column is there.

Any Ideas?

Upvotes: -1

Views: 58

Answers (1)

hantaray
hantaray

Reputation: 1

The problem was the instance_path from Flask.

My database is located in /home/username/appname/instance/, but the instance_path, where Flask was looking for the database was: /home/username/.local/var/appname-instance/

When I set the instance_path explicitly in create_app() it works.

Upvotes: 0

Related Questions