VBulletin UserID Prefixed on all picture files in /Data/500 directory?

[joe_s2k]

I just picked up the admin duties for my car club forum and have run into a problem with switching to a new server. I'm trying to move our photopost application files from one server to another, but am unable to match the filename in the DB to the actual filename in the data directory. The files in the /DATA/500 all have the Vbulletin Userid (Number) prefixed to the filename.

For example. My VBulletin Userid is 999
DatabaseTableValue: [PP_PHOTOS].[TITLE] = DSC02825
FileServerName: /photopost/data/500/999DSC02825.JPG

What do I need to do to make them see each other again. When I run the Scan DB utility, all of the records in the PP_PHOTOS table are deleted because they don't match up.

Any help would be greatly appreciated.

Thanks,
Joe

[Chuck S]

Try making sure you are running the proper version of the software and have ran all applicable upgrades needed. Looks to me here like you have moved servers updated the software but not ran the upgrade scripts OR you moved servers and did not update your server paths which would change on a server move. At any rate you can post urls here to show the issue

[joe_s2k]

First of all, thanks for the response.

I'm not sure what Photopost version we had on the old server, but I received the following errors when running the install.php.

Having a little dba experience, these errors seem to be mostly warnings regarding duplicate keys trying to be inserted into the photopost tables that already contains records with the same key values.

The other errors at the very bottom contain similar warning messages regarding the attempt to create tables that already exist.

