How are you launching Photos to open the library? Are you clicking the Photos icon in the Dock or are clicking the Photos Library on your external drive?
After a system upgrade there may be an outdated item in the Dock or an older Alis on your Desktop linking to an older version of Photos, particularly, if the library is on an external drive containing backups. If you have used the Dock icon, CTRL-click it and try the command "Options > reveal in Finder" to check, which version of Photos the icon is linked to. If it is a an older version on a backup drive, remove the icon and add it again from your Applications folder.
Then you may want to try to open your Photos Library this way.
- Quit Photos, if it is running.
- Select your Photos Library in the Finder, then open the Info panel with the shortcut ⌘i. In the middle of the Info panel check the "Open with" info. It should be set to "Open with Photos.app".
- Then double-click the Photos Library to open it. It should automatically use the Photos.app version in your Applications folder.
If have downgraded from Sonoma or opened the library on Sonoma, you can no longer open it on a Mac with an older system version. Photos has no tool to downgrade your library. You would have to create a new library on your older Mac and import the photos again. If you are using iCloud Photos and your library has been synced to iCloud you can easily recreate an older version by syncing a new, empty Photos Library with your iCloud Photos Library.