System Information
- Strapi Version: 4.19.1
- Operating System: Ubuntu 22.04.3 LTS
- Database: SQLite
- Node Version: v20.10.0
- NPM Version: 10.2.3
- Yarn Version:
We have a team project and team members have access to the database. some one changed something and that error appeared.
When I launch run develop server error shows different table names.
I tried first to create them but it changes table names constantly
Cant figure it out how can I fix it
SqliteError: CREATE TABLE _knex_temp_alter640 (id varchar(255) PRIMARY KEY AUTOINCREMENT, status boolean NULL, created_at datetime NULL,
││ updated_at datetime NULL, published_at datetime NULL, created_by_id integer NULL, updated_by_id integer NULL, CONSTRAINT
││ copies_created_by_id_fk FOREIGN KEY (created_by_id) REFERENCES admin_users (id) ON DELETE SET NULL, CONSTRAINT copies_updated_by_id_fk
││ FOREIGN KEY (updated_by_id) REFERENCES admin_users (id) ON DELETE SET NULL, CONSTRAINT copies_created_by_id_fk FOREIGN KEY (created_by_id)
││ REFERENCES admin_users (id) ON DELETE SET NULL, CONSTRAINT copies_updated_by_id_fk FOREIGN KEY (updated_by_id) REFERENCES admin_users
││ (id) ON DELETE SET NULL) - AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY
││ at Database.prepare (/root/strapi/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
││ at Client_BetterSQLite3._query (/root/strapi/node_modules/knex/lib/dialects/better-sqlite3/index.js:35:34)
││ at executeQuery (/root/strapi/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
││ at Client_BetterSQLite3.query (/root/strapi/node_modules/knex/lib/client.js:154:12) ││ at /root/strapi/node_modules/knex/lib/execution/transaction.js:371:24 ││ at new Promise ()
││ at trxClient.query (/root/strapi/node_modules/knex/lib/execution/transaction.js:366:12)
││ at Runner.query (/root/strapi/node_modules/knex/lib/execution/runner.js:141:36)
││ at Runner.queryArray (/root/strapi/node_modules/knex/lib/execution/runner.js:235:21)
││ at Runner.queryArray (/root/strapi/node_modules/knex/lib/execution/runner.js:287:31)