Step 3: MySQL error reported: [INSERT INTO categories (id,catname,description,catorder,thumbs,parent,children) VALUES (1,'Main','',2,'no',0,'2')]
Result: Duplicate entry '1' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO categories (id,catname,description,catorder,thumbs,parent,children) VALUES (2,'A Category','Photos of a particular subject',1,'yes',1,'')]
Result: Duplicate entry '2' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO categories (id,catname,description,catorder,thumbs,parent,children) VALUES (500,'Member Galleries','Individual user galleries - any photo category',1,'yes',0,'')]
Result: Duplicate entry '500' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (1,'Title for your PhotoPost Application','galleryname','','My Photo Gallery',1,1)]
Result: Duplicate entry '1' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (2,'Web site name','webname','','My Website',2,1)]
Result: Duplicate entry '2' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (3,'Your Website URL (include http://)','domain','','http://www.domain.com',3,1)]
Result: Duplicate entry '3' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (4,'Administrator Email Address','adminemail','','admin@domain.com',4,1)]
Result: Duplicate entry '4' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (5,'URL to PhotoPost data directory','datadir','This is the web / virtual path to the data directory.','http://www.domain.com/photopost/data',5,1)]
Result: Duplicate entry '5' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (6,'Full SERVER PATH to PhotoPost data directory','datafull','Full path to the image files directory.','/path/to/your/photopost/data',6,1)]
Result: Duplicate entry '6' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (7,'URL to your forums main directory','vbulletin','This is the URL path to your forum installation.','http://www.domain.com/forum',1,13)]
Result: Duplicate entry '7' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (8,'Full path to Header Include file','header','To include an HTML file as the header, enter the full path.','/path/to/php/header.htm',8,1)]
Result: Duplicate entry '8' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (9,'Full path to the Footer include file','footer','To include an HTML file as the footer, enter the full path.','/path/to/php/footer.htm',9,1)]
Result: Duplicate entry '9' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (10,'Full path to HTML file containing head tags','headtags','','/path/to/php/headtags.htm',10,1)]
Result: Duplicate entry '10' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (11,'URL to PhotoPost PHP directory','maindir','','http://www.domain.com/photopost',11,1)]
Result: Duplicate entry '11' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (13,'Default number of comments per page','defaultposts','','15',1,5)]
Result: Duplicate entry '13' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (14,'Show Most Recent Additions on Index page?','mostrecent','','yes',4,9)]
Result: Duplicate entry '14' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (15,'Number of columns for thumbnail pages','thumbcols','','4',1,4)]
Result: Duplicate entry '15' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (18,'Thumbnail image max width and height in pixels','previewwidth','','100',1,6)]
Result: Duplicate entry '18' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (19,'Max allowable image width in pixels','maxwidth','','2500',2,6)]
Result: Duplicate entry '19' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (20,'Max allowable image height in pixels','maxheight','','2500',3,6)]
Result: Duplicate entry '20' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (21,'Trigger medium graphic height and width','biggraphic','An uploaded larger than this will create a medium image of this size.','600',4,6)]
Result: Duplicate entry '21' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright © 2006 All Enthusiast, Inc.',300,'0')]
Result: Duplicate entry '37' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (38,'Use email to notify users?','useemail','Users can be notified of photo approvals and deletions.','yes',1,2)]
Result: Duplicate entry '38' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (41,'User Registration System','vbversion','','vb2',2,13)]
Result: Duplicate entry '41' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (42,'Comments increment user post count?','cpostcount','','yes',1,7)]
Result: Duplicate entry '42' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (43,'Photo uploads increment user post count?','ppostcount','','yes',5,6)]
Result: Duplicate entry '43' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (44,'Save and display medium and large images?','bigsave','','yes',6,6)]
Result: Duplicate entry '44' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (45,'Number of columns for most recent additions section?','recentcols','','4',1,9)]
Result: Duplicate entry '45' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (46,'Number of photos to display in the most recent additions section?','recentnum','','12',2,9)]
Result: Duplicate entry '46' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (47,'Allow users to send e-Cards?','enablecard','','no',2,5)]
Result: Duplicate entry '47' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (48,'Require users to be registered to send an e-Card?','cardreg','','yes',3,5)]
Result: Duplicate entry '48' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (49,'URL to PhotoPost images directory','idir','','http://www.domain.com/images',13,1)]
Result: Duplicate entry '49' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (50,'Depth (number of levels) of categories to display.','catdepth','','1',2,3)]
Result: Duplicate entry '50' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (51,'Allow users to be notified of new posts via email?','usenotify','','yes',2,2)]
Result: Duplicate entry '51' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (58,'Show post count and photo details for cats without thumbs?','catdetails','','no',3,3)]
Result: Duplicate entry '58' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (61,'Use COPPA for registration?','coppa','','yes',3,8)]
Result: Duplicate entry '61' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (62,'Full Path to Registration Rules, or leave blank for default','rules','','',4,8)]
Result: Duplicate entry '62' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (63,'Require verification of email address upon registration?','emailverify','','yes',5,8)]
Result: Duplicate entry '63' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (64,'Your mailing address to receive COPPA permission forms?','address','','',6,8)]
Result: Duplicate entry '64' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (65,'Full path to COPPA rules file, or leave blank for default?','copparules','','',7,8)]
Result: Duplicate entry '65' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (66,'Allow new user registrations?','allowregs','','yes',8,8)]
Result: Duplicate entry '66' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (67,'Allow users to upload photos?','allowup','','yes',3,2)]
Result: Duplicate entry '67' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (68,'Allow users to post comments?','allowpost','','yes',4,2)]
Result: Duplicate entry '68' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (69,'Show recent photos in default location (bottom)? (if no, will display at top)','recentdefault','','yes',3,9)]
Result: Duplicate entry '69' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (70,'Your Commission Junction click-through URL','cjurl','','',6,2)]
Result: Duplicate entry '70' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (71,'Notify Admin of New Uploads?','uploadnotify','','yes',10,2)]
Result: Duplicate entry '71' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (72,'Show last photo thumbnail in member galleries listing?','membthumb','','yes',4,5)]
Result: Duplicate entry '72' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (75,'PhotoPost main table width, percent or pixels.','tablewidth','','100%',5,9)]
Result: Duplicate entry '75' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (76,'Require unique email addresses for user registration?','emailunique','','no',1,8)]
Result: Duplicate entry '76' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (78,'Show Random images on Index page?','disrandom','','no',4,3)]
Result: Duplicate entry '78' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (79,'Show Most Popular images on Index page?','dispopular','','no',5,3)]
Result: Duplicate entry '79' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (80,'Do you want to allow ZIP uploads?','allowzip','','no',5,2)]
Result: Duplicate entry '80' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (81,'PATH to UPLOADS directory?','zipuploaddir','','/path/to/uploads',16,1)]
Result: Duplicate entry '81' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (82,'URL to UPLOADS directory?','zipuploadurl','','http://www.yoursite.com/uploads',17,1)]
Result: Duplicate entry '82' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (83,'Forum database table prefix','dprefix','','',3,13)]
Result: Duplicate entry '83' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (84,'PhotoPost Version','pversion','','5.5',53,0)]
Result: Duplicate entry '84' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (86,'Enable watermarking of photos with overlay image?','annotate','','no',1,10)]
Result: Duplicate entry '86' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (87,'If enabled, position of overlay watermark on images.','gravity','','SouthEast',2,10)]
Result: Duplicate entry '87' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (88,'Quality setting for resizing/thumbnails?','imgquality','','70',7,6)]
Result: Duplicate entry '88' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (89,'If photo upload width or height exceeds maximums, resize upload down to max dimensions?','resizeorig','','yes',8,6)]
Result: Duplicate entry '89' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (90,'Full server path to watermark overlay image.','watermark','','',3,10)]
Result: Duplicate entry '90' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (91,'Allow users to delete their own images?','userdel','','no',17,2)]
Result: Duplicate entry '91' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (92,'Display Members Gallery on the main index page?','showmem','','yes',6,3)]
Result: Duplicate entry '92' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (93,'Require users to be registered to view images?','reqregister','','no',9,8)]
Result: Duplicate entry '93' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (94,'Do you want Members Gallery to show all of a users photos?','memformat','','yes',4,4)]
Result: Duplicate entry '94' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (95,'Display headers during SlideShows?','slidehead','','yes',24,5)]
Result: Duplicate entry '95' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (97,'Maximum multimedia upload size in Kb','mmuploadsize','','16000',10,6)]
Result: Duplicate entry '97' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (98,'Allow users to create Personal Albums?','allowpa','','yes',7,2)]
Result: Duplicate entry '98' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (99,'Allow multimedia uploads?','allowmedia','','no',8,2)]
Result: Duplicate entry '99' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (100,'Allow members to rate photos?','allowrate','','yes',20,5)]
Result: Duplicate entry '100' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (101,'Display new comments/photos indicator on index?','displaynew','','no',7,3)]
Result: Duplicate entry '101' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (102,'Display and extract EXIF information from images?','showexif','','no',9,6)]
Result: Duplicate entry '102' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (103,'Do you want to show the Members Gallery in List format?','memblist','','no',3,4)]
Result: Duplicate entry '103' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (104,'Do you want to prompt for optional info during registration?','getoptional','','yes',2,8)]
Result: Duplicate entry '104' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (105,'Do you want to be notified of all new comments?','notifyadmin','','no',9,2)]
Result: Duplicate entry '105' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (114,'Display filesize?','dispfs','','yes',11,5)]
Result: Duplicate entry '114' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (115,'Display views?','dispviews','','yes',12,5)]
Result: Duplicate entry '115' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (116,'Display date?','dispdate','','yes',13,5)]
Result: Duplicate entry '116' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (117,'Display dimensions?','dispdims','','yes',14,5)]
Result: Duplicate entry '117' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (118,'Display keywords?','dispkeys','','yes',15,5)]
Result: Duplicate entry '118' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (119,'Display description?','dispdesc','','yes',16,5)]
Result: Duplicate entry '119' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (120,'Display ratings that have no comments attached?','dispempty','','yes',17,5)]
Result: Duplicate entry '120' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (121,'Display title under photo?','disptitle','','yes',18,5)]
Result: Duplicate entry '121' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (122,'Display quickratings under photos?','dispquick','','yes',19,5)]
Result: Duplicate entry '122' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (123,'Do you want to allow people to download their favorites?','allowfavzip','','yes',11,2)]
Result: Duplicate entry '123' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (124,'Display # of comments indicator under thumbnails?','dispcoms','','yes',2,4)]
Result: Duplicate entry '124' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (125,'Display unapproved comments?','moderatecoms','','yes',21,5)]
Result: Duplicate entry '125' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (126,'How many file upload prompts do you want?','maxfiles','','1',13,6)]
Result: Duplicate entry '126' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (128,'Pixel size of borders for images/thumbnails','cellpadding','Thickness - set to 0 for no border','1',8,9)]
Result: Duplicate entry '128' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (129,'Color for image borders','framecolor','Color of the frame around images/thumbs','#000000',7,9)]
Result: Duplicate entry '129' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (130,'Select a theme for your website','theme','Choose from the available themes for your site layout','default',6,9)]
Result: Duplicate entry '130' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (131,'Show UBBCode on Photo page?','showubb','','no',25,6)]
Result: Duplicate entry '131' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (133,'Use Spider-friendly URLs?','spider','','no',15,1)]
Result: Duplicate entry '133' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (134,'Use Anti-leeching code?', 'right-click', 'Use Right-Click Disable JavaScript to try and prevent right-clicking images', 'no', 23, 5)]
Result: Duplicate entry '134' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (135,'Display number of viewers on categories?', 'displayonline', 'Adds a query to main index, but shows numbers of viewers per category', 'yes', 8, 3)]
Result: Duplicate entry '135' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (136,'Allow users to choose additional categories during upload?', 'optcats', '', 'no', 14, 6)]
Result: Duplicate entry '136' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (137,'Enable slideshows?', 'slideshow', '', 'yes', 22, 5)]
Result: Duplicate entry '137' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (138,'Enable next and previous photo previews?', 'nextbox', '', 'yes', 26, 5)]
Result: Duplicate entry '138' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (139,'How many days after an eCard has been read do you want to keep it?', 'cardage', '', '7', 14, 2)]
Result: Duplicate entry '139' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (140,'Expire eCards after how many days (even if not read)?', 'cardexpire', '', '90', 13, 2)]
Result: Duplicate entry '140' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT 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', 11, 6)]
Result: Duplicate entry '141' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT 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', 12, 6)]
Result: Duplicate entry '142' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (143,'Select a border for your thumbnails','thumbborder','Choose from the available borders for your thumbnails','thumbnail',9,9)]
Result: Duplicate entry '143' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (144,'Sidebar Placement.?', 'sidebar', 'Set this to off for no sidebar or left or right depending on your tastes.', 'left', 1, 11)]
Result: Duplicate entry '144' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (145,'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11)]
Result: Duplicate entry '145' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (146,'UnderCategory PAL', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11)]
Result: Duplicate entry '146' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (147,'Statistics PAL', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11)]
Result: Duplicate entry '147' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (148,'Top Posters PAL', 'topposterspal', ' Display Top Posters Pal?', 'no', 7, 11)]
Result: Duplicate entry '148' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (149,'Random Image PAL', 'randompal', ' Display Random Image?', 'yes', 8, 11)]
Result: Duplicate entry '149' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (150,'Highest Ratings PAL', 'ratingspal', ' Display Highest Ratings?', 'no', 9, 11)]
Result: Duplicate entry '150' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (151,'Show Sidebar on Index Page?', 'sidebar_index', '', 'yes', 2, 11)]
Result: Duplicate entry '151' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (152,'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showphoto,showmembers and showgallery pages?', 'yes', 3, 11)]
Result: Duplicate entry '152' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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', 5, 13)]
Result: Duplicate entry '153' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (154,'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5)]
Result: Duplicate entry '154' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (155,'Show Avatars', 'showavatar', 'When available, show avatars?', 'yes', 28, 5)]
Result: Duplicate entry '155' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (156,'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3)]
Result: Duplicate entry '156' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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', 10, 11)]
Result: Duplicate entry '157' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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', 11, 11)]
Result: Duplicate entry '158' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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', 12, 11)]
Result: Duplicate entry '159' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (160,'Number of Top Posters to display', 'numtoppal', '', '5', 13, 11)]
Result: Duplicate entry '160' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (161,'Number of Last Comments to display', 'numcompal', '', '5', 14, 11)]
Result: Duplicate entry '161' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (162,'Number of Highest Rated Photos to display', 'mostpoppal', '', '5', 15, 11)]
Result: Duplicate entry '162' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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', 4, 13)]
Result: Duplicate entry '163' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (164,'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11)]
Result: Duplicate entry '164' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (165,'Your SMF Cookie Name', 'smfcookie', 'Only needed for users of SMF forums', '', 5, 12)]
Result: Duplicate entry '165' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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)]
Result: Duplicate entry '166' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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)', '0', 23, 1)]
Result: Duplicate entry '167' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (168,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1)]
Result: Duplicate entry '168' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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.', '0', 25, 1)]
Result: Duplicate entry '169' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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)]
Result: Duplicate entry '170' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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)]
Result: Duplicate entry '171' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (172,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 12)]
Result: Duplicate entry '172' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (173,'PhotoPost Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '', 3, 12)]
Result: Duplicate entry '173' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (174,'Debug Setting', 'debug', 'How do you want PhotoPost to handle errors?', '0', 27, 1)]
Result: Duplicate entry '174' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (175,'Enable on-the-fly image protection', 'onthefly', 'This option uses the watermark.php script to serve images', 'no', 29, 5)]
Result: Duplicate entry '175' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (176,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '0', 28, 1)]
Result: Duplicate entry '176' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (177,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '', 29, 1)]
Result: Duplicate entry '177' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (178,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '/usr/bin/mysqldump', 30, 1)]
Result: Duplicate entry '178' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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/bin/jpegtran', 18, 1)]
Result: Duplicate entry '179' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [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/bin/jhead', 19, 1)]
Result: Duplicate entry '180' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (181,'Gallery Open?', 'ppboards', '', 'open', 20, 1)]
Result: Duplicate entry '181' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (182,'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1)]
Result: Duplicate entry '182' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (183,'Show Personal Albums Index link under Members Gallery?', 'showalbum', 'Adds a text link to the Albums index into the Members Gallery description', 'yes', 10, 3)]
Result: Duplicate entry '183' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (184,'Allow users to move their own images?','usermove','','no',16,2)]
Result: Duplicate entry '184' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (185,'Use embedded multimedia?','embededmm', '', 'yes', 5, 5)]
Result: Duplicate entry '185' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (186,'Degrees to rotate portrait thumbnails? (set to 0 for no rotation)','rotatep', 'For users of ImageMagick only', '0', 15, 6)]
Result: Duplicate entry '186' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (187,'Degrees to rotate landscape thumbnails? (set to 0 for no rotation)','rotatel', 'For users of ImageMagick only', '0', 16, 6)]
Result: Duplicate entry '187' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (188,'If rotating, long side for mini thumbnail?','minil', 'If rotating your thumbnails, we need to create a mini thumbnail', '50', 17, 6)]
Result: Duplicate entry '188' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (189,'If rotating, short side for mini thumbnail?','minis', 'If rotating your thumbnails, we need to create a mini thumbnail', '27', 18, 6)]
Result: Duplicate entry '189' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (190,'Allow downloads from URLs?','downurl', '', 'yes', 19, 6)]
Result: Duplicate entry '190' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (192,'Number of top level categories to show on index page?','indexcats', 'Set to 0 to show all top level categories on one page', '0', 11, 3)]
Result: Duplicate entry '192' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (193,'Use popup window for BIG images?','bigpopup', 'If you want BIG photos to appear using a popup window, set to yes', 'no', 31, 5)]
Result: Duplicate entry '193' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (194,'Do you want to use the forum-style layout?','pplayout', 'Yes is the default setting, No uses the thumbnail gallery layout', 'yes', 18, 3)]
Result: Duplicate entry '194' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (195,'Do you want to enable the Announcement box?','news', '', 'no', 12, 3)]
Result: Duplicate entry '195' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (196,'Title for the Announcement box?','newstitle', '', 'News', 13, 3)]
Result: Duplicate entry '196' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (197,'Contents of the Announcement box?','newscopy', 'This block can contain HTML code (200 character limit)', '', 14, 3)]
Result: Duplicate entry '197' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (198,'Use 24 hour time format?','timeformat', 'You can elect to have time displayed as HH:MMam or using the 24 hour clock', 'no', 32, 1)]
Result: Duplicate entry '198' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (199,'Do you want moderators to have global rights?','modprivs', 'Set this to NO if you want to assign moderators to specific categories', 'yes', 18, 2)]
Result: Duplicate entry '199' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (200,'Display Moderators as part of the category description?','dispmods', 'Set this to YES if you want the moderators listed on the index page under a category', 'no', 15, 3)]
Result: Duplicate entry '200' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (201,'Use photo view caching to reduce view update queries on high load sites?','viewcache', 'Set this to YES if you want to enable the view caching code which caches photo view updates', 'no', 33, 1)]
Result: Duplicate entry '201' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (202,'Min allowable image width in pixels','minwidth','','0',21,6)]
Result: Duplicate entry '202' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (203,'Min allowable image height in pixels','minheight','','0',22,6)]
Result: Duplicate entry '203' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (204,'Mobile Phone Integration: EMail address for images','mobemail','EMail address users should send their images to','',23,6)]
Result: Duplicate entry '204' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (205,'Show Last Comments column on Index?','showcoms','','yes',16,3)]
Result: Duplicate entry '205' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (206,'Show Last Photo column on Index','showlast','','yes',17,3)]
Result: Duplicate entry '206' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (207,'Original Image storage directory URL','origdir','Typically this path matches your DATA directory URL, unless you want to store your original images seperatly from your thumbnails/medium images.','http://www.domain.com/photopost/data',34,1)]
Result: Duplicate entry '207' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (208,'Orignial Image storage directory server path','origfull','Typically this path matches your DATA directory server path, unless you want to store your original images seperatly from your thumbnails/medium images.','/path/to/your/photopost/data',35,1)]
Result: Duplicate entry '208' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (209,'When using on-the-fly image generation, do you want to overlay the watermark image?','overwater','You can use this feature for on-the-fly watermarks in combination with the on-the-fly image generation.','no',30,5)]
Result: Duplicate entry '209' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (210,'Default location of the photo previews?','filmstrip','Determines the location of the film-strip previews on the showphoto page.','top',26,5)]
Result: Duplicate entry '210' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (211,'Minutes to cache index page data for featured photos, statistics and PALs?','cachetimeout','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)]
Result: Duplicate entry '211' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (212,'Show Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)]
Result: Duplicate entry '212' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (213,'Show html code to display photos?','showhtml','Do you want to show the img src html tag for a photo?','no',6,5)]
Result: Duplicate entry '213' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (214,'Show direct links to photos?','showdirect','Do you want to display the page link to a photo?','no',7,5)]
Result: Duplicate entry '214' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (215,'Load limit for server?','loadlimit','If running *nix and you want to disable your forums when load goes over a certain limit; place the high limit here.','0',35,1)]
Result: Duplicate entry '215' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (216,'Default number of thumbnail rows?','thumbrows','How many rows of thumbnails do you want to display by default on this page?','3',5,4)]
Result: Duplicate entry '216' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (217,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','yes',36,1)]
Result: Duplicate entry '217' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (218,'Display Featured Photos on this page?','features','On larger sites this option can slow down the showgallery page. Turn off to speed up this page.','yes',8,5)]
Result: Duplicate entry '218' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO settings VALUES (220,'Number of minutes a user is allowed to edit a comment?','comtimeout','0 to disable. 86400 is one day.','0',2,7)]
Result: Duplicate entry '220' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (2,'Latest','ORDER BY disporder,date DESC')]
Result: Duplicate entry '2' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (3,'Most Views','ORDER BY disporder,views DESC')]
Result: Duplicate entry '3' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (1,'Most Active','ORDER BY disporder,lastpost DESC')]
Result: Duplicate entry '1' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (4,'Most Popular','ORDER BY disporder,rating DESC, views DESC')]
Result: Duplicate entry '4' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (6,'Random', 'ORDER BY disporder,RAND()')]
Result: Duplicate entry '6' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (5,'Least Popular', 'ORDER BY disporder,rating,views')]
Result: Duplicate entry '5' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (7,'Image Name', 'ORDER BY disporder,bigimage')]
Result: Duplicate entry '7' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sort VALUES (8,'Title', 'ORDER BY disporder,title')]
Result: Duplicate entry '8' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (1,'Global Options')]
Result: Duplicate entry '1' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (2,'Admin Options')]
Result: Duplicate entry '2' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (3,'Index Options')]
Result: Duplicate entry '3' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (4,'Show Gallery Options')]
Result: Duplicate entry '4' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (5,'Show Photo Options')]
Result: Duplicate entry '5' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (6,'Upload Photo Options')]
Result: Duplicate entry '6' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (7,'Comments Options')]
Result: Duplicate entry '7' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (8,'Registration Options')]
Result: Duplicate entry '8' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (9,'Layout Options')]
Result: Duplicate entry '9' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (10,'Watermark Options')]
Result: Duplicate entry '10' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (11,'Sidebar Settings')]
Result: Duplicate entry '11' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (12,'Cookie Settings')]
Result: Duplicate entry '12' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO admingroups VALUES (13,'Forum Settings')]
Result: Duplicate entry '13' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sortmemb VALUES (2,'Date (newest first)','ORDER BY maxdate DESC')]
Result: Duplicate entry '2' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sortmemb VALUES (3,'Views (high to low)','ORDER BY tviews DESC')]
Result: Duplicate entry '3' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sortmemb VALUES (1,'Most Active','ORDER BY maxlast DESC')]
Result: Duplicate entry '1' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO sortmemb VALUES (4,'Alphabetical Order','ORDER BY user ASC')]
Result: Duplicate entry '4' for key 1
Database: "database name removed from listing"

