[Bug][Pager Duty] Not able to delete the Pager Duty connection about incubator-devlake HOT 1 CLOSED

Hey @karthikbhat0307! I'm a bot designed to help you with bugs, questions, and becoming a contributor to the project. I'm here to assist you while you wait for a human maintainer.

To resolve the error "Unknown column 'connection_id' in 'where clause'" when trying to delete a PagerDuty connection, you need to ensure that the connection_id column exists in the _tool_pagerduty_scope_configs table in your database schema.

The error occurs in the following part of the deleteConnection method in the ConnectionApiHelper class:

count := errors.Must1(c.db.Count(dal.From(scopeModel.TableName()), dal.Where("connection_id = ?", connectionId)))

and

err = CallDB(c.db.Delete, scopeConfigModel, dal.Where("connection_id = ?", connectionId))

These lines assume that the connection_id column exists in the _tool_pagerduty_scope_configs table. You need to verify that this table has the connection_id column. If it does not, you need to add the column to the table.

Here is an example of how you might add the connection_id column to the _tool_pagerduty_scope_configs table in SQL:

ALTER TABLE _tool_pagerduty_scope_configs ADD COLUMN connection_id BIGINT;

Additionally, ensure that the _tool_pagerduty_connections table has the connection_id column as well. If not, you can add it using the following SQL command:

ALTER TABLE _tool_pagerduty_connections ADD COLUMN connection_id BIGINT;

If the connection_id column is already present, ensure that the column name is correctly spelled and matches the column name used in the dal.Where clause ^[1][2][3].

To continue talking to Dosu, mention @dosu.

from incubator-devlake.