dosubot[bot] commented on issue #7983:
URL:
https://github.com/apache/incubator-devlake/issues/7983#issuecomment-2315201658
<!-- Answer -->
To resolve the "Error 1054: Unknown column 'db.dora_report' in 'where
clause'" when extracting DORA metrics in version v0.17.0-beta2, you need to
ensure that the `dora_report` column exists in the `dora_benchmarks` table. The
error indicates that the column `db.dora_report` is not found in the table
schema.
Here is the relevant part of the SQL query causing the issue:
```sql
and db.dora_report = ('$dora_report')
```
To fix this, you should check the schema of the `dora_benchmarks` table and
add the `dora_report` column if it does not exist. You can do this by running
the following SQL command:
```sql
ALTER TABLE dora_benchmarks ADD COLUMN dora_report VARCHAR(255);
```
This command will add a new column named `dora_report` to the
`dora_benchmarks` table, which should resolve the error
<sup>[[1]](https://github.com/apache/incubator-devlake/blob/main/grafana/dashboards/DORAByTeam.json)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
