Background:
In a previous submit email one of the show hosts sent a form with duplicated values in the tags field, which caused an SQL error during the upload.
After checking the code I saw that we have a unique constraint on the tag’s display_name field which caused the issue.
TLDR:
In case of adding / editing a show or an episode, there is a chance to add duplicated tags in the form, which is not handled correctly and causes an error during the SQL insert.
Background:
In a previous submit email one of the show hosts sent a form with duplicated values in the tags field, which caused an SQL error during the upload.
After checking the code I saw that we have a unique constraint on the tag’s display_name field which caused the issue.
TLDR:
In case of adding / editing a show or an episode, there is a chance to add duplicated tags in the form, which is not handled correctly and causes an error during the SQL insert.