update data in one table with the values from another table

I have 2 tables, shows and show_photo

shows structure:

show_photo structure:

What i want to do is update show_photo.modified column with show.year
This is what i tried but nothing gets updated.

UPDATE show_photo t2
JOIN shows t1 ON t1.id = t2.show_id
SET t2.modified = t1.year;