Directory Permissions PP 5.0 Upgrade

[starman]

Just upgraded from 4.86 to 5.0

Some thumbnails not showing along with main images

Researched and discovered Directory permissions weren't set to 777 for the following directories and data

1. data/1,2, & 500 /thumbs/medium/mini
2. pp-inc.php

I am assuming the error Warning: copy(......) failed to open stream Permission denied was caused by the lack of permissions

Permissions for the above have now been set to 777
What is my next step? Can i run the upgrade again?

[b6gm6n]

Hi..

yes it's permissions all the way! - check to see if all directories under and including DATA are set to 777, you could also alter the permissions to the .php files in your photopost install directory to 777 for now, then alter back to 755 after upgrade complete, and yes you can run the upgrade again

-T

[starman]

Ran the upgrade again and now no thumbs and images are linking up.

When I 4.86 upgrade again I received the following error for step 1

Error performing MySQL command: ALTER TABLE pp_photos ADD numcom INT(8) DEFAULT '0' NOT NULL , ADD lastposter VARCHAR(255), ADD lastpid INT(8) DEFAULT '0' NOT NULL
Error: Duplicate column name 'numcom'

Error performing MySQL command: ALTER TABLE pp_categories ADD maximages INT(12) default '0' NOT NULL, ADD canzip VARCHAR(3) DEFAULT 'no' NOT NULL, ADD frames VARCHAR(32) NULL
Error: Duplicate column name 'maximages'

Error performing MySQL command: ALTER TABLE pp_categories ADD numextra INT(3) default '0' NOT NULL
Error: Duplicate column name 'numextra'

Error performing MySQL command: ALTER TABLE pp_categories ADD intro VARCHAR(3) default 'no' NOT NULL, ADD introtitle VARCHAR(128) DEFAULT NULL, ADD introcopy TEXT DEFAULT NULL, ADD moderators TEXT DEFAULT NULL
Error: Duplicate column name 'intro'

Error performing MySQL command: ALTER TABLE pp_categories ADD ratingtype INT(1) DEFAULT '0' NOT NULL, ADD takevotes INT(1) DEFAULT '0' NOT NULL
Error: Duplicate column name 'ratingtype'

Error performing MySQL command: CREATE TABLE pp_photoviews (photoid mediumint(9) NOT NULL default '0') TYPE=HEAP
Error: Table 'pp_photoviews' already exists

Error performing MySQL command: CREATE TABLE pp_extrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )
Error: Table 'pp_extrafields' already exists

Error performing MySQL command: CREATE TABLE pp_photoextras (id INT(12) NOT NULL AUTO_INCREMENT, photo INT(12), extraid INT(12), selection TEXT, PRIMARY KEY (id) )
Error: Table 'pp_photoextras' already exists

Error performing MySQL command: ALTER TABLE pp_users ADD cellphone VARCHAR( 255 )
Error: Duplicate column name 'cellphone'

Step 2 had no erros when moving the data.

[Chuck S]

Did you run the upgrade script multiple times?

I would need to see a link to your install to say exactly what has happened

[starman]

Upgrade was ran twice.

http://www.scrollsawer.com/gallery/

[Chuck S]

Yep thats the issue then.

Step2 can be ran again if you had permissions errors however step3 can not be ran twice since that rewrites image names

I would restore your photos table from the backup you took before upgrade and do the upgrade again

I cant view your board as its closed but I would assume if you right click one of your x's you would see that the userid is prepended twice on the photos now which is why you dont see images

[starman]

I guess I should have been more clear about asking if I can run the upgrade again in my original post

[Chuck S]

Well after seeing many people run all steps again on the upgrade I have asked the developer even though step 2 is the only one that says you can run it again to consider placing in bold letters on step 3 DO NOT RUN MORE THAN ONCE

The big thing about step3 is thats when the photo names are rewritten to imagename plus userid so images can get away from the old style of when pre 5 we prepended userid's to image names. If you run it multiple times your prepending the userids many times

[starman]

Not to dwell what is done is done and fix is easy.

But maybe you want to add that to the upgrade.txt within the documentation folder.

[Chuck S]

Actually what we did is to make the script not process any filenames that have the userid prepended

[starman]

What I was saying is.... if you view the Upgrade.txt within the documentation folder there is no reference to not running the script more than once. You may want to add this to the documentation. I wasn't referencing upgrade.php.