No Thumbnails - No Pictures

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

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!

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

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

Code:

Content visible to verified customers only.

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

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

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

Code:

Content visible to verified customers only.

Code:

Content visible to verified customers only.

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?

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

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.

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

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!

pengrus · March 5th, 2005, 11:15 PM

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?

Code:

Content visible to verified customers only.

Thank you very much for your help.

pengrus · March 6th, 2005, 12:34 AM

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.

Chuck S · March 6th, 2005, 07:19 AM

Yep was in bed when you where sweating it

RedPoptarts · March 19th, 2005, 07:57 PM

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?

Chuck S · March 19th, 2005, 07:58 PM

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

RedPoptarts · March 19th, 2005, 08:10 PM

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

RedPoptarts · March 19th, 2005, 08:16 PM

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

Code:

Content visible to verified customers only.

Chuck S · March 19th, 2005, 08:33 PM

those errors are fine as those already exist continue

hunterscentral · March 19th, 2005, 09:38 PM

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

Chuck S · March 20th, 2005, 07:20 AM

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

hunterscentral · March 20th, 2005, 09:55 AM

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

Chuck S · March 20th, 2005, 11:54 AM

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

tester3 · March 20th, 2005, 01:01 PM

Quote:

Originally Posted by omegatron

just restore the photos table not the entire sql

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!

tester3 · March 20th, 2005, 01:12 PM

Quote:

Originally Posted by tester3

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.

pengrus · March 20th, 2005, 01:23 PM

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