Just a small addition to @dannymohammad s response (had the same problem and then moved the posts).
You also have to move the fileinfos and reactions afterwards, as follows:
UPDATE fileinfo
SET ChannelId = 'new_id'
WHERE ChannelId = 'old_id';
UPDATE reactions
SET ChannelId = 'new_id'
WHERE ChannelId = 'old_id';