Step 3: MySQL error reported: [CREATE TABLE extrafields (id INT(12) NOT NULL AUTO_INCREMENT, cat INT(12), fieldname VARCHAR(255), fieldtype VARCHAR(2), fieldoptions TEXT, PRIMARY KEY (id) )]
Result: Table 'extrafields' already exists
Database: "database name removed from listing"

Step 3: MySQL error reported: [CREATE TABLE photoextras (id INT(12) NOT NULL AUTO_INCREMENT, photo INT(12), extraid INT(12), selection TEXT, PRIMARY KEY (id) )]
Result: Table 'photoextras' already exists
Database: "database name removed from listing"

Step 3: MySQL error reported: [CREATE TABLE cache (id tinyint(1) NOT NULL default '1', timestamp int(15) NOT NULL default '0', statscache mediumtext, recentcache mediumtext, popularcache mediumtext, randomcache mediumtext, calcache mediumtext, catcache mediumtext, catprops mediumtext, PRIMARY KEY (id), KEY id (id)) TYPE=MyISAM]
Result: Table 'cache' already exists
Database: "database name removed from listing"

Step 3: MySQL error reported: [INSERT INTO cache VALUES (1,0,null,null,null,null,null,null,null)]
Result: Duplicate entry '1' for key 1
Database: "database name removed from listing"

