yusufsyaifudin opened a new issue, #7440: URL: https://github.com/apache/incubator-devlake/issues/7440
### 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 am using Postgres as my database and connect to one of my repositories in Bitbucket, but during sync I found this error <img width="1453" alt="image" src="https://github.com/apache/incubator-devlake/assets/1698600/242473da-8dff-47e5-9d2f-9acb5956af31"> I am sure that it is triggered by this code: https://github.com/apache/incubator-devlake/blob/v1.0.0-beta6/backend/server/services/task.go#L309 This happened because Postgres doesn't support compare boolean in column `is_collector` with operator `= 1`. ### What do you expect to happen It should not break both for Postgres and MySQL. ### How to reproduce Install Devlake and Devlake Config UI version v1.0.0-beta6, using Postgres as database. ### Anything else _No response_ ### Version v1.0.0-beta6 ### Are you willing to submit PR? - [X] 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