Strapi error create index github. Database migration script worked right.

Strapi error create index github Anyway, closing as this isn't a bug. 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. 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. 1 Strapi version: 3. A proper issue submission let's us better understand the origin of your bug and therefore help you. 0). 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. ts I use this code: strapi. 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. 4 YARN version: 1. 26 Informations Node. Feb 9, 2022 · Describe the bug. 1 . Describe the bug yarn/npx create-app project-name is not working with Mongo. So one side holds the mappedBy attribute and the other inversedBy. 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. 4. 3 NPM version: 6. 12. Nov 4, 2020 · You signed in with another tab or window. Removing a field from a Mongoose model doesn't affect the database so Strapi should also remove the unneeded indexes from DB. May 9, 2019 · Informations Node. 5 to v4. 1) Is your project Javascript or Typescript: Javascript Describe the bug Trying to upgrade a 4. System Node. 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. 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. 0" to "node": ">= 10. 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. 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. x to 5. Jan 28, 2023 · You signed in with another tab or window. 15. 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. 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. 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. Oct 20, 2020 · Saved searches Use saved searches to filter your results more quickly Oct 16, 2023 · [2023-10-16 16:15:11. Jun 8, 2023 · The updateSchema function tries to add indexes that already exist because it thinks something has changed. 4, strapi-connector-mongoose started to remove manually created indexes at launch point. create database <new-db> template <old-db>; Mar 14, 2024 · 🙇‍♀️ Expected behavior/code. 16. Types of property 'localizations' are incompatible. 25. 26. js version: 12; NPM version: 6. Sep 10, 2022 · Core controllers only exist for content types, you can still create custom controllers using the alternative syntax. 📦 Node version: v21. 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. Mar 30, 2024 · Names are too long, it’s an issue we are aware of and cannot fix in Strapi 4. 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. 0 we added a validator to check if media is passed in the api #14670. 0 Strapi version: 4. You signed in with another tab or window. initialize \node_modules\strapi-plugin-graphql\hooks\graphql\index. Node. github. 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. May 9, 2020 · Hello there. lifecycles. 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. 0" on package. 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. 15 Strapi version: 4. . Hello, please follow the issue template. js version: v18. A clear and concise description of what you expected to happen (or code). 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. Database migration script worked right. 14 When using postgres, you will see a lot of errors when creating indexes because they already exists. By the way, as a quick fix, after removing a unique field the developer can manually remove the related index. Apr 1, 2012 · Dropping the strapi_migrations table does not resolve the problem, but it gets thrown for another table. env file with the JWT_SECRETs it needs. You switched accounts on 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. "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). Create a new collection with the name: test-collection-name Bug report Required System information 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. Dec 10, 2019 · You signed in with another tab or window. By default, one of them named caching_sha2_password is used rather than our good old mysql_native_password. 5 app. See error; Expected behavior. 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. 7 Database: PostgreSQL Operating system: Ubuntu Describe the Mar 20, 2022 · System Information Hello, Just created a new Strapi 4. 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. 4 $ strapi develop [2021-04-23T07 Dec 8, 2019 · You signed in with another tab or window. 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). Clone a database on a Postgres server, e. 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. please try there. 14. 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. Apr 1, 2020 · Describe the bug After upgrading to 3. 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. 5. 1 I installed nodejs v12. Hello @andriichekhomskyi,. 0 Strapi version: 3. 2 Database: MySQL (MariaDB) Operating system: OS (Sonoma 14. Dec 9, 2022 · Some context: For bidirectional relationships Strapi uses mappedBy and inversedBy (see docs). I'm trying to install i18n in those models. db. 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. 9; Database: MongoDB; Operating system: Ubuntu; Suggested solution. 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. 6 to 3. $ yarn build yarn run v1. 4 yarn run v1. 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. 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. 2 NPM version: 6. Breaking changes at mount-models. Jun 12, 2020 · thanks lauriejim. 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. js version: 10. TypeError: Cannot read property 'url' of undefined at Object. 0. Hello @KristofKekesi,. This command will not change other values in your . Steps to reproduce the behavior Try to create a fresh install with Mongo Expected behavior ⛔️ Connection test failed: Co. 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. This is a templated message Oct 20, 2020 · You signed in with another tab or window. 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. I was able to install the new packages and rebuild the admin panel successf Dec 22, 2021 · This is a templated message. 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. When opening Strapi for the first time you need to register your super admin. j Aug 11, 2020 · Basic installation of strapi; Connect the database to Postgresql; Create a Collection called resources with a json field called tags. Code snippets If applicable, add code samples to help explain your problem. Screenshots. 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. Hello @promasterCode,. Nov 12, 2020 · You signed in with another tab or window. 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. 1 npm 6. 7. Oct 13, 2023 · Describe the bug I have duplicates. 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. Steps to reproduce the behavior. 1. 19. 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. js version: 14. e. The index names end up too long. Jun 1, 2023 · Saved searches Use saved searches to filter your results more quickly Aug 21, 2019 · Strapi version: 3. 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. We ask that you please follow the issue template. 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. x. json file should look like this: Jun 14, 2018 · You signed in with another tab or window. 2. subscribe({ // models: [], // optional; Jan 12, 2019 · You signed in with another tab or window. Run yarn develop. js:16:48) at Array. 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. 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. After changing the relations between two collections types Strapi does not startup again, but crashes. 13. 4 D Saved searches Use saved searches to filter your results more quickly Jan 2, 2024 · This is a templated message. System. 3; NPM version: 6. tp_information has one reference cell. The new engines tab on the package. Steps to reproduce the behavior I configure an unique field in src/index. [2021-04-12T12:51:47. Possibly this had something to do with the User collection type. Feb 18, 2021 · Bug report Describe the bug After migrate from strapi 3. 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. g. 0-alpha. Reload to refresh your session. 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. Feb 28, 2023 · Hello, in 4. Jun 14, 2015 · That wasn't a restriction in v3, apparently. It fails to start: yarn workspace v1. 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. 18. 📦 Node version: v20. 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. 0 with this guide the administration panel rebuild fails. This works perfectly, everything about it is good. According to this thread: MySQL 8 has supports pluggable authentication methods. env files. 9 npm version: 6. 👩‍💻 Environment. 🙇‍♀️ Expected behavior/code. 22. 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. Fixes issues related to Strapi's database schema constraints. It has already been fixed in Strapi 5 beta. even if the field is configured to be unique. If you have problems with the dependency might be because some caching or node_modules stuff Apr 21, 2019 · node 10. 0-alpha14 Database: postgres 10 Operating system: macos 10. env and create/update the strapi . strapi/strapi#12101 Nov 5, 2019 · Describe the bug A clear and concise description of what the bug is. You signed out in another tab or window. 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. Jan 22, 2019 · Saved searches Use saved searches to filter your results more quickly Nov 1, 2023 · This is a templated message. 2 NPM version: 9. If you run this command on an existing strapi instance your backend and frontend strapi users will need to sign in again. 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. 1 strapi 3. 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. 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. json in the created project folder. pages>'. Nov 9, 2023 · Type '{ localizations: { select: string[]; }; }' is not assignable to type 'Any<CollectionTypes. Feb 20, 2020 · You signed in with another tab or window. 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-beta. 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: v12. 758Z] debug ⛔️ Server wasn't able to start properly. Thank you for reporting this bug, however we are unable to reproduce the issue you described given the information we have on hand. 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. 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. 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. We do have some collectionNames/tables that are close to 64 chars in length. js Mar 6, 2011 · You signed in with another tab or window. 11. You can use npm run setup in the project folder, to create the sapper . I’ve created other components of which have one-to-one relational fields with different collection types. lein vmju ggctb inohuv rvncme gji oqabgv obfh darqyse npzdf ntkb dccxz zqkpl uqy vfbrrw