Upgrade and now it's not "seeing" images

WebmasterAJ · February 1st, 2006, 06:47 AM

Hello -

I recently upgraded from 5.03 to the latest version and now it's not seeing the images. I can actually go to the directory and see the images myself, but as far as PhotoPost is concerned it says there are "0" images in the directory.

Any ideas about this issue?

Chuck S · February 1st, 2006, 09:34 AM

How about a url so I can see what your exact issue is

WebmasterAJ · February 1st, 2006, 10:18 AM

Here is a link:
http://www.finheaven.com/photo/

I uploaded one photo and it uploaded correctly. There are more photos there - I don't know why it's not picking them up.

If I login via SSH and go to the directory... and use ls -aR... I see ALL the files. Attached is a simple screen shot... I know it's not high res, but you'll see what I mean.

Chuck S · February 1st, 2006, 11:13 AM

Okay you sure you did not upgrade or run from 486 and run the last step3 of upgrade 485/486 twice which prepended the userid's on the images more than once so when you upgraded and saw no thumbs your went to scan database and tried to rebuild thumbs and since they did not exist your photo inserts where deleted.

Only way to get your photos back would be to restore the photos table from a backup and run the upgrade 486 step 3 ONCE.

WebmasterAJ · February 1st, 2006, 11:27 AM

are you sure there's really no other way? the nightly back up has already been over written.

What about a clean install... something? Please tell me there's something...

Chuck S · February 1st, 2006, 11:42 AM

There is no other way than what I have stated. That is why the upgrade documentation states to take a backup of your mysql database before doing the upgrade. You always need a restore point if something does wrong. If you do not have a backup of the photos table there is no way to get them back besides reuploading every last one.

Now you can contact your host and see if they have a backup of the database. It might be a day or two old or week old but its better than nothing.

WebmasterAJ · February 1st, 2006, 02:44 PM

Alright - so I actually had a database available. Who knew.

Which script do I run? I previous had 5.02....

Chuck S · February 1st, 2006, 03:06 PM

Well your photos are back. You would run the upgrades from 5.0 to 5.3

WebmasterAJ · February 1st, 2006, 03:21 PM

Thanks man!