dougludlow commented on issue #8281: URL: https://github.com/apache/incubator-devlake/issues/8281#issuecomment-2685713617
Ran into the same error when attempting edit the scope the config, using `v1.0.2-beta6` of the helm chart. log in the container: ``` time="2025-02-26 10:12:02" 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 corresponds to your MySQL server version for the right syntax to use near 'varchar) = bps.scope_id) WHERE bps.plugin_name = ? AND bps.connection_id = ?' at line 1\n\x1b[0m\x1b[33m[0.660ms] \x1b[34;1m[rows:0]\x1b[0m SELECT bp.id AS blueprint_id, bp.project_name, bps.scope_id, _tool_github_repos.* FROM _devlake_blueprint_scopes bps LEFT JOIN _devlake_blueprints bp ON (bp.id = bps.blueprint_id) LEFT JOIN _tool_github_repos ON (_tool_github_repos.connection_id = bps.connection_id AND cast(_tool_github_repos.github_id as varchar) = bps.scope_id) WHERE bps.plugin_name = 'github' AND bps.connection_id = 1" [GIN] 2025/02/26 - 10:12:02 | 500 | 8.215121ms | 10.16.216.98 | GET "/plugins/github/scope-config/1/projects" 2025/02/26 10:12:02 [Recovery] 2025/02/26 - 10:12:02 panic recovered: GET /plugins/github/scope-config/1/projects HTTP/1.1 Host: devlake-9a3cc686-lake.devlake.svc.cluster.local:8080 Accept: application/json, text/plain, */* Accept-Encoding: gzip, deflate, br, zstd Accept-Language: en-US,en;q=0.9 Referer: http://localhost:4000/projects/Swell/github-1 Sec-Ch-Ua: "Not(A:Brand";v="99", "Google Chrome";v="133", "Chromium";v="133" Sec-Ch-Ua-Mobile: ?0 Sec-Ch-Ua-Platform: "macOS" Sec-Fetch-Dest: empty Sec-Fetch-Mode: cors Sec-Fetch-Site: same-origin User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36 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 bps.plugin_name = ? AND bps.connection_id = ?' at line 1 (500) 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_id) WHERE bps.plugin_name = ? AND bps.connection_id = ?' at line 1 Error types: (1) *hintdetail.withDetail (2) *mysql.MySQLError /app/core/errors/util.go:34 (0x7f1c3535a0ca) /app/helpers/srvhelper/scope_config_service_helper.go:80 (0x7f1c353596e9) /app/helpers/pluginhelper/api/ds_scope_config_api_helper.go:66 (0x7f1c35357fc5) /app/plugins/github/api/scope_config_api.go:96 (0x7f1c35355b13) /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) ``` -- 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
