After updating from 1.20.x to 1.27.2, db stopped working on nginx. I still can run it on local host running n8n start, but when trying to run it on nginx, this error appears. Tried to downgrade to 1.20 again, but it still dont work anymore.
When running on nginx:
Error: There was an error initializing DB
DriverPackageNotInstalledError: SQLite package has not been found installed. Try to install it: npm install sqlite3 --save
That error looks like npm / node thinks sqlite is missing, This sort of issue is why we recommend using Docker over NPM installs as npm can introduce issues that are not related to n8n itself.
When you say you are running it on nginx what do you mean? Can you also swap to the docker image or is that not something you can run?
Solved, the issue was only because of the --ignorescripts command, i’m currently running on 1.26 to bypass this.
I think in the next release it probably will be solved, since the issue was closed on the github and the pr that solved this was merged.
I don’t use docker because my instance is on oracle ARM, so it have different structure i don’t have enough knowledge to install it properly on arm yet.
But the problem of this issue i requested is caused by the --ignorescripts command, Thank you
Hey @guispiller, I encountered the same problem. If you want to run 1.27.2 without the sqlite error, what you can do is:
npm install -g --omit=dev [email protected] --ignore-scripts
npm rebuild --prefix=~/.nvm/versions/node/v18.17.0/lib/node_modules/n8n sqlite3
Please note that you may have to update the path where your n8n installation resides.