Don’t insert an "ID" column in the Data tables 😁

Questions
1

Describe the problem/error/question

So, yesterday I tried the Data Tables for the 1st time… and tried to insert an “ID” column for my data list with user IDs. It crashed n8n apparently :sweat_smile:

What is the error message (if any)?

I could find this in the logs:

[Wed Oct 08 2025 15:44:29.575]
root_n8n_1: 
SQLITE_ERROR: duplicate column name: ID
[Wed Oct 08 2025 15:44:29.576]
root_n8n_1: 
ResponseError: SQLITE_ERROR: duplicate column name: ID
[Wed Oct 08 2025 15:44:29.576]
root_n8n_1: 
at DataStoreController.addColumn (/usr/local/lib/node_modules/n8n/src/modules/data-table/data-store.controller.ts:156:11)
[Wed Oct 08 2025 15:44:29.576]
root_n8n_1: 
at handler (/usr/local/lib/node_modules/n8n/src/controller.registry.ts:78:12)
[Wed Oct 08 2025 15:44:29.576]
root_n8n_1: 
at /usr/local/lib/node_modules/n8n/src/response-helper.ts:157:17
[Wed Oct 08 2025 15:44:29.576]
root_n8n_1: 
[Wed Oct 08 2025 15:44:29.577]
root_n8n_1: 
SQLITE_ERROR: duplicate column name: ID
[Wed Oct 08 2025 16:20:47.735]
root_n8n_1: 
Last session crashed
[Wed Oct 08 2025 16:20:57.738]
root_n8n_1: 
Initializing n8n process
[Wed Oct 08 2025 16:20:58.819]
root_n8n_1: 
n8n ready on ::, port 5678

So maybe something to watch out for and maybe block entirely?

Information on your n8n setup

  • n8n version: 1.113.3
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): ???
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Alpine Linux
2

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