You are correct: the publication_id column exists, but hasn’t been filled (everything pre-upgrade is NULL). The submission_id column also exists, with all the pre-upgrade values (everything post-upgrade is NULL). I will go ahead and manually fill in the correct publication_id values (as you surmise, this error arose on the production database).
Thanks for all your help here.