fix

mtojek · mtojek · commit 774c4b034673 · 2024-09-11T10:02:07.000+02:00
diff --git a/coderd/database/queries/notifications.sql b/coderd/database/queries/notifications.sql
@@ -188,7 +188,7 @@ WHERE
 -- Insert or update report generator logs with recent activity.
 INSERT INTO report_generator_logs (user_id, notification_template_id, last_generated_at) VALUES (@user_id, @notification_template_id, @last_generated_at)
 ON CONFLICT (user_id, notification_template_id) DO UPDATE set last_generated_at = EXCLUDED.last_generated_at
-WHERE report_generator_logs.user_id = EXCLUDED.user_id AND report_generator_logs.notification_template_id = EXCLUDED.notification_template_id);
+WHERE report_generator_logs.user_id = EXCLUDED.user_id AND report_generator_logs.notification_template_id = EXCLUDED.notification_template_id;
 
 -- name: DeleteOldReportGeneratorLogs :exec
 -- Delete report generator logs that have been created at least a <frequency_days> +1h ago.
