node.js - How can I solve strapi's errors?

Question

I am trying to develop a portfolio website with Gatsby and Strapi. Everything was working perfectly fine until I tried flooding strapi with some data and while saving it showed "An error occurred", and development server stopped, I tried restarting but showed a lot of errors. I googled the errors and I couldn't solve it. I tried the solution at this as well but it was still unsolved. Someone, please help me with this. After running npm run develop, the output was:

> [email protected] develop C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api     
> strapi develop

[2021-01-29T07:16:16.253Z] debug ?? Server wasn't able to start properly.
[2021-01-29T07:16:16.256Z] error Error: SQLITE_ERROR: duplicate column name: title
    at Client_SQLite3._query (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlibdialectssqlite3index.js:99:12)
    at Client_SQLite3.query (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlibclient.js:158:17)
    at Runner.query (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlib
unner.js:135:36)
    at Runner.<anonymous> (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlib
unner.js:228:25)
    at processImmediate (internal/timers.js:461:21)
From previous event:
    at Runner.queryArray (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlib
unner.js:227:12)
    at C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlib
unner.js:37:25
From previous event:
    at Runner.run (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlib
unner.js:25:16)
    at SchemaBuilder.Target.then (C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modulesknexlibinterface.js:14:43)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] develop: `strapi develop`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] develop script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR!     C:UsersAmitAppDataRoaming
pm-cache\_logs2021-01-29T07_16_16_353Z-debug.log     

And the log file:

0 info it worked if it ends with ok
1 verbose cli [
1 verbose cli   'C:\Program Files\nodejs\node.exe',
1 verbose cli   'C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js',
1 verbose cli   'run',
1 verbose cli   'develop'
1 verbose cli ]
2 info using [email protected]
3 info using [email protected]
4 verbose run-script [ 'predevelop', 'develop', 'postdevelop' ]
5 info lifecycle [email protected]~predevelop: [email protected]
6 info lifecycle [email protected]~develop: [email protected]
7 verbose lifecycle [email protected]~develop: unsafe-perm in lifecycle true
8 verbose lifecycle [email protected]~develop: PATH: C:Program Files
odejs
ode_modules
pm
ode_modules
pm-lifecycle
ode-gyp-bin;C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
ode_modules.bin;C:Program FilesGitmingw64in;C:Program FilesGitusrin;C:UsersAmitin;C:Program FilesCommon FilesOracleJavajavapath;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:WINDOWSSystem32WindowsPowerShellv1.0;C:WINDOWSSystem32OpenSSH;C:Program FilesGitcmd;C:Program Files
odejs;C:UsersAmitAppDataLocalProgramsPythonPython39Scripts;C:UsersAmitAppDataLocalProgramsPythonPython39;C:UsersAmitAppDataLocalMicrosoftWindowsApps;C:NewProgramsflutterin;C:UsersAmitAppDataLocalProgramsMicrosoft VS Codein;C:UsersAmitAppDataRoaming
pm
9 verbose lifecycle [email protected]~develop: CWD: C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
10 silly lifecycle [email protected]~develop: Args: [ '/d /s /c', 'strapi develop' ]
11 silly lifecycle [email protected]~develop: Returned: code: 1  signal: null
12 info lifecycle [email protected]~develop: Failed to exec develop script
13 verbose stack Error: [email protected] develop: `strapi develop`
13 verbose stack Exit status 1
13 verbose stack     at EventEmitter.<anonymous> (C:Program Files
odejs
ode_modules
pm
ode_modules
pm-lifecycleindex.js:332:16)
13 verbose stack     at EventEmitter.emit (events.js:315:20)
13 verbose stack     at ChildProcess.<anonymous> (C:Program Files
odejs
ode_modules
pm
ode_modules
pm-lifecyclelibspawn.js:55:14)
13 verbose stack     at ChildProcess.emit (events.js:315:20)
13 verbose stack     at maybeClose (internal/child_process.js:1048:16)
13 verbose stack     at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5)
14 verbose pkgid [email protected]
15 verbose cwd C:UsersAmitDesktopDevgatsby-strapi-portfolioportfolio-api
16 verbose Windows_NT 10.0.19041
17 verbose argv "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "run" "develop"
18 verbose node v14.15.4
19 verbose npm  v6.14.10
20 error code ELIFECYCLE
21 error errno 1
22 error [email protected] develop: `strapi develop`
22 error Exit status 1
23 error Failed at the [email protected] develop script.
23 error This is probably not a problem with npm. There is likely additional logging output above.
24 verbose exit [ 1, true ]

question from:https://stackoverflow.com/questions/65950471/how-can-i-solve-strapis-errors

Answer 1

The key output message is:

error Error: SQLITE_ERROR: duplicate column name: title

According to this GitHub thread: check all the references in your database, the naming and the changes you may did in the usernames and passwords, also double check your local settings file.

Additionally, you can also delete the offending table (title) and remade it again.

On the other hand, on this other GitHub thread they point to update the knex dependency by:

npm update knex