Database setup completed, but you aren't finished quite yet.


There were errors during the installation of the database. Review your errors before continuing as the errors may prevent PhotoPost from functioning properly.

The final installation step will help you begin configuring PhotoPost for your server.
Now you must choose whether you intend to use PhotoPost's Internal registration system, or a third party's, to register yourself and your users to grant access to upload photos and post comments,

If you do not own a third party forum program listed below, or you do not wish PhotoPost to work with those applications, then choose:


PhotoPost Internal User Registration
If you want PhotoPost to use vBulletin, UBBThreads, DCForum, InvisionBoard, IkonBoard or phpbb2/Nuke/PostNuke existing user database and registration system, choose:



External User Registration
(vBulletin, UBBT6, DCForums, IB, Ikon, SMF, phpBB2 or Nuke)

This is where I'm running into problems. We have since changed our DNS entry to point to our new server and can't access our old VBulletin forums. I'm working on getting a subdomain setup that points back to our old server so complete the External User Registration portion of the install. In the meantime, I've tried to point the paths to the new server.

After entering the "correct" information and pressing the [Configure Photopost] button, I receive this message.

Photo Gallery Message
We're sorry, but the system experienced an unrecoverable error. Please try again later.

I can't even get into the Photopost Admin on the OLD server due to errors in the scripts. The photopost works fine on the new server.

Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /home/s2kciqmm/public_html/photopost/header-inc.php on line 64

