aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--models/issues/comment.go11
1 files changed, 8 insertions, 3 deletions
diff --git a/models/issues/comment.go b/models/issues/comment.go
index ce5cf5902d..ba5aed9c65 100644
--- a/models/issues/comment.go
+++ b/models/issues/comment.go
@@ -1161,9 +1161,14 @@ func DeleteComment(ctx context.Context, comment *Comment) error {
// UpdateCommentsMigrationsByType updates comments' migrations information via given git service type and original id and poster id
func UpdateCommentsMigrationsByType(ctx context.Context, tp structs.GitServiceType, originalAuthorID string, posterID int64) error {
_, err := db.GetEngine(ctx).Table("comment").
- Join("INNER", "issue", "issue.id = comment.issue_id").
- Join("INNER", "repository", "issue.repo_id = repository.id").
- Where("repository.original_service_type = ?", tp).
+ Where(builder.In("issue_id",
+ builder.Select("issue.id").
+ From("issue").
+ InnerJoin("repository", "issue.repo_id = repository.id").
+ Where(builder.Eq{
+ "repository.original_service_type": tp,
+ }),
+ )).
And("comment.original_author_id = ?", originalAuthorID).
Update(map[string]any{
"poster_id": posterID,