dbzeekr opened a new issue, #8380: URL: https://github.com/apache/incubator-devlake/issues/8380
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened Using version v1.0.2-beta6, clicking the Edit Scope Config button in UI returns 500. This happens for Gitlab and Jira connection, probably others too, but those are the ones I tested. ` Request URL: https://devlake.removed.eu/api/plugins/gitlab/scope-config/6/projects Request Method: GET Status Code: 500 ` **Internal Log** `[GIN] 2025/04/11 - 13:40:15 | 200 | 1.6µs | 10.100.144.164 | GET "/ping" │ │ time="2025-04-11 13:40:18" level=info msg="\x1b[31;1m/app/impls/dalgorm/dalgorm.go:209 \x1b[35;1mError 1064 (42000): You have an error in your SQL syntax; check the manual that correspon │ │ │ │ │ │ 2025/04/11 13:40:18 [Recovery] 2025/04/11 - 13:40:18 panic recovered: │ │ [GIN] 2025/04/11 - 13:40:18 | 500 | 13.013278ms | 10.0.254.7 | GET "/plugins/gitlab/scope-config/6/projects" │ │ GET /plugins/gitlab/scope-config/6/projects HTTP/1.1 │ │ Host: devlake-lake.devlake.svc.cluster.local:8080 │ │ Accept: application/json, text/plain, */* │ │ Accept-Encoding: gzip, deflate, br, zstd │ │ Accept-Language: en-US,en;q=0.7 │ │ Priority: u=1, i │ │ Referer: https://devlake.removed.eu/projects/ads/gitlab-3 │ │ Sec-Ch-Ua: "Brave";v="135", "Not-A.Brand";v="8", "Chromium";v="135" │ │ Sec-Ch-Ua-Mobile: ?0 │ │ Sec-Ch-Ua-Platform: "macOS" │ │ Sec-Fetch-Dest: empty │ │ Sec-Fetch-Mode: cors │ │ Sec-Fetch-Site: same-origin │ │ Sec-Gpc: 1 │ │ User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 │ │ X-Envoy-External-Address: 10.0.254.7 │ │ X-Forwarded-For: 10.0.254.7 │ │ X-Forwarded-Proto: https │ │ X-Request-Id: 47706616-1d7e-4935-8923-2f796cd08096 │ │Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar) = bps.scope_id) WHERE │ │ Wraps: (2) Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar) = bps.scope │ │ Error types: (1) *hintdetail.withDetail (2) *mysql.MySQLError │ │ /app/core/errors/util.go:34 (0x7f6a5322676a) │ │ /app/helpers/srvhelper/scope_config_service_helper.go:80 (0x7f6a53225d69) │ │ /app/helpers/pluginhelper/api/ds_scope_config_api_helper.go:66 (0x7f6a53224625) │ │ /app/plugins/gitlab/api/scope_config_api.go:96 (0x7f6a53222273) │ │ /app/server/api/router.go:141 (0x1613e6e) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x1611c82) │ │ /app/server/api/middlewares.go:95 (0x1611c66) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x1612127) │ │ /app/server/api/middlewares.go:117 (0x1611fc2) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x12532a1) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/recovery.go:102 (0x125328c) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x12523c6) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/logger.go:240 (0x12523a9) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/context.go:174 (0x125124a) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/gin.go:620 (0x1250ed1) │ │ /go/pkg/mod/github.com/gin-gonic/gin@v1.9.1/gin.go:576 (0x12509fc) │ │ /usr/local/go/src/net/http/server.go:2936 (0xce25b5) │ │ /usr/local/go/src/net/http/server.go:1995 (0xcdd751) │ │ /usr/local/go/src/runtime/asm_amd64.s:1598 (0x9ccf40) │ │` ### What do you expect to happen I expect the Scope Config to be Editable and the server not to panic. ### How to reproduce Add a scope config, and then attempt to edit it from the UI. ### Anything else _No response_ ### Version v1.0.2-beta6 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
