Forums

sqlachemy

Hi everyone,

I am calling out to fix a problem trying to run my app.

I am using Flask, sqlAlchemy and have created a venv.

I am not sure where is the error coming from as the app runs fine on my local machine and the script get executed if I run "python3 app.py" or if I just use the GUI of pythonanywhere by clicking on "Run" button in my files section.

The console opens and a python shell comes out and run the entire program with no issues.

Therefore, When I try

python -i /var/www/www_my_domain_com_wsgi.py

I get errors: Background links to: sqlalchme.me error report

It goes into the engine/base and previously I add issues while running the program to import the Declarative_Base module.

The head of the error log:

05:57 /var/www $ python -i ziscoplankton_pythonanywhere_com_wsgi.py Traceback (most recent call last): File "/home/ziscoplankton/.local/lib/python3.10/site-packages/sqla lchemy/engine/base.py", line 145, in init self._dbapi_connection = engine.raw_connection() Blockquote

The tail:

File "/home/ziscoplankton/.local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 579, in connect return self.loaded_dbapi.connect(cargs, *cparams) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file (Background on this error at: https://sqlalche.me/e/20/e3q8)

Thank you all for your time :)

How did you set up connection to the db? If you are using a relative path to the sqlite file, try an absolute one.