No Thumbnails - No Pictures
 

After the upgrade, no error when moving data files, I see no Thumbnails, and No pictures when clicked.

Only error I have is the last step - removing the files.

Is there anything that I can check?

Site is www.photozo.com/album

Upgraded from 4.7j to 5.0



Thank you!

When I right click a thumbnail (unavailable), it shows me this path:

Notice in image name, there is a 6902690269026902 prefix. Is this because I ran one of the upgrade script several times?

Apparently, there are several duplicate numbers added before the image name. For example, the previous image will show up if you view this path:

Stupid me, is it because I ran one of the upgrade script several times?

Do I need to go in somewhere and change the 30,000 images name one by one?

Yeah you cant run step3 multiple times. Only step2 can be ran again if you had failed image moves just like the script says run if you get errors.

Honestly I cant think of any script I could write up to help you.

Since we always recommend making a mysql backup before upgrade you can always restore that photos table and simply rerun the upgrade script ONCE.

Does that mean I need to restore it and rerun the upgrade from 4.7i all the way to 5.0?

If restore "photos" only, which specific upgrade should I run?

Thank you very much!

Now I got the photos table sql file sorted out from the whole photopost database backup, and ready to restore this one "photos" table.

How can I only run the STEP 3 ONLY?

Thank you very much for your help.

Fixed by steps:

1. Restored only photos table to the database
2. Rerun upgrade from 4.7 - sweating all the way
3. Ran 4.85 Step 1. Skipped Step 2, Then Ran Step 3.

Everything back to normal now.

Thanks Chuck for your prompt response and help.

Yep was in bed when you where sweating it ;)

I have the exact same problem, and only have a database backup with no backup of the data directory. I ran step 3 twice and it messed everything up. So I thought I just needed to rebuild my thumbnails and it removed all my photos from the database. They're all still in the data directory with their new naming conventions but are completely disconnected now. How can I fix all this?

restore the mysql photos table inserts from the backup and rerun the upgrade script only running it ONCE

So ONLY restore the photos table and do all 3 steps over again?

Step 1 gives me the following errors, should I continue anyways?

those errors are fine as those already exist continue

what if it does not let you continue says something like please delete upgrade.php now

but everything is still messed up?
that was on step 1

You must run the upgrade script through its entirety once

You can not run step 3 twice etc

Thats why we state restore the photos tables from backup and rerun upgrade

It is a big upgrade. Here is the outline of what it does

1. Adds the normal upgrade stuff

2. moves all medium and thumb images

3. Resets the bigimage photos field imagename to useridimagename for compatibility with the new format of not writing images to userid prepended

how to just restore the tables if PP and VB are in the same database

As stated in the other thread you asked the same question just restore the photos table not the entire sql

You can view an sql file just like a text document and select what you need

I ran into this problem when I updaded to PP5 this past weekend. I restored the photos table, reran the upgrade script as you said, and PP now works just as it should.

However, I have installed the PhotoPost 5 PopUp IMG Insert for vB3 hack, and when I click on a photo to be included in a vB post, I have the same problem where the user ID is included multiple times within the file name link. Is there another table that needs to be fixed in addition to the photos table to correct this error?

Thanks in advance for your help! :)

Here's the solution: remove {$user} from lines 76 and 77 from pppanel.php, and the problem goes away! I guess I should have worked on the problem a little more before posting the question.

Thank you. You are very kind to share the solution.