Deleting an original puzzle breaks any instances that were made from it

[jkenlooper]

If a puzzle, that is an original (not a puzzle instance), is deleted; any puzzle instances made from that original will also be made inaccessible. This causes that player to not be able to clear that puzzle instance slot and is then not able to create a new puzzle instance from any other puzzle. The fix for this should be to properly clear that puzzle instance slot when the original is deleted.

Allowing a puzzle instance made from a now deleted original to continue to be available is not the intended fix. The original puzzle that was deleted may be because of inappropriate content or for licensing issues and should no longer be available on the site. Any puzzle instances made from that deleted original puzzle will need to be cleared as well.

This fix might be to fix the cascade bit in the SQL to also remove the reference to the puzzle in the User_Puzzle table. Or, to also find any puzzle instances made from that original and updating each associated row in the User_Puzzle table.