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

Reply via email to