dosubot[bot] commented on issue #8545: URL: https://github.com/apache/incubator-devlake/issues/8545#issuecomment-3204302385
<!-- Greeting --> Hi @rifat-tfs! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the incubator-devlake team. <!-- Answer --> The error happens because the Jira plugin tries to insert a field name from a Jira issue changelog into the `field` column of the `jira_issue_changelogs` table, which is defined as `varchar(255)`. If Jira returns a field name longer than 255 characters (possible with custom fields), MySQL rejects the row and you get this error. There’s currently no trimming or resizing of this value before insertion, and no config or code path in v1.0.2 to handle it automatically. To resolve this, you can either: 1. Increase the column length in your database migration/model (e.g., to `varchar(500)`), but keep in mind MySQL index length limits if the column is indexed ([see discussion](https://github.com/apache/incubator-devlake/issues/8471)). 2. Implement string trimming in the extraction code so values longer than 255 characters are truncated before insertion ([recommended approach](https://github.com/apache/incubator-devlake/issues/8325)). Let me know if you want details on how to make either change! <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/5c308c42-5fae-4afe-b19e-3eb7961e5198?feedback_type=other)</sup> [](https://app.dosu.dev/b4e8e847-d479-4541-83a8-d88d83fea5c9/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/incubator-devlake/issues/8545) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
