Strapi error create index github. You signed in with another tab or window.

Strapi error create index github 📦 Node version: v21. System Node. Hello, please follow the issue template. I'm trying to install i18n in those models. 2 NPM version: 6. Aug 11, 2020 · Basic installation of strapi; Connect the database to Postgresql; Create a Collection called resources with a json field called tags. 8. 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. System. Jun 14, 2018 · You signed in with another tab or window. 0 we added a validator to check if media is passed in the api #14670. If you have problems with the dependency might be because some caching or node_modules stuff Jan 23, 2018 · Node. 0). Oct 3, 2023 · Cancel Create saved Sign up for a free GitHub account to open an issue and contact its maintainers and the community. 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. js version: 8. env and create/update the strapi . Anyway, closing as this isn't a bug. Removing a field from a Mongoose model doesn't affect the database so Strapi should also remove the unneeded indexes from DB. 1 strapi 3. g. initialize \node_modules\strapi-plugin-graphql\hooks\graphql\index. Feb 10, 2022 · You signed in with another tab or window. Then now I'm trying to add my Apr 1, 2020 · Describe the bug After upgrading to 3. 13. 📦 Node version: v20. or. Mar 6, 2011 · You signed in with another tab or window. 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. Run yarn develop. Dec 21, 2024 · You signed in with another tab or window. Jun 8, 2023 · To demonstrate the problem that occurs you can overwrite the strapi schema-inspector with the file in the repo. js. According to this thread: MySQL 8 has supports pluggable authentication methods. Aug 3, 2022 · Create a couple of components and use it in a model (so strapi would create link between them and create index). Could you give me an example on how to do so? Feb 28, 2023 · Hello, in 4. Fixes issues related to Strapi's database schema constraints. 14. 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. You switched accounts on another tab or window. 4 Dec 8, 2019 · You signed in with another tab or window. 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. 2 NPM version: 9. 19. 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. Run: npm run build or yarn build or strapi build depending on what you are using. Possibly this had something to do with the User collection type. Steps to reproduce the behavior. 👩‍💻 Environment. 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. 0. 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. 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. TypeError: Cannot read property 'url' of undefined at Object. js version: v12. Read this github issue. Reload to refresh your session. See error; Expected behavior. 5, and did all the migrations but i’m getting this error. Nov 24, 2022 · Bug report I just deployed my strapi application to production via DigitalOcean (app-plattform). 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. If you run this command on an existing strapi instance your backend and frontend strapi users will need to sign in again. So: npx create-strapi-starter@3 my-project gatsby-blog. Jul 11, 2023 · You signed in with another tab or window. You can use npm run setup in the project folder, to create the sapper . 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. The text was updated successfully, but these errors were encountered: Feb 28, 2023 · Hello, in 4. js Aug 21, 2019 · Strapi version: 3. 0 Strapi version: 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. Oct 15, 2020 · Describe the bug On npm run strapi dev, I get the following error: Server wasn't able to start properly. 1) Is your project Javascript or Typescript: Javascript Describe the bug Trying to upgrade a 4. Apr 1, 2012 · Dropping the strapi_migrations table does not resolve the problem, but it gets thrown for another table. So replace node_modules/@strapi/database/lib/dialects/mysql/schema-inspector. 1 I installed nodejs v12. You signed out in another tab or window. 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. 16. 1 npm 6. 0-beta. 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). js version: 10. js with schema-inspector. 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. yarn create strapi-starter@3 my-project gatsby-blog. . Sep 20, 2024 · You signed in with another tab or window. 4 D Jan 2, 2024 · This is a templated message. Jan 6, 2022 · @kasonde, I used the strapi starter with next-blog. Running on windows, though. Node. 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:16:48) at Array. 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. 3 NPM version: 6. This command will not change other values in your . 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. 0 Strapi version: 3. js version: v18. 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. 1 You signed in with another tab or window. 22. It fails to start: yarn workspace v1. 9; Database: MongoDB; Operating system: Ubuntu; Suggested solution. Hello @promasterCode,. Hello @KristofKekesi,. I had this error after upgrading to latest Strapi and all dependencies, what helped me, is to rebuild the Strapi admin interface: or. 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. 4, strapi-connector-mongoose started to remove manually created indexes at launch point. May 9, 2022 · You signed in with 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. May 9, 2019 · Informations Node. The index names end up too long. 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. 0-alpha. x. 4 $ strapi develop [2021-04-23T07 Oct 16, 2023 · [2023-10-16 16:15:11. please try there. "reference_cell": { "type": "relation", "relation": "oneToOne", "target": "api::reference-cell. env file with the JWT_SECRETs it needs. 2 Database: MySQL (MariaDB) Operating system: OS (Sonoma 14. We ask that you please follow the issue template. Clone a database on a Postgres server, e. Just tested and worked fine. 3 Operating system: Ubuntu 16. 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. This works perfectly, everything about it is good. 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. Nov 1, 2023 · This is a templated message. 4. 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. 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. 7. A clear and concise description of what you expected to happen (or code). 26 Informations Node. Jan 2, 2024 · I’m trying to upgrade the strapi version to 4. 4 YARN version: 1. js version: 12; NPM version: 6. By the way, as a quick fix, after removing a unique field the developer can manually remove the related index. 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. Apr 23, 2021 · Bug report Describe the bug I am running models from a plugin. 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. Breaking changes at mount-models. 26. 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. 1 Strapi version: 3. Jun 5, 2019 · You signed in with another tab or window. 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. After changing the relations between two collections types Strapi does not startup again, but crashes. 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. j 🙇‍♀️ Expected behavior/code. 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". Could you share how you are sending the file? Maybe the validator doesn't account for that format and we could refactor it. 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. 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. Oct 19, 2018 · You signed in with another tab or window. then start develop. 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. A proper issue submission let's us better understand the origin of your bug and therefore help you. 0 npm version: 5. 4 yarn run v1. Feb 28, 2020 · Oh wait a second, that paste didn't come from the branch I was running. Mar 30, 2024 · error: create index “components_readings_information_tp_informations_reference_cell_links_fk” on “public”. Nov 9, 2023 · Node. Thank you for reporting this bug, however we are unable to reproduce the issue you described given the information we have on hand. You signed in with another tab or window. “components_readings_information_tp_informations_referenc… debug: ⛔ Server wasn’t able to start properly. 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. By default, one of them named caching_sha2_password is used rather than our good old mysql_native_password. This did it for me. 11. $ yarn build yarn run v1. 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. env files. 15. 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. The entire process worked without any bigger issues and the app runs in production. 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. pzzl epsgxom oialibs cpkgvh fxupb sbca sht ocle yeel daqa kffu tupx wblum hmhyegb poodiwf