Warning: require(./global.php) [function.require]: failed to open stream: No such file or directory in /home/s2kciqmm/public_html/photopost/header-inc.php on line 65

Fatal error: require() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/s2kciqmm/public_html/photopost/header-inc.php on line 65

Again, I'm trying to perform this upgrade on the "old" server so that I can export the data and restore it on the new server and try to match the table structures for an easy export/import process.

Since the [PHOTOS] table structure is different between the Photopost versions on both servers(I have installed the new Photopost on the new server successfully), I have exported the data and modified the PHOTOS.SQL export file to include the new fields that have been appended in the updated [PHOTOS] table. I was then able to successfully load the PHOTOS.SQL into the table in the new server without any errors.

The Photopost Admin stats on the NEW server are:

Registered Users 6,226 Comments/Ratings 316
Image Space Used 3,803.6 mb Total Photos 11,288
Total disk space used by the DATA directory 4,764.17 mb
Number of Albums 204 Photos in Albums 0

So maybe this "brute force" method of getting the data into the new table is causing the disconnect.

I have copied the entire Photopost directory and all it's subdirectories to the new server.

The file server directory stuctures are as follows:

old server: /home/s2kciqmm/public_html/photopost
new server: /var/www/html/forums/photopost

Let me know if you need anymore information.



