Admin panel got stuck on an sqlite error. Probably a bug that does not handle sqlite error

System Information
  • Strapi Version: 1.22.5
  • Operating System: Mac El capitan
  • Database: Sqlite
  • Node Version:
  • NPM Version: 6.13.4
  • Yarn Version: 1.22.5

I got this error while changing a field in the Admin side. And after that the admin panel is inaccessible.

Error while running command configurationRestore: alter table restaurants add column description text null - SQLITE_ERROR: duplicate column name: description

When I use yarn develop or yarn start on the terminal here is what I get:

yarn start
yarn run v1.22.5
$ strapi start
(node:5154) ExperimentalWarning: Package name self resolution is an experimental feature. This feature could change at any time
[2020-11-01T12:33:32.428Z] debug :no_entry: Server wasn’t able to start properly.
[2020-11-01T12:33:32.429Z] error Error: SQLITE_ERROR: duplicate column name: description
at Client_SQLite3._query (…/my-project/node_modules/knex/lib/dialects/sqlite3/index.js:99:12)
at Client_SQLite3.query (…/my-project/node_modules/knex/lib/client.js:158:17)
at Runner.query (…/my-project/node_modules/knex/lib/runner.js:135:36)
at Runner.queryArray (…/my-project/node_modules/knex/lib/runner.js:224:14)
at …/my-project/node_modules/knex/lib/runner.js:37:25
From previous event:
at (…/my-project/node_modules/knex/lib/runner.js:25:16)
at SchemaBuilder.Target.then (…/my-project/node_modules/knex/lib/interface.js:14:43)
error Command failed with exit code 1.
info Visit yarn run | Yarn for documentation about this command.

I tried to use command yarn strapi config:restore. But it did not work. Nether strapi config:dump works


Check your api/restaurant/models/restaurant.settings.json file and see if there is duplicate schemas for a “description” field. If there is, remove one of them then try to restart the server.