arcam-inc / gitwork-community

https://gitwork.jp
0 stars 0 forks source link

ユーザー評価画面でシステムエラー #30

Closed uedayuji closed 4 weeks ago

uedayuji commented 1 month ago

背景

ユーザーの評価画面でシステムエラーが発生する Image

ログ

api-1  | 2024/09/07 04:07:55 /go/src/api/domain/repository/common/user_review_repository.go:117 Error 1054 (42S22): Unknown column 'projects.private' in 'where clause'
api-1  | [3.056ms] [rows:0] SELECT * FROM `tasks` WHERE tasks.status != 0 OR (tasks.private = 0 AND projects.private = 0) OR (tasks.private = 1 AND tasks.project_id in (SELECT `project_id` FROM `project_users` WHERE project_users.user_id = '01J120PCQ45EDZWH33DBPFTQEQ' AND project_users.status = 1 AND project_users.phase in (1,3))) OR (projects.private = 1 AND projects.id in (SELECT `project_id` FROM `project_users` WHERE project_users.user_id = '01J120PCQ45EDZWH33DBPFTQEQ' AND project_users.status = 1 AND project_users.phase in (1,3))) OR tasks.assign_user_id = '01J120PCQ45EDZWH33DBPFTQEQ' AND `tasks`.`id` IN ('01J3W9P3YT93213A69GMM6BCRV','01J3VPJYR1PAZ4YT27P9JVP17N','01J3VNCDX7R3QVW8HX5ACM4J24','01J3VMEBDJ3H1VGQ7HRB1ESHY4','01J3VMB5WX8MJHRX86M4D89V1Q','01J3VM1WTTNAP88B93KRSCGQ67','01J3VKHTBX6AYFFHGNRGWQQ113','01J3VHP44MNBJEPG2E1XK7JWZR','01J3VH3A9PENCX92RE8Y1Q9CJ2','01J3RTS49WZKMXDWKD083PNGTQ')

DoD

daisukeiizuka commented 1 month ago

以下で修正されていることを確認 https://github.com/arcam-inc/gitwork-api/commit/ef83c5c6e0b187c933ddc09192c3bc11a567d485