Problem creating credential SQLITE_ERROR: near "-": syntax error

Questions
1

Hey everyone,

I’m running into a major issue on my self-hosted n8n setup. Since yesterday, I can’t save anything anymore — not credentials, not workflows, not even small changes. Every time I try, it either does nothing or throws an error like this:

vbnet

KopierenBearbeiten

Problem creating credential  
SQLITE_ERROR: near "-": syntax error

I’ve not changed anything manually in the setup or config recently. The problem appeared out of nowhere.

Some context:

  • I’m running the latest n8n version (1.95.3) via Docker (docker.n8n.io/n8nio/n8n)
  • Hosted on a Linux VPS with Traefik and Docker Compose
  • Using SQLite as the database (default setup)
  • Everything was working fine until recently
  • In the n8n cloud, the same workflows work and save just fine
  • I don’t really know much about servers or databases, so I’m totally lost here

What could cause this? Do I need to clean or reset the database somehow? Or is this a known bug in this version?

Any help is massively appreciated :folded_hands:

2

Hey @Johannes_Kofler ,

I would suggest to check if the db is not corrupted first

Run this inside your Docker container:

docker exec -it <your-n8n-container-name> bash sqlite3 /home/node/.n8n/database.sqlite

Then in the SQLite prompt:

PRAGMA integrity_check;

If you get ok, the DB isn’t corrupted.

Exit with .exit

1 Like
3

Thank you all working fine again after restarting the server lol