I have moved .photoslibrary files to external discs on several different Mac systems, and not always successfully. I learned the hard way, make backups first!
Any chance that the external drive where you moved the problematic .photoslibrary file was then connected to a newer version of macOS, and thus, a newer version of Photos than the macOS and Photos versions you're trying to use now?
A newer version of Photos apparently automatically updates the .photoslibrary file to the newest version of Photos connected, and once that happens, that .photoslibrary file can never be opened by older versions of Photos.
If you discover that the 'newer Photos version' problem caused the issue, you should be able to successfully open the photoslibrary file with that newer version.
The 'Repair database' has never helped me recover from this issue.
The two ways I've found to recover from the problem:
1) Restore from a backup created before the problem happened;
or
2a) Using the newer Photos version, Export everything as individual files.
2b) Create a new empty .photoslibrary file in the older Photos version, and
2c) Re-import everything back into the older Photos version.
Hope this helps!