Issue with SQLite after updating to 1.27.2

Describe the problem/error/question

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.

PS: needed to work around error from this topic Issue upgrading to 1.27.2 using npm install -g --omit=dev [email protected] --ignore-scripts to install correctly.

What is the error message (if any)?

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

SQLite is correctly installed and working

Information on your n8n setup

  • n8n version: 1.27.2
  • Database (default: SQLite): SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: ubuntu 22

Hey @guispiller,

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

1 Like

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.

1 Like

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