I'm running the latest version of v3.8 (2019111802.10) after upgrading from v3.6. As a result, we've had to change our theme since our old one isn't compatible with v3.8. Because of this, we need to move all of the blocks that were in side-post to side-pre. I modified all of the 'defaultregion' entries in the mdl_block_instances table to 'side-post' and for the most part that worked. However, I've got several blocks that are still stuck in side-post and I can't tell where that's set in the DB.
When I go to configure the block, the location in the "Where this block appears" section shows 'side-pre'. But the Region field on the "On this page" section shows 'side-post'. I can provide screenshots if needed.
Can anyone tell me where that is stored in the DB so I can modify it and force them all over to side-pre?