Well did you read the upgrade documentation in the documentation folder?
You may be hosed or not. That depends. Looks to me like you ran an upgrade script you did not have to run therefore hosing your entire site. Looks like your site was already running a 5.0 type filestorage and you ran 4.85 upgrade messing up your files
See this
Ryanair 737 on Final's to East Midlands - Sportscar Race Gallery!
The file linked here is this
http://www.xpower-racing.com/gallery...yanair-737.jpg
But the actual image is here
http://www.xpower-racing.com/gallery...yanair-737.jpg
The correct action in your situation would be to restore the database table pp_photos from prior to the upgrade and then run just upgrades 5.0 forward.
The upgrade documenation always states to take database backups before beginning and as part of your site maintenance you should be doing them so as long as you have those your not hosed.