Strapi error create index github. json in the created project folder.
Strapi error create index github By the way, as a quick fix, after removing a unique field the developer can manually remove the related index. pages>'. Oct 20, 2020 · Saved searches Use saved searches to filter your results more quickly Oct 16, 2023 · [2023-10-16 16:15:11. 6 to 3. Aug 3, 2022 · Create a couple of components and use it in a model (so strapi would create link between them and create index). Anyway, closing as this isn't a bug. Apr 1, 2020 · Describe the bug After upgrading to 3. System Node. Fixes issues related to Strapi's database schema constraints. 0-alpha14 Database: postgres 10 Operating system: macos 10. If you have problems with the dependency might be because some caching or node_modules stuff Apr 21, 2019 · node 10. 👩💻 Environment. This is a templated message Oct 20, 2020 · You signed in with another tab or window. 5 to v4. 758Z] debug ⛔️ Server wasn't able to start properly. When doing so, the submit button does not seem to respond, when looking at the respons Nov 18, 2022 · I've migrated from Strapi v4. 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 Nov 5, 2024 · This is a templated message. 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. g. 📦 Node version: v21. create database <new-db> template <old-db>; Mar 14, 2024 · 🙇♀️ Expected behavior/code. Could you share how you are sending the file? Maybe the validator doesn't account for that format and we could refactor it. Then now I'm trying to add my Feb 17, 2022 · Saved searches Use saved searches to filter your results more quickly Mar 14, 2024 · 🙇♀️ Expected behavior/code. 0" to "node": ">= 10. 18. I'm trying to install i18n in those models. [2021-04-12T12:51:47. 13. 4 yarn run v1. It fails to start: yarn workspace v1. 0). strapi/strapi#12101 Nov 5, 2019 · Describe the bug A clear and concise description of what the bug is. Hello @andriichekhomskyi,. 1 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. 0; Strapi version: 3 Sep 13, 2020 · issue: bug Issue reporting a bug severity: low If the issue only affects a very niche base of users and an easily implemented workaround can solve source: core:upload Source is core/upload package status: confirmed Confirmed by a Strapi Team member or multiple community members 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. After using the Codemods to convert our models to the v4 format, when starting Strapi with an empty db, it fails because some table names, some column names or some foreign key identifiers are too long, because Strapi prepends a bunch of stuff (like _links_inv_fk Apr 3, 2024 · yarn run v1. 1 Apr 1, 2012 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. js Mar 6, 2011 · You signed in with another tab or window. 15. 0 project to 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. 12. 0 with this guide the administration panel rebuild fails. 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. Oct 16, 2019 · npx create-strapi-app my-project; Choose MySQL as Database; Insert Credentials; Choose "No" for SSL; run "strapi start" or "npm run start" Expected behavior Admin Panel should show up. You signed in with another tab or window. Could you give me an example on how to do so? Jun 5, 2019 · You signed in with another tab or window. You switched accounts on another tab or window. Clone a database on a Postgres server, e. You can use npm run setup in the project folder, to create the sapper . Reload to refresh your session. Feb 18, 2021 · Bug report Describe the bug After migrate from strapi 3. Oct 28, 2020 · 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 Nov 9, 2023 · Node. 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. A proper issue submission let's us better understand the origin of your bug and therefore help you. com/strapi/strapi Jan 2, 2024 · 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" In my project i have challenge collection which has relation with user collection several times under different field names,the Aug 30, 2018 · Node. ts I use this code: strapi. 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. j Aug 11, 2020 · Basic installation of strapi; Connect the database to Postgresql; Create a Collection called resources with a json field called tags. initialize \node_modules\strapi-plugin-graphql\hooks\graphql\index. 7 Database: PostgreSQL Operating system: Ubuntu Describe the Mar 20, 2022 · System Information Hello, Just created a new Strapi 4. Sep 20, 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. Hello @KristofKekesi,. Steps to reproduce the behavior I configure an unique field in src/index. 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. This command will not change other values in your . 19 $ strapi May 26, 2020 · Describe the bug On npm run strapi dev, I get the following error: Server wasn't able to start properly. 4 $ strapi develop [2021-04-23T07 Dec 8, 2019 · You signed in with another tab or window. System. I’ve created other components of which have one-to-one relational fields with different collection types. Hello, please follow the issue template. com/strapi/strapi Jan 22, 2018 · Bug report When generating new Content Type for a Plugin via CLI, the automatically added routes factory file breaks the plugin and crashes the application. Jun 8, 2023 · The updateSchema function tries to add indexes that already exist because it thinks something has changed. 5 app. Database migration script worked right. 3 NPM version: 6. Apr 1, 2012 · Dropping the strapi_migrations table does not resolve the problem, but it gets thrown for another table. tp_information has one reference cell. I’ve created a component tp-information under readings-information and on that component I’ve tried to create a one-to-one relational field called reference-cell i. 📦 Node version: v20. js version: 14. 4 D Saved searches Use saved searches to filter your results more quickly Jan 2, 2024 · This is a templated message. Thank you for reporting this bug, however we are unable to reproduce the issue you described given the information we have on hand. TypeError: Cannot read property 'url' of undefined at Object. Basically it requires the use of patch-package and for those who don't want to wait and see how it's done you can check out this repo I made a while back on how it works (it was made for v3, not v4 but the core logic remains the same, you are editing the file in node_modules Aug 24, 2023 · If I understand it correct strapi creates for relation fields two index on the db they end with: _fk _inv_fk; When the overall index name is to long the endings are removed by the trucating and strapi tries to create two index with the same name. 2 NPM version: 9. But when I want to start strapi I see this error: error: alter table `kindergartens_components` add unique `kindergartens_unique`(`entity_id`, `componen Apr 12, 2021 · Bug report Describe the bug I created two collections named "categories" and "category" successfully, but errors occurred after restarting server. x to 5. 4 YARN version: 1. 2 Database: MySQL (MariaDB) Operating system: OS (Sonoma 14. 26. So one side holds the mappedBy attribute and the other inversedBy. 0-beta. Breaking changes at mount-models. 4, strapi-connector-mongoose started to remove manually created indexes at launch point. js version: v18. Run yarn develop. Jun 12, 2020 · thanks lauriejim. js version: 10. When opening Strapi for the first time you need to register your super admin. 1) Is your project Javascript or Typescript: Javascript Describe the bug Trying to upgrade a 4. Dec 10, 2019 · You signed in with another tab or window. json in the created project folder. Nov 9, 2023 · Type '{ localizations: { select: string[]; }; }' is not assignable to type 'Any<CollectionTypes. js version: 12; NPM version: 6. 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. env files. 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". 15 Strapi version: 4. 3; NPM version: 6. 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. Dec 6, 2021 · Saved searches Use saved searches to filter your results more quickly Jun 25, 2019 · Create the project and ignore the error, then manually edit the line "node": "^10. Create a new collection with the name: test-collection-name Bug report Required System information Strapi version: 4. Oct 3, 2024 · Strapi 5 migration, unable to create index because it already exists #21583 Closed derrickmehaffy opened this issue Oct 3, 2024 · 2 comments · Fixed by #21588 Jun 14, 2015 · Bug report Required System information Node. Mar 3, 2022 · Saved searches Use saved searches to filter your results more quickly Feb 10, 2022 · You signed in with another tab or window. Nov 12, 2020 · You signed in with another tab or window. 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. even if the field is configured to be unique. Feb 20, 2020 · You signed in with another tab or window. 2 NPM version: 6. lifecycles. 0 Strapi version: 3. We ask that you please follow the issue template. The new engines tab on the package. 0. x. js: // Ensure indexes are synced with the model, prevent duplicat 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. Mar 30, 2024 · Names are too long, it’s an issue we are aware of and cannot fix in Strapi 4. js version: v12. 1 . 0-alpha. json file should look like this: Jun 14, 2018 · You signed in with another tab or window. After changing the relations between two collections types Strapi does not startup again, but crashes. Screenshots. 5. 22. 1 npm 6. The index names end up too long. 7. 0" on package. I have resolved the issue last evening after many trials and efforts - I had uninstalled Strapi but was still having a problem and after repeating the install I was finally able to move on. github. May 9, 2019 · Informations Node. Steps to reproduce the behavior. 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). Node. 21 $ strapi develop Cleaning dist dir (4ms) ⠋ 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 (39ms) ⠙ Creating adminRe-optimizing dependencies because lockfile has changed Mar 4, 2020 · Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. If you run this command on an existing strapi instance your backend and frontend strapi users will need to sign in again. Jan 4, 2022 · …fier length issues Renamed `components_components_additional_informations` to a shorter name to avoid database errors caused by exceeding identifier length limits. 9; Database: MongoDB; Operating system: Ubuntu; Suggested solution. 0 Strapi version: 4. Oct 3, 2023 · Cancel Create saved Sign up for a free GitHub account to open an issue and contact its maintainers and the community. 25. 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. See error; Expected behavior. "reference_cell Jan 22, 2019 · Tried the migrations on a totally isolated environment (Strapi running locally over a Dockerized Postgres with a copy of the production database). Removing a field from a Mongoose model doesn't affect the database so Strapi should also remove the unneeded indexes from DB. Jun 14, 2015 · That wasn't a restriction in v3, apparently. env file with the JWT_SECRETs it needs. db. 2 Database: Mongo Operating system: Debian What is the current behavior? Setting CORS Origin to anything othe May 9, 2022 · You signed in with another tab or window. 035Z] warn The bootstrap function is taking unusually long to execute (3500 Feb 28, 2020 · Oh wait a second, that paste didn't come from the branch I was running. May 9, 2020 · Hello there. 14 When using postgres, you will see a lot of errors when creating indexes because they already exists. 4. 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 You signed in with another tab or window. I was able to install the new packages and rebuild the admin panel successf Dec 22, 2021 · This is a templated message. 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. js version: NPM version: Strapi version: Database: Operating system: (Optional) Link to your Project: What is the current behavior? Dec 31, 2021 · Create Strapi app with yarn create strapi-app my-app; Open the app (my-app) in a text editor like VScode. 1 Strapi version: 3. Jan 28, 2023 · You signed in with another tab or window. 26 Informations Node. 2. I just made npm start in my new strapi project and when the browser opens there is a blank screen with a message that says: Not Found Also, in the console says: Error: ENOENT: No such file or directory, open '/build/index Jan 6, 2022 · @kasonde, I used the strapi starter with next-blog. Possibly this had something to do with the User collection type. env and create/update the strapi . According to this thread: MySQL 8 has supports pluggable authentication methods. Dec 9, 2022 · Some context: For bidirectional relationships Strapi uses mappedBy and inversedBy (see docs). . please try there. Steps to reproduce the behavior migrate steps in migration guide rebuild admin panel with npm run build -- --cle Jul 23, 2020 · Describe the bug Using a new DigitalOcean Droplet with the Strapi image. 4 Saved searches Use saved searches to filter your results more quickly 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 Apr 23, 2021 · Bug report Describe the bug I am running models from a plugin. Steps to reproduce the behavior Try to create a fresh install with Mongo Expected behavior ⛔️ Connection test failed: Co. You signed out in another tab or window. 19. Jun 1, 2023 · Saved searches Use saved searches to filter your results more quickly Aug 21, 2019 · Strapi version: 3. 4+, Database: Postgres Operating system: Linux Is your project Javascript or Typescript: Javascript Apr 12, 2022 · Hello, we're currently trying to migrate from v3 to v4. The fix I arrived at was temporarily reverting to the v3 version, running strapi to generate the tables, restoring the v4 version, and then running that. Jan 22, 2019 · Saved searches Use saved searches to filter your results more quickly Nov 1, 2023 · This is a templated message. Code snippets If applicable, add code samples to help explain your problem. 1 strapi 3. Nov 14, 2023 · @franckadil I'm sorry we can't help you on our side, but the aws-s3 dependency doesn't exist anymore on 4. Hello @promasterCode,. Steps to reproduce the behavior do the Quickstart command to create a Strapi project instantly: Go to 'do the command npm develo Oct 19, 2018 · You signed in with another tab or window. 1 I installed nodejs v12. You appear to be missing the ADMIN_JWT_SECRET for the Admin Panel authentication, please follow the bug report and we can try to assist you. $ yarn build yarn run v1. Describe the bug yarn/npx create-app project-name is not working with Mongo. 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. Types of property 'localizations' are incompatible. Feb 28, 2023 · Hello, in 4. subscribe({ // models: [], // optional; Jan 12, 2019 · You signed in with another tab or window. 🙇♀️ Expected behavior/code. It has already been fixed in Strapi 5 beta. A clear and concise description of what you expected to happen (or code). 11. By default, one of them named caching_sha2_password is used rather than our good old mysql_native_password. 0 we added a validator to check if media is passed in the api #14670. e. Sep 10, 2022 · Core controllers only exist for content types, you can still create custom controllers using the alternative syntax. Nov 4, 2020 · You signed in with another tab or window. This works perfectly, everything about it is good. js:16:48) at Array. 1. We do have some collectionNames/tables that are close to 64 chars in length. 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. 14. filter (<anonymous>) at <my project path>\node_modules\@strapi\strapi\dist Mar 30, 2024 · Names are too long, it’s an issue we are aware of and cannot fix in Strapi 4. 16. Feb 9, 2022 · Describe the bug. Oct 13, 2023 · Describe the bug I have duplicates. 9 npm version: 6. It thinks that something has changed because the indexes from the DBschema don't match the ones from the strapi schema: `` //DBschema {columns: [ 'path_id' ], name: 'upload_folders_path_id_index', type: null} // Strapi schema This isn't really a bug but I'd like to write up a quick guide for this on our documentation on how to add new locales. 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 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. apf zmwsqnr qlhhfl frfomb tjoku yvgl iyasxmv jszqflq rsefu onwmjc qeorq bcahc tlorah njcrfev xhvnov