481 to 5 upgrade - I now can see no images

Silver_2000 · March 5th, 2005, 04:09 PM

I went thru the instructions step by step
Backed up database and all files
Turned of Gallery
Ran upgrad script - started with 4.82 link - The only errors in the upgrade.php was the one where it tries to remove the unused files. I removed them manually.
When I reopened the gallery I saw a bunch of "no thumbnail avail" images

So In an attempt to fox that I scaned the databse to rebuild the thumbs... It said it removed a BUNCH of images - Now the gallery is empty - No images in the interface

The images ARE in the data directory and the data directory was updated with the thumbs and mini directories

The gallery shows the category contains 200 or so pictures but when you click the category to see them it say it contains no images..

What stap did I miss ? What do I need to do ?

http://www.hynes-family.com/ppost/index.php

I knew I should have waited before upgrading.....

Doug

Silver_2000 · March 5th, 2005, 04:12 PM

Admin CP shows this
Which is NOT encouraging

Image Space Used 0.0 mb Total Photos 0
Total disk space used by the DATA directory 176.42 mb

Chuck S · March 5th, 2005, 06:56 PM

Quote:

Originally Posted by Silver_2000

So In an attempt to fox that I scaned the databse to rebuild the thumbs... It said it removed a BUNCH of images - Now the gallery is empty - No images in the interface
Doug

Doug

Every problem I have seen has been from permissions issues on data directories

You never run a rebuild thumb after an upgrade like this where it moves files as if you have a problem it will delete every image you have since PP5 is looking for images where PP5 thinks they are. They are of course still in PP 4.8.6 and below format.

Since you did a backup I would do this

1. Restore your photos table and data directory.

2. check each data directory to ensure it is 777

3. Then run the upgrade or PM me and I will assist you.

Silver_2000 · March 5th, 2005, 09:02 PM

The pictures are still there in the data directory ...
Large pictures in the 50X folder and then
50x\medium
50x\mini
50x\thumbs
Under that
The pics seem to have been moved to the correct folders.
Is it still necessary to go thru the restore process ?

Chuck S · March 5th, 2005, 09:27 PM

If the pictures seem to be moved you can just restore the photos table and run upgrade script again

Silver_2000 · March 5th, 2005, 09:28 PM

Quote:

Originally Posted by omegatron

Doug
You never run a rebuild thumb after an upgrade like this where it moves files as if you have a problem it will delete every image you have since PP5 is looking for images where PP5 thinks they are. They are of course still in PP 4.8.6 and below format.

The upgrade completed with out error - Isint it safe to assume then that with that info and the onfo posted above that the data move finished and the pics are where PP5 thinks they are ??

Im just trying to figure out what went wrong to prevent the same issue on the next gallery.

If the permissions were wrong would the gallery have otherwise worked correct ?

Doug

pengrus · March 5th, 2005, 09:37 PM

Doug,

I ran into the same problem, except I did not rebuild the thumbnails. But no images including the thumbnails are available.

Silver_2000 · March 5th, 2005, 09:52 PM

Ok

I dropped the photo table and then added it back and repopulated it from the back up ( I LOVE BACKUPS )

THen reran the upgrade from 4.82

It errored out mostly BUT now I can see the thumbnail and photo place holders - BUT the issue is that it is looking for the pictures with NO prepended id number - BUT the pictures in the medium folder still have the user number prepended.

for example I see red x's and its looking for a picture at
http://www.hynes-family.com/ppost/da...m/P8051801.JPG

BUT the picture is at http://www.hynes-family.com/ppost/data//513/medium/1P8051801.JPG\

EDIT - I had previously confirmed 777 permissions on all data folders

pengrus · March 5th, 2005, 10:00 PM

I have backed up ALL of the photopost database tables into one file database.sql.

Could you please tell me how you could repopulate ONLY the "photos" table from the whole backup?

Sorry for interrupt in your thread.

Silver_2000 · March 5th, 2005, 10:04 PM

Ok - Not sure what happened BUT The pictures are back ...

Went to get a beer and after I came back and refreshed the pics are working ......

Its now loking for the pictures with the user id again ... is that correct ?

Chuck S · March 5th, 2005, 10:08 PM

Yep this is the order of the 4.8.5-4.8.6 upgrade script to 5.0

IT NEEDS TO FINISH IN ORDER AND FULLY WITHOUT ERROR FOR NO ERRORS

step1 adds new tables and settings

step2 moves all files

step3 rewrites photos as photoname with userid prepended to front into bigimage field and deletes old photopost php files no longer needed

Silver_2000 · March 5th, 2005, 10:08 PM

Quote:

Originally Posted by pengrus

I have backed up ALL of the photopost database tables into one file database.sql.

Could you please tell me how you could repopulate ONLY the "photos" table from the whole backup?

Sorry for interrupt in your thread.

Good question

open the sql file or better yet a copy of it with a GOOD text editor..

You will find a section like this

Code:

Content visible to verified customers only.

The text above are 4 sql commands - One drops the photos table then reloads it - the next one drops the contents of the photos table then it adds the photo data back...

I used those commands from within phpmyadmin

Doug

Silver_2000 · March 5th, 2005, 10:10 PM

Quote:

Originally Posted by omegatron

Yep this is the order of the 4.8.5-4.8.6 upgrade script to 5.0

IT NEEDS TO FINISH IN ORDER AND FULLY WITHOUT ERROR FOR NO ERRORS

step1 adds new tables and settings

step2 moves all files

step3 rewrites photos as photoname with userid prepended to front into bigimage field and deletes old photopost php files no longer needed

the only change this time was I let the Move Data step run for about 5 min AFTER the "done" message came up...

Thanks for your help

Doug

Silver_2000 · March 6th, 2005, 08:47 PM

Chuck

Can someone add a list of the correct permissions for each file / folder for the new version ?

Thanks

Doug

Chuck S · March 6th, 2005, 08:59 PM

Doug

The permissions structure for the Photopost package has not changed for Photopost 5

The uploads and data directories as well as there subdirectories have always needed to be 777 with any version of Photopost

The only issues I have encountered is when data directories are not 777 or upgrade script is not ran to the end.

Step2 states wait till it goes to the next step and it may take awhile.

In every case if a user double checks permissions as the script states and reruns step2 like it states then things are fine.

I will see if we can word things even more explicit as I am seeing alot of people running step3 multiple times which is a big no no

Silver_2000 · March 6th, 2005, 09:02 PM

I just ran upgrade on second gallery

I set all files inside the gallery folder to 777 and it still failed

Apparently the Gallery folder itself was 755 - that prevented the file deletes from happening .... I changed the permission of it - hit back and redid the FINAL step - Files deleted correct this time

Once again I dont have images - just a bunch of thumbnail not avail images...
Ill try rerunning step 2

Silver_2000 · March 6th, 2005, 09:10 PM

How do I run just step 2 ?

Step 2 of which upgrade ?

EDIT - Ok this appares to be step 2
"Preparing to move files"

The files are moved ( just like last time ) - Im replacing the photos table again and going to run thru the upgrade again but want to be sure I only do the right steps.

Chuck S · March 8th, 2005, 04:25 PM

Yep only step2 can you run twice if you get errors although thats indicative permissions are wrong