| Member Verified Customer
Join Date: Sep 2004
Posts: 103
| Step 2 error
Step 2: MySQL error reported: [CREATE TABLE admlog (id int(10) NOT NULL auto_increment,adminuser varchar(50) NOT NULL default '',description varchar(255) NOT NULL default '',datestamp int(20) NOT NULL default '0',ip varchar(35) NOT NULL default '',PRIMARY KEY (id)) TYPE=MyISAM ]
Result: Table 'admlog' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE favorites (id int(12) NOT NULL auto_increment, userid int(8) NOT NULL default '0', photo int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (photo)) TYPE=MyISAM ]
Result: Table 'favorites' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE laston (cat smallint(4) NOT NULL default '0', userid mediumint(9) NOT NULL default '0', laston int(11) unsigned default NULL, PRIMARY KEY (cat,userid)) TYPE=MyISAM ]
Result: Table 'laston' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE exif (photoid INT(11) DEFAULT '0' NOT NULL, exifinfo TEXT) ]
Result: Table 'exif' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE categories (id int(12) NOT NULL auto_increment,catname varchar(255) NOT NULL default '',description varchar(255) default NULL,catorder tinyint(4) NOT NULL default '0',thumbs varchar(4) NOT NULL default 'yes',parent int(5) NOT NULL default '0',header varchar(200) default NULL,footer varchar(200) default NULL,headtags varchar(200) default NULL,private varchar(5) NOT NULL default 'no',ugnoview VARCHAR(255) NULL,ugnoupload VARCHAR(255) NULL,ugnopost VARCHAR(255) NULL,ugnoanno VARCHAR(255) NULL,children TEXT default NULL,lastpost INT(11) UNSIGNED,lastphoto INT(11) UNSIGNED,photos INT(11) UNSIGNED default '0',posts INT(11) UNSIGNED default '0',password VARCHAR(24),cattype varchar(4) NOT NULL default 'c',theme VARCHAR(32) NOT NULL,catdepth varchar(6) DEFAULT NULL,watermark varchar(250) NOT NULL default '', sortorder INT(2) DEFAULT '1' NOT NULL, extra1 VARCHAR(250), extra2 VARCHAR(250), extra3 VARCHAR(250), extra4 VARCHAR(250), extra5 VARCHAR(250), extra6 VARCHAR(250), thumbnail INT(15) DEFAULT '0' NOT NULL, PRIMARY KEY (id),KEY parent(parent)) TYPE=MyISAM ]
Result: Table 'categories' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO categories VALUES (1,'Main','',2,'no',0,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,'2',0,0,0,0,NULL,'c','','','','1',NULL,NULL,NULL,NULL,NULL,NULL,'0') ]
Result: Duplicate entry '1' for key 1
Database: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO categories VALUES (2,'A Category','Photos of a particular subject.',1,'yes',1,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,'c','','','','1',NULL,NULL,NULL,NULL,NULL,NULL,'0') ]
Result: Duplicate entry '2' for key 1
Database: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO categories VALUES (500,'Member Galleries','Individual user galleries - any photo category.',1,'yes',0,NULL,NULL,NULL,'no',NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL,'c','','','','1',NULL,NULL,NULL,NULL,NULL,NULL,'0') ]
Result: Duplicate entry '500' for key 1
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE comments (id int(11) NOT NULL auto_increment,username tinytext NOT NULL,userid mediumint(9) NOT NULL default '0',date int(15) NOT NULL default '0',rating float(12,2) default NULL,comment text NOT NULL,photo int(11) NOT NULL default '0',cat smallint(4) NOT NULL default '0',approved INT(2) DEFAULT '0' NOT NULL, ipaddress VARCHAR(32) DEFAULT '0', PRIMARY KEY (id),KEY photo(photo),KEY cat(cat)) TYPE=MyISAM ]
Result: Table 'comments' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE photos (id int(10) NOT NULL auto_increment,user varchar(50) NOT NULL default '',userid int(8) NOT NULL default '0',cat int(11) NOT NULL default '0',storeid int(12) NOT NULL default '0',storecat int(12) NOT NULL default '0',date int(15) NOT NULL default '0',title varchar(75) NULL default '',description text NULL,keywords varchar(150) default NULL,bigimage varchar(100) NOT NULL default '',width smallint(6) default NULL,height smallint(4) default NULL,filesize int(10) default '0',views int(10) NOT NULL default '0',medwidth int(12) default '0',medheight smallint(6) default '0',medsize mediumint(9) default '0',approved tinyint(2) NOT NULL default '0',lastpost int(15) NOT NULL default '0',rating float(12,2) NOT NULL default '0',watermarked varchar(5) NOT NULL default 'no',allowprint varchar(5) NOT NULL default 'yes',extra1 VARCHAR(255), extra2 VARCHAR(255), extra3 VARCHAR(255), extra4 VARCHAR(255), extra5 VARCHAR(255), extra6 VARCHAR(255), disporder INT(5) DEFAULT '99999' NOT NULL, ipaddress VARCHAR(32) DEFAULT '0', PRIMARY KEY (id),KEY userid(userid),KEY cat(cat),KEY bigimage(bigimage,cat)) TYPE=MyISAM ]
Result: Table 'photos' already exists
Database: josef13_gallery
Step 2: MySQL error reported: [CREATE TABLE settings (id int(11) NOT NULL auto_increment,title varchar(255) NOT NULL default '',varname varchar(25) NOT NULL default '',description varchar(150) NOT NULL default '',setting varchar(250) NOT NULL default '',optionorder int(3) NOT NULL default '0',section int(3) NOT NULL default '0', PRIMARY KEY (id)) TYPE=MyISAM ]
Result: Table 'settings' already exists
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (2,'Web site name','webname','','My Website',2,1) ]
Result: Duplicate entry '2' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (5,'Data directory virtual path','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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (6,'Full 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (7,'URL to your forums main directory (optional)','vbulletin','This is the virtual path to your forum installation.','http://www.domain.com/forum',7,1) ]
Result: Duplicate entry '7' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (37,'cright','cright','','Powered by: PhotoPost --replaceme--
Copyright © 2004 All Enthusiast, Inc.',300,'0') ]
Result: Duplicate entry '37' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (41,'User Registration System','vbversion','','vb2',12,1) ]
Result: Duplicate entry '41' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (61,'Use COPPA for registration?','coppa','','yes',3,8) ]
Result: Duplicate entry '61' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (66,'Allow new user registrations?','allowregs','','yes',8,8) ]
Result: Duplicate entry '66' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (83,'Forum database table prefix','dprefix','','',14,1) ]
Result: Duplicate entry '83' for key 1
Database: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (84,'PhotoPost Version','pversion','','4.5',53,0) ]
Result: Duplicate entry '84' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (91,'Allow users to move/delete their own images?','userdel','','no',12,2) ]
Result: Duplicate entry '91' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (94,'Do you want Members Gallery to show all of a users photos?','memformat','','yes',57,2) ]
Result: Duplicate entry '94' for key 1
Database: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (95,'Display headers during SlideShows?','slidehead','','yes',24,5) ]
Result: Duplicate entry '95' for key 1
Database: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (97,'Maximum multimedia upload size in Kb','mmuploadsize','','2000',10,6) ]
Result: Duplicate entry '97' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: MySQL error reported: [INSERT INTO settings VALUES (99,'Allow multimedia uploads?','allowmedia','','no',8,2) ]
Result: Duplicate entry '99' for key 1
Database: josef13_gallery
Step 2: 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: josef13_gallery
Step 2: 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: josef13_gallery
|