In 2017-2018 I created a zip file on macOS. The file was stored for years and now, when I wanted to get something out of it, I found out the file is not readable by any software. Check your backups, friends!
The problem is that macOS Archive utility had a bug handling files over 4GB. The bug was fixed later (some time in 2019) so nowadays you should not have experience with it.
Unfortunately for me, any attempt to fix zip archive with standard tools (zip -FF, etc) failed. So I claude coded the script to fix the issue. Feel free to use for any purpose.
This small script reconstructs a zip archive. Given a broken archive, it produces a fixed archive from which you can extract all files without issues.