Strapi error create index github The text was updated successfully, but these errors were encountered: Feb 28, 2023 · Hello, in 4. 26 Informations Node. I'm trying to install i18n in those models. Oct 3, 2024 · When migrating the application from Strapi 4 to Strapi 5 and deploying on cloud, in some cases the following error will happen causing the migration to fail and automatic rollback to last known good config also fails (requires restoring a database backup) Jun 14, 2015 · I am experiencing a create index already exists error when creating a one-to-one relational field on a component. Nov 1, 2023 · This is a templated message. 4 D Jan 2, 2024 · This is a templated message. Hello, please follow the issue template. Nov 27, 2023 · yarn create strapi-app my-project --quickstart npm run setup npm run build npm run start yarn install yarn develop yarn start ### Additional context Add any other context about the problem here. Possibly this had something to do with the User collection type. 4 YARN version: 1. 0 npm version: 5. This works perfectly, everything about it is good. Oct 15, 2020 · Describe the bug On npm run strapi dev, I get the following error: Server wasn't able to start properly. env files. Jan 6, 2022 · @kasonde, I used the strapi starter with next-blog. Jun 8, 2023 · To demonstrate the problem that occurs you can overwrite the strapi schema-inspector with the file in the repo. Mar 6, 2011 · You signed in with another tab or window. Nov 9, 2023 · Node. Then now I'm trying to add my Apr 1, 2020 · Describe the bug After upgrading to 3. Removing a field from a Mongoose model doesn't affect the database so Strapi should also remove the unneeded indexes from DB. Clone a database on a Postgres server, e. 13. According to this thread: MySQL 8 has supports pluggable authentication methods. 3 NPM version: 6. initialize \node_modules\strapi-plugin-graphql\hooks\graphql\index. 5, and did all the migrations but i’m getting this error. 4. By default, one of them named caching_sha2_password is used rather than our good old mysql_native_password. Breaking changes at mount-models. 0-beta. 4 Dec 8, 2019 · You signed in with another tab or window. After changing the relations between two collections types Strapi does not startup again, but crashes. . Oct 3, 2024 · When migrating the application from Strapi 4 to Strapi 5 and deploying on cloud, in some cases the following error will happen causing the migration to fail and automatic rollback to last known good config also fails (requires restoring a database backup) Jun 14, 2015 · I am experiencing a create index already exists error when creating a one-to-one relational field on a component. 2 NPM version: 6. Apr 23, 2021 · Bug report Describe the bug I am running models from a plugin. Oct 3, 2023 · Cancel Create saved Sign up for a free GitHub account to open an issue and contact its maintainers and the community. 1 I installed nodejs v12. Steps to reproduce the behavior. Oct 29, 2024 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. The entire process worked without any bigger issues and the app runs in production. Oct 19, 2018 · You signed in with another tab or window. x. js: // Ensure indexes are synced with the model, prevent duplicat Jan 22, 2019 · @franckadil I'm sorry we can't help you on our side, but the aws-s3 dependency doesn't exist anymore on 4. If you have problems with the dependency might be because some caching or node_modules stuff Jan 23, 2018 · Node. 0-alpha. js version: 8. 0. Sep 20, 2024 · You signed in with another tab or window. May 9, 2022 · You signed in with another tab or window. 7. Please update that in your issue to make sure anyone else looking at this issue knows exactly what you did to get to his point. js with schema-inspector. js Aug 21, 2019 · Strapi version: 3. js version: NPM version: Strapi version: Database: Operating system: (Optional) Link to your Project: What is the current behavior? Sep 4, 2019 · > strapi develop Cleaning dist dir (5ms) ⠋ Loading Strapi⠋ Building build context [INFO] Including the following ENV variables as part of the JS bundle: - ADMIN_PATH - STRAPI_ADMIN_BACKEND_URL - STRAPI_TELEMETRY_DISABLED Building build context (82ms) Creating admin (167ms) ⠧ Loading Strapi[ERROR] There seems to be an unexpected error, try Jan 7, 2021 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. “components_readings_information_tp_informations_referenc… debug: ⛔ Server wasn’t able to start properly. Running on windows, though. 0 Strapi version: 3. System Node. 1) Is your project Javascript or Typescript: Javascript Describe the bug Trying to upgrade a 4. Jun 14, 2018 · You signed in with another tab or window. The index names end up too long. 1 Aug 3, 2022 · Create a couple of components and use it in a model (so strapi would create link between them and create index). So replace node_modules/@strapi/database/lib/dialects/mysql/schema-inspector. May 9, 2019 · Informations Node. 22. 0 Strapi version: 4. 1 strapi 3. yarn create strapi-starter@3 my-project gatsby-blog. Could you give me an example on how to do so? Aug 10, 2023 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. 3 Operating system: Ubuntu 16. 9; Database: MongoDB; Operating system: Ubuntu; Suggested solution. $ yarn build yarn run v1. I was able to install the new packages and rebuild the admin panel successf Saved searches Use saved searches to filter your results more quickly Dec 22, 2021 · This is a templated message. Jun 13, 2018 · I believe the issue here is that every single model has a FULLTEXT search index being created but on models that don't have a column that can be placed in the index IE a boolean or a relation it will throw out errors. Aug 11, 2020 · Basic installation of strapi; Connect the database to Postgresql; Create a Collection called resources with a json field called tags. please try there. j 🙇♀️ Expected behavior/code. 15. This command will not change other values in your . By the way, as a quick fix, after removing a unique field the developer can manually remove the related index. 04 LTS My connection with mongodb is flowing normally but when I try to do some post or query I Mar 14, 2024 · 🙇♀️ Expected behavior/code. Add an item to the collection; Search for resources GET /resources?tags_contains=test; Expected behavior I expect a list of entities fitlered by json field. 📦 Node version: v21. Mar 8, 2024 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. Mar 31, 2021 · Hi @creazy231 We can't do anything about any database performances per say :) here you need to create indexes in your DB to improve the performances. I'm doing this a college capstone project, and being new to Strapi, we probably messed up porting it so we tried recreating the API from scratch. 📦 Node version: v20. 2 NPM version: 9. Let's assume the index strapi is trying to create is components_multiple_choice_question_multiple_choices_component_type_fk (longer than 63 chars) Upon save, strapi does migration and crates an index using knex Jan 22, 2019 · Saved searches Use saved searches to filter your results more quickly Feb 9, 2022 · Describe the bug. I tracked down the code that generates the indexes and foreignKey Hey there, So I set up meilisearch on my Strapi setup a while ago, and I ticked a model I've got called "Products". Anyway, closing as this isn't a bug. Apr 1, 2012 · Dropping the strapi_migrations table does not resolve the problem, but it gets thrown for another table. Feb 10, 2022 · You signed in with another tab or window. We ask that you please follow the issue template. Saved searches Use saved searches to filter your results more quickly SQL 查询: -- -- 表的索引 `strapi_administrator` -- ALTER TABLE `strapi_administrator` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `strapi_administrator_email_unique` (`email`) MySQL 返回: 文档 #1071 - Specified key was too long; max key length is 767 bytes Apr 21, 2019 · node 10. 4, strapi-connector-mongoose started to remove manually created indexes at launch point. 19 $ strapi Feb 19, 2019 · @brunodeangelis the problem is neither, the ALTER TABLE command in normal SQL vs SQLite are different (in that the SQLite version is far more limited) In order to modify a column in a table (and keep the data) effectively what has to happen is a temporary table is made with the modifications, data is copied over from existing to the temp, the existing is deleted, and the temp is renamed like Nov 5, 2019 · Describe the bug A clear and concise description of what the bug is. Let's assume the index strapi is trying to create is components_multiple_choice_question_multiple_choices_component_type_fk (longer than 63 chars) Upon save, strapi does migration and crates an index using knex Dec 23, 2021 · Just to follow up what @alecandido kindly linked, to solve it just add a "@3" after create-strapi-starter. "reference_cell": { "type": "relation", "relation": "oneToOne", "target": "api::reference-cell. Run yarn develop. js. You can use npm run setup in the project folder, to create the sapper . TypeError: Cannot read property 'url' of undefined at Object. Hello @KristofKekesi,. Read this github issue. Mar 30, 2024 · error: create index “components_readings_information_tp_informations_reference_cell_links_fk” on “public”. js version: v18. Fixes issues related to Strapi's database schema constraints. 1 Strapi version: 3. env and create/update the strapi . Aug 3, 2022 · Create a couple of components and use it in a model (so strapi would create link between them and create index). env file with the JWT_SECRETs it needs. 035Z] warn The bootstrap function is taking unusually long to execute (3500 Mar 3, 2022 · Saved searches Use saved searches to filter your results more quickly Jul 21, 2021 · npx create-strapi-app backend; Select "Custom (manual settings) Type "N" to create a template; Choose "postgres" Setup postgres credentials and select "no" for SSL connection; Application completes; Added email provider: yarn add strapi-provider-email-sendgrid; Added upload provider: yarn add strapi-provider-upload-aws-s3; Edited config/plugins. Hello @promasterCode,. Thank you for reporting this bug, however we are unable to reproduce the issue you described given the information we have on hand. 16. 11. DROP INDEX "articles_categories_links_inv_fk"; It look like the strapi server everytime it started it create index for relation collection so dropping the index solved it. Just tested and worked fine. 1 npm 6. Jan 5, 2022 · …fier length issues Renamed `components_components_additional_informations` to a shorter name to avoid database errors caused by exceeding identifier length limits. create database <new-db> template <old-db>; Nov 8, 2020 · Unable to Start After DB Import (error: relation X already exists) Hi, I have the same strapi app deployed on multiple environments (local, Heroku, etc) and I'm trying to move the data from one to the other. 0 we added a validator to check if media is passed in the api #14670. js version: v12. If you run this command on an existing strapi instance your backend and frontend strapi users will need to sign in again. 👩💻 Environment. Jan 2, 2024 · I’m trying to upgrade the strapi version to 4. I had this error after upgrading to latest Strapi and all dependencies, what helped me, is to rebuild the Strapi admin interface: or. 0 project to Oct 28, 2020 · Saved searches Use saved searches to filter your results more quickly Sep 10, 2022 · Core controllers only exist for content types, you can still create custom controllers using the alternative syntax. 2 Database: MySQL (MariaDB) Operating system: OS (Sonoma 14. A clear and concise description of what you expected to happen (or code). 4 yarn run v1. You switched accounts on another tab or window. or. Feb 28, 2020 · Oh wait a second, that paste didn't come from the branch I was running. You signed in with another tab or window. 0 2 I use command "npx create-strapi-app lxyapi --quickstart" to create the banckend 3 Just two warns appeared "[2019-11-15T02:08:18. then start develop. Steps to reproduce the behavior do the Quickstart command to create a Strapi project instantly: Go to 'do the command npm develo Feb 17, 2022 · Saved searches Use saved searches to filter your results more quickly Mar 14, 2024 · 🙇♀️ Expected behavior/code. A proper issue submission let's us better understand the origin of your bug and therefore help you. Dec 21, 2024 · You signed in with another tab or window. Could you share how you are sending the file? Maybe the validator doesn't account for that format and we could refactor it. This is something we will want to support in strapi mid term but in the meantime it is fairly easy to add on your own :) Thanks for the fast reply. Reload to refresh your session. reference-cell" } Mar 20, 2022 · The way I fix this issue is removing the following index from a data base and then it started working for me. You signed out in another tab or window. Jan 5, 2022 · Bug report Describe the bug Hello, I have a strapi instance running on a server that I was trying to upgrade to v4 from v3 (specifically I believe it was 3. js:16:48) at Array. 19. 14. js version: 10. filter (<anonymous>) at <my project path>\node_modules\@strapi\strapi\dist Oct 3, 2024 · When migrating the application from Strapi 4 to Strapi 5 and deploying on cloud, in some cases the following error will happen causing the migration to fail and automatic rollback to last known good config also fails (requires restoring a database backup) Jun 14, 2015 · I am experiencing a create index already exists error when creating a one-to-one relational field on a component. 084] error: Cannot read properties of undefined (reading 'type') TypeError: Cannot read properties of undefined (reading 'type') at filterContentAPI (<my project path>\node_modules\@strapi\strapi\dist\services\content-api\index. This did it for me. g. 8. Run: npm run build or yarn build or strapi build depending on what you are using. It fails to start: yarn workspace v1. So: npx create-strapi-starter@3 my-project gatsby-blog. js version: 12; NPM version: 6. Could you give me an example on how to do so? Feb 28, 2023 · Hello, in 4. strapi/strapi#12101 Apr 20, 2020 · Describe the bug I'm following the document guide to install strapi,either the way using cli or docker,but always failed. Node. 1 Jun 1, 2023 · Saved searches Use saved searches to filter your results more quickly Dec 31, 2021 · Create Strapi app with yarn create strapi-app my-app; Open the app (my-app) in a text editor like VScode. 5. Nov 24, 2022 · Bug report I just deployed my strapi application to production via DigitalOcean (app-plattform). 0). 4 $ strapi develop [2021-04-23T07 Oct 16, 2023 · [2023-10-16 16:15:11. 1 You signed in with another tab or window. 26. System. Jun 5, 2019 · You signed in with another tab or window. Jul 11, 2023 · You signed in with another tab or window. 2 Database: Mongo Operating system: Debian What is the current behavior? Setting CORS Origin to anything othe Jan 28, 2023 · You signed in with another tab or window. Jan 28, 2022 · Bug report Describe the bug Using a relation in a component which is then placed in a dynamic zone can create invalid indexes in mariadb. error: alter table "challenges_invited_users_links" add constraint "challenges_invited_users_links_unique" unique ("challenge_id", "user_id") - could not create unique index "challenges_invited_users_links_unique" Feb 2, 2022 · You need to build the app. Jan 12, 2022 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. See error; Expected behavior. bvcgn imy qactd kcsl vlxeyu flqqy xrx bjk oeszsg pldsink siwjn lznd qgblvj zkwda jlurx