strapi / starters-and-templates

Monorepo for all official Strapi v4 templates
MIT License
327 stars 117 forks source link

v4 Strapi - next-corportate template sql error #41

Open PaulBratslavsky opened 2 years ago

PaulBratslavsky commented 2 years ago

When I try to install the corporate demo template

  npx create-strapi-app demoapp --template corporate --quickstart

I get this error

 Project information                                                          

┌────────────────────┬──────────────────────────────────────────────────┐
│ Time               │ Fri May 20 2022 12:17:46 GMT-0400 (Eastern Dayl… │
│ Launched in        │ 3109 ms                                          │
│ Environment        │ development                                      │
│ Process PID        │ 12248                                            │
│ Version            │ 4.1.11 (node v14.19.1)                           │
│ Edition            │ Community                                        │
└────────────────────┴──────────────────────────────────────────────────┘

 Actions available                                                            

One more thing...
Create your first administrator 💻 by going to the administration panel at:

┌─────────────────────────────┐
│ http://localhost:1337/admin │
└─────────────────────────────┘

[2022-05-20 12:17:46.990] http: GET /admin (27 ms) 200
[2022-05-20 12:17:47.176] http: GET /admin/project-type (107 ms) 200
[2022-05-20 12:17:47.321] http: GET /admin/init (67 ms) 200
SqliteError: insert into `globals_localizations_links` (`global_id`, `inv_global_id`) values (2, 1) - FOREIGN KEY constraint failed
    at Client_BetterSQLite3._query (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/dialects/better-sqlite3/index.js:39:38)
    at executeQuery (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
    at Client_BetterSQLite3.query (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/client.js:146:12)
    at Runner.query (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/runner.js:130:36)
    at ensureConnectionCallback (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:13:17)
    at Runner.ensureConnection (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/runner.js:307:20)
    at async Runner.run (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/runner.js:30:19)
    at async Object.execute (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/database/lib/query/query-builder.js:354:22)
    at async Object.attachRelations (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/database/lib/entity-manager.js:496:11)
    at async Object.create (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/database/lib/entity-manager.js:175:7)
    at async Object.create (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/strapi/lib/services/entity-service/index.js:172:18)
    at async Object.<anonymous> (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/strapi/lib/services/entity-service/index.js:67:20)
    at async Object.create (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/plugin-i18n/server/services/entity-service-decorator.js:118:19)
    at async createEntry (/Users/paulbratslavsky/Desktop/test/demoapp/src/bootstrap.js:93:26)
    at async /Users/paulbratslavsky/Desktop/test/demoapp/src/bootstrap.js:189:5
SqliteError: insert into `pages_localizations_links` (`inv_page_id`, `page_id`) values (1, 5) - FOREIGN KEY constraint failed
    at Client_BetterSQLite3._query (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/dialects/better-sqlite3/index.js:39:38)
    at executeQuery (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/internal/query-executioner.js:37:17)
    at Client_BetterSQLite3.query (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/client.js:146:12)
    at Runner.query (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/runner.js:130:36)
    at ensureConnectionCallback (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/internal/ensure-connection-callback.js:13:17)
    at Runner.ensureConnection (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/runner.js:307:20)
    at async Runner.run (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/knex/lib/execution/runner.js:30:19)
    at async Object.execute (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/database/lib/query/query-builder.js:354:22)
    at async Object.attachRelations (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/database/lib/entity-manager.js:496:11)
    at async Object.create (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/database/lib/entity-manager.js:175:7)
    at async Object.create (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/strapi/lib/services/entity-service/index.js:172:18)
    at async Object.<anonymous> (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/strapi/lib/services/entity-service/index.js:67:20)
    at async Object.create (/Users/paulbratslavsky/Desktop/test/demoapp/node_modules/@strapi/plugin-i18n/server/services/entity-service-decorator.js:118:19)
    at async createEntry (/Users/paulbratslavsky/Desktop/test/demoapp/src/bootstrap.js:93:26)
    at async /Users/paulbratslavsky/Desktop/test/demoapp/src/bootstrap.js:174:5

Had some feedback from Derrick

He hinted that those "errors are usually because a seed process is trying to insert one set of data before the other required one exists"