getting huge errors when running the upgrade script 4.8 -> 5.3

tribedude · March 30th, 2006, 01:48 PM

So I downloaded the latest version and followed the directions in the documents folder as it related to upgrades, including filling in the data in the config-inc.php file. At the first screen I get this:

Performing MySQL command: INSERT INTO pp_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 pp_settings VALUES (167,'Enable ZLIB page compression', 'compression', 'Set to on if you want to enable Zlib page compression (and it is supported)', 'no', 23, 1) ... Error: Duplicate entry '167' for key 1
Performing MySQL command: INSERT INTO pp_settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', '', 24, 1) ... Error: Duplicate entry '168' for key 1
Performing MySQL command: INSERT INTO pp_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.', '', 25, 1) ... Error: Duplicate entry '169' for key 1
Performing MySQL command: INSERT INTO pp_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', '', 26, 1) ... Error: Duplicate entry '170' for key 1
Performing MySQL command: INSERT INTO pp_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 pp_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 pp_settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '', 3, 12) ... Error: Duplicate entry '173' for key 1
Performing MySQL command: INSERT INTO pp_settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '', 27, 1) ... Error: Duplicate entry '174' for key 1
Performing MySQL command: INSERT INTO pp_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 pp_settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '', 28, 1) ... Error: Duplicate entry '176' for key 1
Performing MySQL command: INSERT INTO pp_settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '', 29, 1) ... Error: Duplicate entry '177' for key 1
Performing MySQL command: INSERT INTO pp_settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '', 30, 1) ... Error: Duplicate entry '178' for key 1
Performing MySQL command: INSERT INTO pp_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.', '', 18, 1) ... Error: Duplicate entry '179' for key 1
Performing MySQL command: INSERT INTO pp_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.', '', 19, 1) ... Error: Duplicate entry '180' for key 1
Performing MySQL command: INSERT INTO pp_settings VALUES (181,'Gallery Open?', 'ppboards', 'Yes for Open, No for Closed', '', 20, 1) ... Error: Duplicate entry '181' for key 1
Performing MySQL command: INSERT INTO pp_settings VALUES (182,'Message displayed when closed', 'closedmsg', '', '', 21, 1) ... Error: Duplicate entry '182' for key 1
Performing MySQL command: REPLACE INTO pp_settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 13) ... Successful!
Performing MySQL command: REPLACE INTO pp_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 pp_settings VALUES (184,'Allow users to move their own images?','usermove', '', 'no', 16, 2) ... Successful!
Performing MySQL command: REPLACE INTO pp_settings VALUES (84,'PhotoPost Version','pversion','','4.85',53,0) ... Successful!
Performing MySQL command: REPLACE INTO pp_settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright 2006 All Enthusiast, Inc.',300,'0') ... Successful!
Performing MySQL command: REPLACE INTO pp_admingroups VALUES (12,'Cookie Settings') ... Successful!
Performing MySQL command: REPLACE INTO pp_admingroups VALUES (13,'Forum Settings') ... Successful!
Performing MySQL command: ALTER TABLE pp_usergroups ADD uplimit INT(5) DEFAULT '0' NOT NULL ... Error: Duplicate column name 'uplimit'
Performing MySQL command: ALTER TABLE pp_categories ADD ugnovote VARCHAR(255) NULL AFTER ugnopost ... Error: Duplicate column name 'ugnovote'
Performing MySQL command: UPDATE pp_settings SET title='Allow users to delete their own images?',optionorder=17 WHERE id=91 ... Successful!
Performing MySQL command: ALTER TABLE pp_categories CHANGE catorder catorder MEDIUMINT(4) DEFAULT '9999' NOT NULL ... Successful!
Performing MySQL command: UPDATE pp_categories SET catorder=9999 WHERE catorder=0 AND cattype='a' ... Successful!
Performing MySQL command: UPDATE pp_settings SET section=13,optionorder=1 WHERE id=7 ... Successful!
Performing MySQL command: UPDATE pp_settings SET section=13,optionorder=2 WHERE id=41 ... Successful!
Performing MySQL command: UPDATE pp_settings SET section=13,optionorder=3 WHERE id=83 ... Successful!
Performing MySQL command: UPDATE pp_settings SET section=13,optionorder=4 WHERE id=163 ... Successful!
Performing MySQL command: UPDATE pp_settings SET section=13,optionorder=5 WHERE id=153 ... Successful!

What does this mean? Can I proceed or is the upgrade not working?

tribedude · March 30th, 2006, 02:03 PM

well I proceeded and although it said the upgrade completed, now I have a completely blank gallery with no categories or thumbnails or images. I sftpd in and see that the images stillexist in the data directory however.

What do I do, do a fresh install?

Run the upgrade again?

This sucks

Chuck S · March 30th, 2006, 04:32 PM

duplicate errors mean you ran the upgrade already.

You ran the 485 upgrade more than once if your missing images. As the upgrade instructions state about taking a backup before upgrading go ahead and restore a backup of your photos table and run the 485 upgrade forward only once.

tribedude · March 30th, 2006, 04:40 PM

I only backed up the data folder. I did not back up the entire gallery directory. The database function did not work in the previous version when I tried to run it from the admin control panel. The upgrade I did seems to work (I am not getting errors), and it says the version is 5.3. It's just that there are no images or thumbnails in my gallery any more. The config settings seem OK too.

I didn't have that many galleries. DO I just upload the pics again to re-add the images and thumbnails? Or is there a way to get it to recognize the existing data file that seems to have all the images in it...?

Chuck S · March 30th, 2006, 05:19 PM

If you do not have a mysql backup you need to reupload the photos

Ask your host if they have a backup of the database.