PhotoPost Community - View Single Post

larryd · January 20th, 2007, 12:19 PM

Here is my upgrade path step by step..

Preparing to update 4.6 database...

Performing MySQL command: ALTER TABLE photos ADD storecat INT(12) DEFAULT '0' NOT NULL AFTER `cat` ... Error: Duplicate column name 'storecat'
Performing MySQL command: ALTER TABLE photos ADD storeid INT(12) DEFAULT '0' NOT NULL AFTER `storecat` ... Error: Duplicate column name 'storeid'
Performing MySQL command: REPLACE INTO settings VALUES (136, 'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 19, 6) ... Successful!

Upgrade complete! You should continue to next step
__________________________________________________________________

Preparing to update 4.6.7 database...

Performing MySQL command: REPLACE INTO settings VALUES (137, 'Enable slideshows?', 'slideshow', '', 'yes', 19, 6) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (138, 'Enable next and previous photo previews?', 'nextbox', '', 'yes', 20, 6) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (139, 'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 99, 5) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (140, 'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 100, 5) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (141, 'Acceptable multimedia file types?', 'acceptmm', 'Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)', '.mpeg,.mpg,.avi,.asf,.wmv,.mov', 89, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (142, 'Acceptable image file types?', 'acceptimg', 'Seperate file types by a comma and include the . (example: .jpg,.gif,.png)', '.jpg,.jpeg,.png,.gif', 89, 3) ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'reqmod'
Performing MySQL command: ALTER TABLE ecards ADD returnr INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'returnr'
Performing MySQL command: ALTER TABLE notify ADD type INT(2) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'type'
Performing MySQL command: ALTER TABLE ecards ADD readdate INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'readdate'
Performing MySQL command: DELETE FROM settings WHERE id = 22 ... Successful!
Performing MySQL command: DELETE FROM settings WHERE id = 57 ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (143,'Select a border for your thumbnails','thumbborder','Choose from the available borders for your thumbnails','thumbnail',62,2); ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.7',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2007 All Enthusiast, Inc.',300,'0') ... Successful!

Upgrade complete! You should continue to next step
__________________________________________________________________

Preparing to reorganize admin options...

INSERT INTO admingroups VALUES (7,'Comments Options') failed with error: Duplicate entry '7' for key 1
INSERT INTO admingroups VALUES (8,'Registration Options') failed with error: Duplicate entry '8' for key 1
INSERT INTO admingroups VALUES (9,'Layout Options') failed with error: Duplicate entry '9' for key 1
INSERT INTO admingroups VALUES (10,'Watermark Options') failed with error: Duplicate entry '10' for key 1
ALTER TABLE comments ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
ALTER TABLE photos ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress'
INSERT INTO admingroups VALUES (11, 'Sidebar Settings') failed with error: Duplicate entry '11' for key 1
INSERT INTO settings VALUES (144, 'Sidebar Placement?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'off', 1, 11) failed with error: Duplicate entry '144' for key 1
INSERT INTO settings VALUES (145, 'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11) failed with error: Duplicate entry '145' for key 1
INSERT INTO settings VALUES (146, 'Under Category PAL?', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11) failed with error: Duplicate entry '146' for key 1
INSERT INTO settings VALUES (147, 'Statistics PAL?', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11) failed with error: Duplicate entry '147' for key 1
INSERT INTO settings VALUES (148, 'Top Posters PAL?', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11) failed with error: Duplicate entry '148' for key 1
INSERT INTO settings VALUES (149, 'Random Image PAL?', 'randompal', ' Display Random Image?', 'yes', 8, 11) failed with error: Duplicate entry '149' for key 1
INSERT INTO settings VALUES (150, 'Highest Ratings PAL?', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11) failed with error: Duplicate entry '150' for key 1
INSERT INTO settings VALUES (151, 'Show Sidebar on Index Page?', 'sidebar_index', '', 'no', 2, 11) failed with error: Duplicate entry '151' for key 1
INSERT INTO settings VALUES (152, 'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'no', 3, 11); failed with error: Duplicate entry '152' for key 1
INSERT INTO settings VALUES (153, 'Default theme setting (UBBThreads users only)', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 18, 1) failed with error: Duplicate entry '153' for key 1
INSERT INTO settings VALUES (154, 'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5) failed with error: Duplicate entry '154' for key 1
INSERT INTO settings VALUES (155, 'Show Avatars?', 'showavatar', 'When available, show avatars?', 'yes', 28, 5) failed with error: Duplicate entry '155' for key 1
INSERT INTO settings VALUES (156, 'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3) failed with error: Duplicate entry '156' for key 1
INSERT INTO settings VALUES (157, 'Display Custom PAL #1', 'custom1pal', ' If you modified the custom1pal.tmpl and want to include it set to yes', 'no', 11, 11) failed with error: Duplicate entry '157' for key 1
INSERT INTO settings VALUES (158, 'Display Custom PAL #2', 'custom2pal', ' If you modified the custom2pal.tmpl and want to include it set to yes', 'no', 12, 11) failed with error: Duplicate entry '158' for key 1
INSERT INTO settings VALUES (159, 'Display Custom PAL #3', 'custom3pal', ' If you modified the custom3pal.tmpl and want to include it set to yes', 'no', 13, 11) failed with error: Duplicate entry '159' for key 1
INSERT INTO settings VALUES (160, 'Number of Top Posters to display', 'numtoppal', '', '5', 14, 11) failed with error: Duplicate entry '160' for key 1
INSERT INTO settings VALUES (161, 'Number of Last Comments to display', 'numcompal', '', '5', 15, 11) failed with error: Duplicate entry '161' for key 1
INSERT INTO settings VALUES (162, 'Number of Most Popular Photos to display', 'mostpoppal', '', '5', 16, 11) failed with error: Duplicate entry '162' for key 1
INSERT INTO settings VALUES (163, 'Use Integrated forum stylesheets?', 'forumstyle', 'If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes', 'no', 19, 1) failed with error: Duplicate entry '163' for key 1
INSERT INTO settings VALUES (164, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11) failed with error: Duplicate entry '164' for key 1
ALTER TABLE usergroups ADD canassign INT(3) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'canassign'
ALTER TABLE categories ADD sortorder INT(2) DEFAULT '1' NOT NULL, ADD extra1 VARCHAR(250), ADD extra2 VARCHAR(250), ADD extra3 VARCHAR(250), ADD extra4 VARCHAR(250), ADD extra5 VARCHAR(250), ADD extra6 VARCHAR(250), ADD thumbnail INT(15) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'sortorder'

Done! You should continue to next step
__________________________________________________________________

Preparing to update 4.8.2 database...

Performing MySQL command: INSERT INTO settings VALUES (166,'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', 'no', 22, 1) ... Error: Duplicate entry '166' for key 1
Performing MySQL command: INSERT INTO settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', 'yes', 23, 1) ... Error: Duplicate entry '167' for key 1
Performing MySQL command: INSERT INTO settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1) ... Error: Duplicate entry '168' for key 1
Performing MySQL command: INSERT INTO settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '-5', 25, 1) ... Error: Duplicate entry '169' for key 1
Performing MySQL command: INSERT INTO settings VALUES (170,'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '0', 26, 1) ... Error: Duplicate entry '170' for key 1
Performing MySQL command: INSERT INTO settings VALUES (171,'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 12) ... Error: Duplicate entry '171' for key 1
Performing MySQL command: INSERT INTO settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12) ... Error: Duplicate entry '172' for key 1
Performing MySQL command: INSERT INTO settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', 'newcelica.org', 3, 12) ... Error: Duplicate entry '173' for key 1
Performing MySQL command: INSERT INTO settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '2', 27, 1) ... Error: Duplicate entry '174' for key 1
Performing MySQL command: INSERT INTO settings VALUES (175,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', 'no', 29, 5) ... Error: Duplicate entry '175' for key 1
Performing MySQL command: INSERT INTO settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '0', 28, 1) ... Error: Duplicate entry '176' for key 1
Performing MySQL command: INSERT INTO settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '/data/www/newcelica.org/html/photopost/backups', 29, 1) ... Error: Duplicate entry '177' for key 1
Performing MySQL command: INSERT INTO settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/local/bin/mysqldump', 30, 1) ... Error: Duplicate entry '178' for key 1
Performing MySQL command: INSERT INTO settings VALUES (179,'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '/usr/local/bin/jpgtran', 18, 1) ... Error: Duplicate entry '179' for key 1
Performing MySQL command: INSERT INTO settings VALUES (180,'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '/usr/local/bin/jhead', 19, 1) ... Error: Duplicate entry '180' for key 1
Performing MySQL command: INSERT INTO settings VALUES (181,'Gallery Open?', 'ppboards', '', 'open', 20, 1) ... Error: Duplicate entry '181' for key 1
Performing MySQL command: INSERT INTO settings VALUES (182,'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1) ... Error: Duplicate entry '182' for key 1
Performing MySQL command: REPLACE INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 13) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (183,'Show Peronsal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (184,'Allow users to move their own images?','usermove', '', 'no', 16, 2) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.85',53,0) ... Successful!
Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2007 All Enthusiast, Inc.',300,'0') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (12,'Cookie Settings') ... Successful!
Performing MySQL command: REPLACE INTO admingroups VALUES (13,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit'
Performing MySQL command: ALTER TABLE categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote'
Performing MySQL command: UPDATE settings SET title='Allow users to delete their own images?',optionorder=17 WHERE id=91 ... Successful!
Performing MySQL command: ALTER TABLE categories CHANGE catorder catorder MEDIUMINT(4) DEFAULT '9999' NOT NULL ... Successful!
Performing MySQL command: UPDATE categories SET catorder=9999 WHERE catorder=0 AND cattype='a' ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=1 WHERE id=7 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=2 WHERE id=41 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=3 WHERE id=83 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=4 WHERE id=163 ... Successful!
Performing MySQL command: UPDATE settings SET section=13,optionorder=5 WHERE id=153 ... Successful!

Upgrade complete! You should continue to next step
__________________________________________________________________

Finally on -> This install script will upgrade your 4.8.5 or 4.8.6 release. Only run this upgrade if you have the 4.8.5 or 4.8.6 version of the database in place (either by previous upgrades or if upgrading in order to the latest).

I get this: includes/config.php does not exist. Cannot continue.

January 20th, 2007, 12:19 PM	#3 (permalink)
larryd Junior Member Verified Customer Join Date: Feb 2004 Posts: 19	Here is my upgrade path step by step.. Preparing to update 4.6 database... Performing MySQL command: ALTER TABLE photos ADD storecat INT(12) DEFAULT '0' NOT NULL AFTER `cat` ... Error: Duplicate column name 'storecat' Performing MySQL command: ALTER TABLE photos ADD storeid INT(12) DEFAULT '0' NOT NULL AFTER `storecat` ... Error: Duplicate column name 'storeid' Performing MySQL command: REPLACE INTO settings VALUES (136, 'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 19, 6) ... Successful! Upgrade complete! You should continue to next step __________________________________________________________________ Preparing to update 4.6.7 database... Performing MySQL command: REPLACE INTO settings VALUES (137, 'Enable slideshows?', 'slideshow', '', 'yes', 19, 6) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (138, 'Enable next and previous photo previews?', 'nextbox', '', 'yes', 20, 6) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (139, 'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 99, 5) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (140, 'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 100, 5) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (141, 'Acceptable multimedia file types?', 'acceptmm', 'Seperate file types by a comma and include the . (example: .mpg,.wma,.asf,.mp3)', '.mpeg,.mpg,.avi,.asf,.wmv,.mov', 89, 3) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (142, 'Acceptable image file types?', 'acceptimg', 'Seperate file types by a comma and include the . (example: .jpg,.gif,.png)', '.jpg,.jpeg,.png,.gif', 89, 3) ... Successful! Performing MySQL command: ALTER TABLE usergroups ADD reqmod INT(3) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'reqmod' Performing MySQL command: ALTER TABLE ecards ADD returnr INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'returnr' Performing MySQL command: ALTER TABLE notify ADD type INT(2) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'type' Performing MySQL command: ALTER TABLE ecards ADD readdate INT(15) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'readdate' Performing MySQL command: DELETE FROM settings WHERE id = 22 ... Successful! Performing MySQL command: DELETE FROM settings WHERE id = 57 ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (143,'Select a border for your thumbnails','thumbborder','Choose from the available borders for your thumbnails','thumbnail',62,2); ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.7',53,0) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme-- Copyright 2007 All Enthusiast, Inc.',300,'0') ... Successful! Upgrade complete! You should continue to next step __________________________________________________________________ Preparing to reorganize admin options... INSERT INTO admingroups VALUES (7,'Comments Options') failed with error: Duplicate entry '7' for key 1 INSERT INTO admingroups VALUES (8,'Registration Options') failed with error: Duplicate entry '8' for key 1 INSERT INTO admingroups VALUES (9,'Layout Options') failed with error: Duplicate entry '9' for key 1 INSERT INTO admingroups VALUES (10,'Watermark Options') failed with error: Duplicate entry '10' for key 1 ALTER TABLE comments ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress' ALTER TABLE photos ADD ipaddress VARCHAR(32) failed with error: Duplicate column name 'ipaddress' INSERT INTO admingroups VALUES (11, 'Sidebar Settings') failed with error: Duplicate entry '11' for key 1 INSERT INTO settings VALUES (144, 'Sidebar Placement?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'off', 1, 11) failed with error: Duplicate entry '144' for key 1 INSERT INTO settings VALUES (145, 'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11) failed with error: Duplicate entry '145' for key 1 INSERT INTO settings VALUES (146, 'Under Category PAL?', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11) failed with error: Duplicate entry '146' for key 1 INSERT INTO settings VALUES (147, 'Statistics PAL?', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11) failed with error: Duplicate entry '147' for key 1 INSERT INTO settings VALUES (148, 'Top Posters PAL?', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11) failed with error: Duplicate entry '148' for key 1 INSERT INTO settings VALUES (149, 'Random Image PAL?', 'randompal', ' Display Random Image?', 'yes', 8, 11) failed with error: Duplicate entry '149' for key 1 INSERT INTO settings VALUES (150, 'Highest Ratings PAL?', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11) failed with error: Duplicate entry '150' for key 1 INSERT INTO settings VALUES (151, 'Show Sidebar on Index Page?', 'sidebar_index', '', 'no', 2, 11) failed with error: Duplicate entry '151' for key 1 INSERT INTO settings VALUES (152, 'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'no', 3, 11); failed with error: Duplicate entry '152' for key 1 INSERT INTO settings VALUES (153, 'Default theme setting (UBBThreads users only)', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 18, 1) failed with error: Duplicate entry '153' for key 1 INSERT INTO settings VALUES (154, 'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5) failed with error: Duplicate entry '154' for key 1 INSERT INTO settings VALUES (155, 'Show Avatars?', 'showavatar', 'When available, show avatars?', 'yes', 28, 5) failed with error: Duplicate entry '155' for key 1 INSERT INTO settings VALUES (156, 'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3) failed with error: Duplicate entry '156' for key 1 INSERT INTO settings VALUES (157, 'Display Custom PAL #1', 'custom1pal', ' If you modified the custom1pal.tmpl and want to include it set to yes', 'no', 11, 11) failed with error: Duplicate entry '157' for key 1 INSERT INTO settings VALUES (158, 'Display Custom PAL #2', 'custom2pal', ' If you modified the custom2pal.tmpl and want to include it set to yes', 'no', 12, 11) failed with error: Duplicate entry '158' for key 1 INSERT INTO settings VALUES (159, 'Display Custom PAL #3', 'custom3pal', ' If you modified the custom3pal.tmpl and want to include it set to yes', 'no', 13, 11) failed with error: Duplicate entry '159' for key 1 INSERT INTO settings VALUES (160, 'Number of Top Posters to display', 'numtoppal', '', '5', 14, 11) failed with error: Duplicate entry '160' for key 1 INSERT INTO settings VALUES (161, 'Number of Last Comments to display', 'numcompal', '', '5', 15, 11) failed with error: Duplicate entry '161' for key 1 INSERT INTO settings VALUES (162, 'Number of Most Popular Photos to display', 'mostpoppal', '', '5', 16, 11) failed with error: Duplicate entry '162' for key 1 INSERT INTO settings VALUES (163, 'Use Integrated forum stylesheets?', 'forumstyle', 'If you use a forum like vB3 or Threads and want to use the intergated stylesheet option, choose Yes', 'no', 19, 1) failed with error: Duplicate entry '163' for key 1 INSERT INTO settings VALUES (164, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11) failed with error: Duplicate entry '164' for key 1 ALTER TABLE usergroups ADD canassign INT(3) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'canassign' ALTER TABLE categories ADD sortorder INT(2) DEFAULT '1' NOT NULL, ADD extra1 VARCHAR(250), ADD extra2 VARCHAR(250), ADD extra3 VARCHAR(250), ADD extra4 VARCHAR(250), ADD extra5 VARCHAR(250), ADD extra6 VARCHAR(250), ADD thumbnail INT(15) DEFAULT '0' NOT NULL failed with error: Duplicate column name 'sortorder' Done! You should continue to next step __________________________________________________________________ Preparing to update 4.8.2 database... Performing MySQL command: INSERT INTO settings VALUES (166,'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', 'no', 22, 1) ... Error: Duplicate entry '166' for key 1 Performing MySQL command: INSERT INTO settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', 'yes', 23, 1) ... Error: Duplicate entry '167' for key 1 Performing MySQL command: INSERT INTO settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1) ... Error: Duplicate entry '168' for key 1 Performing MySQL command: INSERT INTO settings VALUES (169,'GMT Offset', 'gmtoffset', 'If you are running VB and want the server to display the time as an offset of GMT (for example, to the timezone where your server is located), enter the offset here.', '-5', 25, 1) ... Error: Duplicate entry '169' for key 1 Performing MySQL command: INSERT INTO settings VALUES (170,'Enable IP Cache Timeout', 'ipcache', 'This variable is used to track IP addresses and userids for voting and viewing purposes. This is set in HOURS. 0 disables this setting', '0', 26, 1) ... Error: Duplicate entry '170' for key 1 Performing MySQL command: INSERT INTO settings VALUES (171,'PhotoPost Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 12) ... Error: Duplicate entry '171' for key 1 Performing MySQL command: INSERT INTO settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12) ... Error: Duplicate entry '172' for key 1 Performing MySQL command: INSERT INTO settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', 'newcelica.org', 3, 12) ... Error: Duplicate entry '173' for key 1 Performing MySQL command: INSERT INTO settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '2', 27, 1) ... Error: Duplicate entry '174' for key 1 Performing MySQL command: INSERT INTO settings VALUES (175,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', 'no', 29, 5) ... Error: Duplicate entry '175' for key 1 Performing MySQL command: INSERT INTO settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '0', 28, 1) ... Error: Duplicate entry '176' for key 1 Performing MySQL command: INSERT INTO settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '/data/www/newcelica.org/html/photopost/backups', 29, 1) ... Error: Duplicate entry '177' for key 1 Performing MySQL command: INSERT INTO settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/local/bin/mysqldump', 30, 1) ... Error: Duplicate entry '178' for key 1 Performing MySQL command: INSERT INTO settings VALUES (179,'Path to jpegtran (if used)', 'jpegtran', 'If you would like to clean any JPG image uploaded before being processed; enter the path to your jpegtran executable.', '/usr/local/bin/jpgtran', 18, 1) ... Error: Duplicate entry '179' for key 1 Performing MySQL command: INSERT INTO settings VALUES (180,'Path to jhead (if used)', 'jhead_command', 'This only needs to be set if you are extracting EXIF information from images. Full server path.', '/usr/local/bin/jhead', 19, 1) ... Error: Duplicate entry '180' for key 1 Performing MySQL command: INSERT INTO settings VALUES (181,'Gallery Open?', 'ppboards', '', 'open', 20, 1) ... Error: Duplicate entry '181' for key 1 Performing MySQL command: INSERT INTO settings VALUES (182,'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1) ... Error: Duplicate entry '182' for key 1 Performing MySQL command: REPLACE INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 13) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (183,'Show Peronsal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (184,'Allow users to move their own images?','usermove', '', 'no', 16, 2) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (84,'PhotoPost Version','pversion','','4.85',53,0) ... Successful! Performing MySQL command: REPLACE INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme-- Copyright 2007 All Enthusiast, Inc.',300,'0') ... Successful! Performing MySQL command: REPLACE INTO admingroups VALUES (12,'Cookie Settings') ... Successful! Performing MySQL command: REPLACE INTO admingroups VALUES (13,'Forum Settings') ... Successful! Performing MySQL command: ALTER TABLE usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit' Performing MySQL command: ALTER TABLE categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote' Performing MySQL command: UPDATE settings SET title='Allow users to delete their own images?',optionorder=17 WHERE id=91 ... Successful! Performing MySQL command: ALTER TABLE categories CHANGE catorder catorder MEDIUMINT(4) DEFAULT '9999' NOT NULL ... Successful! Performing MySQL command: UPDATE categories SET catorder=9999 WHERE catorder=0 AND cattype='a' ... Successful! Performing MySQL command: UPDATE settings SET section=13,optionorder=1 WHERE id=7 ... Successful! Performing MySQL command: UPDATE settings SET section=13,optionorder=2 WHERE id=41 ... Successful! Performing MySQL command: UPDATE settings SET section=13,optionorder=3 WHERE id=83 ... Successful! Performing MySQL command: UPDATE settings SET section=13,optionorder=4 WHERE id=163 ... Successful! Performing MySQL command: UPDATE settings SET section=13,optionorder=5 WHERE id=153 ... Successful! Upgrade complete! You should continue to next step __________________________________________________________________ Finally on -> This install script will upgrade your 4.8.5 or 4.8.6 release. Only run this upgrade if you have the 4.8.5 or 4.8.6 version of the database in place (either by previous upgrades or if upgrading in order to the latest). I get this: includes/config.php does not exist. Cannot continue.