SiliconSatchel opened a new issue, #7752: URL: https://github.com/apache/incubator-devlake/issues/7752
### 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 I'm having some trouble with the "Component and File-Level Metrics" dashboard, none of the "file dimension" metrics are displaying properly.  In particular (I suspect the other metrics are having similar issues) the SQL query for files with maximum number of authors is erroring out, the Grafana pod logs give this error: ``` logger=tsdb.mysql endpoint=queryData pluginId=mysql dsName=mysql dsUID=P430005175C4C7810 uname=admin t=2024-07-15T17:32:42.710897017Z level=error msg="Query error" error="Error 3995 (HY000): Character set 'binary' cannot be used in conjunction with 'utf8mb4_unicode_ci' in call to regexp_like." ``` Going to the "explore" tab and manually querying: ``` SELECT * FROM commits ``` doesn't show any file_path column, which looks important for this dashboard. ### What do you expect to happen The "file dimension" metrics are displayed in the dashboard. ### How to reproduce - Deploy DevLake v1.0.1-beta2 using docker-compose. - Setup a project with a Gitlab connection scoped to one repository. - Open the "Component and File-Level Metrics" dashboard. ### Anything else I saw this bug on both v1.0.0 and v1.0.1-beta2. I asked about it in slack and was told to open an issue here. ### Version v1.0.1-beta2 ### 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
