Hello this install to me looks like it is a failed upgrade. Did you upgrade recently?
Looks like some upgrades where not ran and others like the 4.85 upgrade which states not to run more than once was ran 3 times. The problem is it prepends the userid on the photo names which means it can not be ran multiple times.
The proper solution would be to restore a backup of your photopost photos table from your backups that is known to be good and run through the upgrade script from you last version forward only running every upgrade only once. http://www.v6performance.net/gallery/
After you do that your photos should appear. I got rid of your mysql errors by running the 4.82 upgrade