I created a unique identifier field called ID, and when I saved it I had a few red error banners, and then the server stopped, and it wont restart. The error is as follows, which is a database error. Being new to Strapi, how can I fix this?
I assume its to do with the fact I created a unique identifier, maybe with the name ID? I would guess this is a bug too, I should not have been able to crash the system simply by creating a field in the admin?
error: CREATE TABLE
_knex_temp_alter648
(id
varchar(255) PRIMARY KEY AUTOINCREMENT,name
varchar(255) NULL,created_at
datetime NULL,updated_at
datetime NULL,published_at
datetime NULL,created_by_id
integer NULL,updated_by_id
integer NULL, CONSTRAINTaccessories_created_by_id_fk
FOREIGN KEY (created_by_id
) REFERENCESadmin_users
(id
) ON DELETE SET NULL, CONSTRAINTaccessories_updated_by_id_fk
FOREIGN KEY (updated_by_id
) REFERENCESadmin_users
(id
) ON DELETE SET NULL, CONSTRAINTaccessories_created_by_id_fk
FOREIGN KEY (created_by_id
) REFERENCESadmin_users
(id
) ON DELETE SET NULL, CONSTRAINTaccessories_updated_by_id_fk
FOREIGN KEY (updated_by_id
) REFERENCESadmin_users
(id
) ON DELETE SET NULL) - SQLITE_ERROR: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY