ID 603822 - Blank panels fail to Archive when the blank asset belongs to a different Show

Problem summary:
Blank panels fail to Archive when the blank asset belongs to a different Show
 
Customer reported version:
Flix 7.1.1
 
Customer reported platform:
CentOS 7
 
Steps to reproduce:
1) Open Flix using the attached database file
2) Attempt to Archive one of the affected Shows: 11, 13, 14, 15
3) Observe how the Archive is unable to account for blank assets that belong to a different Show
 
Expected behavior:
When a Show contains Blank Panels with Assets belonging to different Show Id's, the Archival process should create an appropriate blank asset so the Archive can succeed.
 
Actual behavior:
When archiving a Show, only assets belonging to that Show are Archived. As such, if Blank Panels exist and share the same asset even though the Panels belong to different Shows (which was designed behavior in previous versions of Flix pre-6.4), Flix will indicate that the Archive encountered a problem and is missing assets.
 
Workaround:
1) Run the following query to list affected Panels:

SELECT vPanel_asset_ref.*, bucket.show_id as asset_show_idFROM vPanel_asset_ref         JOIN asset ON asset.asset_id = vPanel_asset_ref.asset_id         JOIN bucket ON bucket.id = asset.bucket_idWHERE vPanel_asset_ref.show_id <> bucket.show_id;

2) Open any Sequence Revision in the Show you want to archive.
3) Create a new Blank Panel (Note: you do not need to save the Sequence Revision). This will cause Flix to generate a new show-specific blank asset if there is none already.
4) Run the following query to update Panel Revisions within a given Show (Show ID 13 in the example below) to use the new, show-specific blank asset instead:

UPDATE vPanel_asset_ref    JOIN shows_blank_asset on shows_blank_asset.show_id = vPanel_asset_ref.show_idSET vPanel_asset_ref.asset_id = shows_blank_asset.asset_idWHERE vPanel_asset_ref.asset_id = 21785  AND vPanel_asset_ref.show_id = 13;

Here, 21785 is the ID within the current database of the blank asset that belongs to the wrong show, as indicated by the SELECT query in step 1. The AND vPanel_asset_ref.show_id = 13 part can be removed if you want to update all panel revisions in all shows at once, but remember that you will first need to generate a blank asset by following the initial steps for each show that you wish to repair.
 
Reproduced by Development team