|
hey chuck,
i set permissions to 777 on all directories. during the first step of the upgrade i get:
Preparing to update 4.8.5 database...
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'
After the second step i get the below even after setting permissions ( this is the first part of the long list of failures....
Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/500/thumbs/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3254
Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3255
Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/500/medium/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3260
Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3261
Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/500/mini/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3266
Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3267
Warning: fopen(/home/webadmin/metalmeet.com/html/photopost/data/505/thumbs/index.htm): failed to open stream: Permission denied in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3254
Warning: fclose(): supplied argument is not a valid stream resource in /home/webadmin/metalmeet.com/html/photopost/pp-inc.php on line 3255
thanks again for your help
|