Error

[lava114514]

08/03/2025 07:26 PM ERROR api error {"error": "ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification (SQLSTATE 42P10)"}
08/03/2025 07:26 PM ERROR {"status": 500, "method": "POST", "path": "/api/files", "query": "", "ip": "[::1]:58356", "user-agent": "rclone/v1.69.1", "latency": 0.2886688, "time": "2025-03-08T11:26:05Z"}
08/03/2025 07:26 PM ERROR [DB] github.com/tgdrive/teldrive/pkg/services/file.go:326 ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification (SQLSTATE 42P10)
[275.648ms] [rows:-]
INSERT INTO teldrive.files (
name, parent_id, user_id, mime_type, category, parts,
size, type, encrypted, updated_at, channel_id, status
)
VALUES ('20210806_130401000_iOS.mp4', '01952e93-ebf6-7c6a-81c0-777b55699a4a', 5635405753, 'video/mp4', 'video', '[{"id":55645},{"id":55659},{"id":55665},{"id":55666},{"id":55636},{"id":55664}]', 3029568783, 'file', false, '2023-01-14 07:40:28', 2116783738, 'active')
ON CONFLICT (name, COALESCE(parent_id, '00000000-0000-0000-0000-000000000000'::uuid), user_id)
WHERE status = 'active'
DO UPDATE SET
mime_type = EXCLUDED.mime_type,
category = EXCLUDED.category,
parts = EXCLUDED.parts,
size = EXCLUDED.size,
type = EXCLUDED.type,
encrypted = EXCLUDED.encrypted,
updated_at = EXCLUDED.updated_at,
channel_id = EXCLUDED.channel_id,
status = EXCLUDED.status
RETURNING *