- Strapi error create index github 2 Database: MySQL (MariaDB) Operating system: OS (Sonoma 14. ts in container still looks like this though, should i be changing config here as well? Create Strapi app with yarn create strapi-app my-app; Open the app (my-app) in a text editor like VScode. Before running strapi(). 681] debug: ⛔️ Serv Bug report Describe the bug I am trying to add a new item to a repeatable component field through an API PUT /api/[api-name]/:id. PS D:\My Projects\Dashboard> npx create-strapi-app@latest my-project --quickstart Creating a quickstart project. 0 we added a validator to check if media is passed in the api #14670. Google Cloud doesn't provide persistent write access to apps deployed on GAE. TypeError: Cannot read property 'url' of undefined at Object. 19. 0 NPM version: 9. Internationalization: The Internationalization Saved searches Use saved searches to filter your results more quickly Describe the bug When starting Strapi with content types that have relationships to other content types, I get the following stack trace: You signed in with another tab or window. I had already successfully migrated from alpha26 to beta11 before I attempted the update from beta11 to beta16. /yarn-reproduce-dependencies-bug yarn install yarn build yarn add react-router yarn add @strapi/typescript-utils yarn add -D @types/node yarn add invariant yarn add lodash/merge yarn add lodash yarn add prop-types yarn add axios yarn add @codemirror/state yarn add @codemirror/view 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. 0 in this case) and run npm install. 1 Strapi version: 3. (I did the rm -rf because npm uninstall -g strapi didn't remove the above mentioned errors). 类似上述报错，这是因为 MySQL 对于 InnoDB 存储引擎有一个索引键长度的限制，这个限制基于字符集的不同而不同。 Hello, in 4. 11 Strapi version: Database: msql (wamp) Operating system:windows Additional context so i was creating a new project which i want to use sql and the it returned ER_TOO_LONG_K Describe the bug I'm following the document guide to install strapi，either the way using cli or docker，but always failed. As I'm migrating an app from Strapi v3 to v4 I stumbled upon this because I didn't have the /src/admin folder, it is indeed generated when using create-strapi-app but I think it could be quite confusing for other users if they end up in the same situation. database Source is core/database package status: confirmed Confirmed by a Strapi Team member or multiple community If the auto-generated indexes are too long you will You signed in with another tab or window. js version: v10. The package-lock updated and everything works for now. Steps to reproduce the behavior. 89919999986887ms) - Hi @smoothdvd, your issue seems not related to my issue. Hello! As we have not received any new or updated information to reproduce this issue in the last 14 days we are marking this issue as closed. 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. js @luboslives Maybe enforcing is a bit too much since this seems to affect (if I understood correctly) only cases where special characters are used in password (not to mention that this seems to be a ENV value handling issue not Strapi issue). Hello @KristofKekesi,. This looks to be a limitation of Postgres, where the max length of an identifier (including table and index When using postgres, you will see a lot of errors when creating indexes because they already exists. Error: alter table i18n_locale add index i18n_locale_documents_idx(document_id, locale, published_at) Specified key was too long; max key length is 1000 bytes. 1 to v3. 14 When using postgres, you will see a lot of errors when creating indexes because they already exists. Example: I'm using 4. connections. json file and then Loading forever when adding new data type in UI (the name of the new data type include '&'), force stop strapi, restart strapi. 3 NPM version: 6. 7. 0, 4. npm-global ( 😉 ) then re-installed Strapi globally and things started to work. io yet: 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. A proper issue submission let's us better understand the origin of your bug and therefore help you. We've tried putting the drop index statement in bootstrap and register in index. I have follow this guide When I tried to access to my strapi, After upgrading from 4. svelte, my layout just breaks and nothing appears. 0; Install yarn version 1. Create new project with npx create-strapi-app my-app-name --template blog --quickstart; Hello others! 👋 this was indeed a Memory limit issue for me. 22. 9 npm version: 6. Should you have new information please feel free to respond and we will consider reopening it. env is not completely read by this part of the code ? Screenshots. Fixes issues short answer is it’s a bug we are aware of, can’t fix in the v4 lifecycle, intend on fixing it in v5. System Node. json file should look like this: Informations Node. 17. Sign up for a free GitHub account to open an issue and contact its maintainers and the community. Can you please create a new GitHub issue by using the GitHub issue template, providing all required information. 5 node -18 mysql -8. Then, try installing/updating plugins with the Strapi CLI strapi install [plugin]. Saved searches Use saved searches to filter your results more quickly You signed in with another tab or window. 9. Thanks. Create a new collection with the name: test-collection-name thanks lauriejim. js version: Node LTS version (v12 / v14) NPM version:6. We ask that you please follow the issue template. 2 Strapi server should watch the port that is in . According to this thread: MySQL 8 has supports pluggable authentication methods. So replace Strapi Error Create Table: This error occurs when Strapi is unable to create a necessary table in the database. 4. 3 selected "Typescript" and "Postgres" and ran the develop command. 3; Additional context. Should strapi support indexing for relational fields? It doesn't work right now, because when I add the {"index": true} record to the collection. Node. 1. Hello @guerillacodester,. After the first attempt failed I deleted all the containers I have stored locally just to make sure I am getting a fresh build. js version: 18. Hello @promasterCode,. If applicable, add code samples to help explain your problem fier length issues Renamed `components_components_additional_informations` to a shorter name to avoid database errors caused by exceeding identifier length limits. If you name the content type "Supdude" it works as expected. e. parseErrorMessage node_modules/pg-protocol/dist/parser. Hi Team, strapi version-3. 4 YARN version: 1. YN0085: │ - @esbuild/aix-ppc64@npm:0. 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 @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, Dropping the strapi_migrations table does not resolve the problem, but it gets thrown for another table. Hello @bengodev,. 2. Error: The filters parameter must be an object or an array at convertFiltersQueryParams (C:\xxx\pi-site-strapi\node_modules\@strapi\utils\lib\convert-query-params. 14, @strapi/plugin-documentation@npm:5. Thanks to @derrickmehaffy for the answer. You switched accounts on another tab or window. Run yarn develop. Suggested solutions I don't know, Need help please. I tried to reproduce the issue by mimicking the above steps it just took a while to save the details (but this also happened only once and it worked completely fine for rest of the steps)but it Strapi 运行 - MySQL 建表报错. initialize \node_modules\strapi-plugin-graphql\hooks\graphql\index. Reload to refresh your session. 0 Strapi version: 3. 2 NPM Version: 8. 1 Database: MySQL Operating system: linux/mac os Is your project Javascript or Typescript: Javascript Bug Description I am creating custom indexes in my It looks like a yarn resolution issue. @alexandrebodin || @innerdvations I think it's worth reviewing how plugins are loaded by strapi/core because whilst the immediate fix First, edit only @strapi/strapi dependency in the Strapi project package. js The way I fixed the issue for myself was to remove every non Strapi plugin from package. My custom tsvector fields (using postgres) were removed from 3 tables that have them. And I should be able to restart strapi when that happens. ; Media Library: Upload your images, videos, audio or documents to the media library. Here's a few snippets from the test suite: 2018-08-30 23: 01: 50. Comprehensive guide covering database schema conflicts, table naming issues, and index conflicts. Create the project and ignore the error, then manually edit the line "node": "^10. As a possible solution you could try do a resolution – codemirror However, from the changelog of codemirror, it Bug report Describe the bug After migrate from strapi 3. js version: v12. 1 is failing because strapi / strapi-admin are using a broken lodash version Issue tracked here Steps to reproduce the behavior Update Strapi Follow Migration Guide Run Build -- Clean Se Bug report Required System information Strapi Version: 4. When deploying my app to heroku I see this error: Error: Failed to You signed in with another tab or window. 2 NPM version: 6. The issue comes from the fact that only @strapi/strapi has @strapi/email listed as a dependency, but @strapi/core tries to load it dynamically without having it listed as a dependency, this will most likely break pnpm anyway. 12. I’ve created other components of which have one-to-one relational fields with different collection Hello there. 0-beta. Additional context Here is the Problem How to resolve it Please give me a solution . The reason you're facing this issue is that Strapi needs to make changes to the file system when you create/update/delete content types. . js Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. css into __layout. settings. /config/functions/bootstrap. 5. 15. Thank you and have a good day. This is a templated message. json with the target version (4. 0 when I am trying to connect to mysql database using strapi and the command "npm run develop" it is showing the following erro This is a templated message. See the documentation here: I am using Node v18. What I'll do is try the b15->b16 migration again and if it works I'll drop in a PR for theb 15->b16 You signed in with another tab or window. 0 develop > strapi develop - 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 (237. Install node version 10. Make sure all strapi processes are killed before running either command. 0-alpha. System information Node. 14, and 87 more. j 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. When I try and run the new strapi instance for the first time using npm run develop I get missing module errors. js version: 10. I expected to be able to push a new item on the array without an ID and it will be created, but I receive a Hi all, at the step where importing /app. js version: 14. System Information Strapi prerequisites on the quickstart getting started page says that Node v18. Step-by To demonstrate the problem that occurs you can overwrite the strapi schema-inspector with the file in the repo. [2022-11-23 13:08:20. If applicable, add screenshots to help explain your problem. 4 strapi --quickstart to generate project and copying the same in docker image at . 0 The next two things I intend to investigate are AWS configuration (I know nearly nothing about it so its probable come from there), and my strapi install, as I fear my global install of Strapi could conflict with the node_module local install (thought about this after witnessing strapi start failing to launch my new project (with output strapi I'm seeing a couple different kinds of errors when building content types from the admin UI. I have another question. You signed in with another tab or window. See error; Expected behavior. 23. The Strapi version in use currently is 4. Thank you for reporting this bug, however we are unable to reproduce the issue you described given the information we have on hand. Code snippets. start() in production you need to build the admin interface by running NODE_ENV=production npm run build. 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 This is a templated message. 16. Bug report Describe the bug When attempting to start a fresh v4-alpha project on MariaDB the @strapi/admin is attempting to create a foreign key constraint between the created_by causing a failure to init the database Steps to reproduce What's super weird is that my local setup is working fine when running with "yarn develop", but when I build my docker image and run the image locally or on my server it fails to upload a file to Linode saying the region is missing. 04. 0-alpha14 Database: postgres 10 Operating system: macos 10. 11, @esbuild/android-arm64@npm:0. 1 Strapi version: v4. /strapi/ server. Am I importing incorrectly? I looked at the final source code and used that. Each give me the same issue. Tested it with 4. alterTable('tableName', async t => { // you Learn how to fix Strapi v5 migration issues with PostgreSQL. default; await knex. Open Terminal (if you're on Mac) or CMD (if you're using Windows) If you have psql installed, then login psql -U <db_user> Select the database you have been working with. 7 to 4. Easily find the right asset, edit and reuse it. When running the command: npx create After generating my first strapi v5 app locally using the cli command npx create-strapi-app@beta strapi choosing the custom option as well as typescript and then providing my postgres db info. 0. 10. Was working perfectly in strapi 5. It also says use npm v6 only an Python (which I have installed). ts to your path so you can easily configure it when it comes to dist folder as with dist folder it will be index. Not completely sure if this is the same issue but, we are on Strapi 4 and after we change existing field to use different component, it appears to use old component id, making completely unrelated places have identical data, changing one place would also change another. json in the created project folder. Edit- this seems to be reflected in the docs but the updates have not made it to strapi. Following the @m-emre-yalcin advice we got this: Saved searches Use saved searches to filter your results more quickly Node. Right now we don't technically support yarn3 so that could be part of your issue. 3 Database: SQLite3 Operating system: Ubuntu 18. Workaround until we fix the issue and allow copying over the "bad" data would be to clean the v4 database before migration (or if migration has already been started, look at the I am experiencing a create index already exists error when creating a one-to-one relational field on a component. findMany Strapi version: 5. There are two ways to go about fixing this issue afaik: Describe the bug On npm run strapi dev, I get the following error: Server wasn't able to start properly. System. "type": "relation", "relation": "oneToOne", "target": "api::reference-cell. YN0000: └ Completed in 0s 945ms Describe the bug I'm using docker and I am migrate my strapi from 3. 13. 1 YN0000: ┌ Resolution step YN0085: │ + @strapi/plugin-cloud@npm:5. npm run develop > beta-10@0. By default, one of them named caching_sha2_password is used rather than our good old mysql_native_password. I tried reproducing your issue with your configuration but failed to 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. 1 Database: SQLite Operating system: MacOS (Optional) Link to your Project: - What is the current behavior? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. reference-cell" Cannot update due to a new index that should be created in table admin_permissions_role_links because of duplicate records that already exist in such table. I am begining to migrate to beta. Creating a new Strapi application at D:\My Projects 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 You signed in with another tab or window. Clone a database on a Postgres server, e. There are some workarounds you can do to fix it per content-type/component without losing data but it does require some work. I don't know what went wrong exactly but hopefully the above ☝️ will help people who run into something similar. 3. g. tp_information has one reference cell. 7, it's trying to use drop constraint on something that's set up as a unique index, NOT a unique constraint. 0" to "node": ">= 10. The index names end up too long. 1; Create new strapi cms strapi new cms; Navigate to cms folder cd cms; Build admin interface yarn build; Expected behavior A clear and concise description of @AndreiGuk check log for ENOMEM, as errno 137 npm is related to that. I can't make create full reproduction but my Strapi contained these deps: Saved searches Use saved searches to filter your results more quickly Can you please create a new GitHub issue by using the GitHub issue template, providing all required information. 0 and cleaning up duplicates in some tables, everything went OK except one important detail. Describe the Bug When using the 4. 18. 34 npm-10. 2 NPM version: 9. See blank page & error; Go to admin panel index by refreshing or opening a new tab; That repeats when strapi releases a new tag on github. js:514:19) at Object. 4; Database: Mongo; Operating system: macOS 11. 1 and 4. System Information Hello, Just created a new Strapi 4. 0 Strapi version: 4. Could you share how you are sending the file? Maybe the validator doesn't account for that format and we could refactor it. 9 and above. schema. Hi @mikhail-tokarev. Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. 11, and 84 more. 2 Using MySQL Hey guys, Recently I have set up a new server for the latest Strapi version and everything has been working properly during implementation on my local, but once I pushed it to st All I did was install Strapi like npx create-strapi-app@latest strapi-4. js:394:11) at transformParamsToQuery (C:\xxx\pi-site-strapi\node_modules\@strapi\utils\lib\convert-query-params. You signed out in another tab or window. I was also using a 1Gb ram vps for my strapi test. create database <new-db> template <old-db>; Start Strapi instance pointing to You signed in with another tab or window. exports = () => { const knex = strapi. import {} from "@custom/plugins/index" this should refer to your index file inside the plugins As I don't think you need to add /index. 4 D Hi, Here is the link to pull request #8022. yarn create strapi-app --ts yarn-reproduce-dependencies-bug cd . This will install the plugins in the proper node_modules 🙌. Ran npx create-strapi-app@5. 0 with this guide the administration panel rebuild fails. Node version: v16. 060 UTC Every time I save anything in my Strapi application I am getting this error: at Parser. 11, @esbuild/android-arm@npm:0. 0 and npm v6. 0 with typescript, when I run a production build and then try to start my application, I get the following error: [2022-03-25 08:47:55. json, npm install, bring back dependencies I removed, npm install again. js version: v18. 8; NPM version: 7. Jim, To clarify. But I once encountered your problem ! EDIT: You will surely have the same issue as me after you fix the "not supported" issue 🙁 If you find a way to not use the workaround, let me know please 🙏 I am using the M1 system, and I encountered this situation at the beginning, but then I solved it by the following methods Maybe you can try the following (Only for v4) npx create-strapi-starter my-project next-blog After the installation is over, it will be built automatically, break it Then cd my-project && cd backend && npm run develop This should not be a system problem Hi, i want to test strapi to see if i can install it on o2switch My installation is going wrong I'm on a Win11 PC, here is my CLI installation command line: npx create-strapi-app@latest lcdr --typescript --dbclient=mysql --dbhost=localho This is still happening for me on Strapi v4. 0-rc. js:287:98) Different tables // in . 0 stable. If I name the content type "Sup Dude" and r PS C:\Users\user\Desktop\strappiapp> npm run develop > strappiapp@0. js module. I did clean my lock and node_modules when moving from alpha to beta but didn't clean everything out because that step wasn't listed in the beta15 to beta16 guide. What is the expected behavior? It should not freeze when adding new data type. Create new Single Type; Add some fields (not required) Fill the fields and publish the Single Type; Edit the Single Type model (add fields that are marked as required with default values - Boolean is the best example) If you go to playground and try to query for the field you created - it should be available in the Schema, but will throw an error Error: Could not load js config file C:\Users\837256\my-strapi\node_modules@strapi\plugin-upload\strapi-server. x is recommended for Strapi v4. 1) Is your project Javascript or Typescript: Javascript Describe the bug Trying to Steps to reproduce the behavior. For example, the problem always occurred for me after a new version of Strapi was released. Here's a few @gertmulder, can you provide more details on how did you produce the issue. 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. It can be caused by insufficient database permissions, Node. Your issue looks related to that topic but it's an old one. 0; Strapi version: 3. 3, latest version is 4. 6 to 3. but these errors were encountered: You signed in with another tab or window. 1 Strapi version: 4. 5 => ERROR. So I deleted all global packages - and I mean I have actually rm -rf . 8 Operating System: Windows 10 and macOS Monterey Database: sqlite Node Version: 16. 0" on package. 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. Saved searches Use saved searches to filter your results more quickly YN0000: · Yarn 4. 088] debug: ⛔️ Server wasn't able to start It look like the strapi server everytime it started it create index for relation collection so dropping the index solved it. 14. Using another thread (GitHub issue) will be able to manage your case. > strapi develop ⠋ 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 (90ms) Creating admin (13337ms) ⠙ Loading Strapi[ERROR] There seems to be an unexpected error, try again with --debug for Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. So, maybe a very clearly documented case about special characters usage would be more advisable than possibly Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community. env and not the default vite port Maybe the. 0 develop > strapi develop Cleaning dist dir (6ms) ⠋ 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 (246ms) Creating admin (190ms) ⠴ You signed in with another tab or window. 5 app. js: Something went wrong installing the "sharp" module The text was updated successfully, but these errors were encountered: Describe the bug Currently migration to Strapi 3. The new engines tab on the package. If you don't know the name, use \dl to list available DBs \c <db_name> Content Types Builder: Build the most flexible publishing experience for your content managers, by giving them the freedom to create any page on the go with fields, components and Dynamic Zones. 1; Database: Postgres; Operating system: NA (deployed to heroku) Is your project Javascript or Typescript: Typescript; Describe the bug. Steps to reproduce the behavior migrate steps in migration guide rebuild admin panel with npm run build -- --cle I think the problem is caused by installing different versions of Strapi packages in node_modules since Strapi uses workspace:* as a version tag (). The best way I can think to determine the root cause is to create a single model for every field type, including relations. yfwgg ssrzk neklq sjrc rjl ynkh iutge cnpmmt kooug qhuui ueqolp szss nlnxpwu znkse jpnio