Thanks again for your assistance.

Joe

[Chuck S]

Well see you need to work on a functional copy and perform an upgrade not an install

To get photopost up on the old server just correct your vbulletin forums server path in config-int.php and then go about performing a normal upgrade on Photopost once your operational on the old server you can attempt the steps needed to move the application to a new server. I think starting out with a broken install and moving said broken install is just going to compound your issue so lets work on getting the old one working cause if that works then moving is simply a process of moving all the files and database and then altering the config files with the proper new database info and server paths etc and logging in and changing the data and uploads paths to the new paths on the new server and saving them and then going to the storage options and hitting revert and save twice to load the new paths you changed in global options

[joe_s2k]

So I need to use something other than the install.php file? Everything I've read pointed to "Install a fresh copy". That could be the problem.

What's the upgrade process?

[Chuck S]

Upgrade instructions are located in the documentation folder. You can not use an old database and new files without upgrading.

[joe_s2k]

Originally Posted by Chuck S

Upgrade instructions are located in the documentation folder. You can not use an old database and new files without upgrading.

That makes perfect sense. It did seem odd that the "fresh install" was the only installation option I found. It might help if they could add a "How to upgrade from a previous version of Photopost" link on the Support page.

I'll take a look at the documentation and work on it tonight.

Thanks again for your help.

Joe

[joe_s2k]

One more question. So how I can tell what version I had prior to uploading the files for the new version?

[Chuck S]

You can look in your database settings table for the varname version. Your also safe to check your data directories and tell me if they have thumbs medium and mini subdirectories under them

[joe_s2k]

Thanks.

I'll take a look at them when I get back home. The firewall at work prevents me from doing any "outside" work.

Does Photopost allow users to download prior versions? I'm thinking about recreating our old server setup on the new server and performing the UPGRADE as you recommended. The only problem is that I don't have a copy of the previous Photopost version.

I appreciate your help today.

[Chuck S]

If your upgrading you dont need the prior version only the actual data directory and database

[joe_s2k]

Well, that should make it easier. I'll see what I can do tonight.