a year ago
My project with n8n stopped unexpectedly, and since then, the PostgreSQL nodes are not functioning correctly. Whenever I run any workflow that includes a query on a table with a timestamp column, I encounter the error “NodeOperationError: Invalid time value.”
I’ve tried creating new instances of n8n, and even after restoring the database backup, the error persists.
If I execute a query on a table without a timestamp column, the node works.
Has anyone experienced a similar issue like this?
Thanks.
2 Replies
a year ago
Hi Brody,
I ran several tests, and after setting up three different environments, I was able to identify the issue. It worked when I created a new database and restored a backup. For some reason, the n8n nodes encounter problems when running on the old database after the crash. There was no need to reinstall PostgreSQL or n8n.
Thanks.