Installing classifieds...Step 3 when it writes to database

horsetrailertalk · July 17th, 2006, 10:53 AM

i get a page of errors that says the tables already exists.

I have deleted these from the database and changed the pre fix....ran again, and it keeps saying the same thing.

I can't find what to change in the config file to change it.

Why is trying to write them twice therefore creating these already exist errors?

horsetrailertalk · July 17th, 2006, 01:58 PM

My install goes like this:

Step One is setting up the Config File
Step Two is it successfully found the mogrify
Step Three is writes the database and thats when I get a whole page of everything already exists

It never asks me about configuration with Vbulletin....

Chuck S · July 17th, 2006, 02:27 PM

You need to wait for step 3 to complete as that takes a while since it also installs the zipcode database and then it goes to step 4 and you pick the integration

horsetrailertalk · July 17th, 2006, 02:57 PM

Quote:

Originally Posted by Chuck S

You need to wait for step 3 to complete as that takes a while since it also installs the zipcode database and then it goes to step 4 and you pick the integration

still just a page of duplicate entries....

nothing that goes to step and asks me for vb integration.

horsetrailertalk · July 17th, 2006, 03:19 PM

at what part of the install it is suppose to ask for integration? by the way...the config-intc file had all my correct info on it when i ftp'd it up.

I also CHMOD the config and config-intc to 777

Chuck S · July 17th, 2006, 04:12 PM

did you scroll to the bottom of the page? Once step3 completes there is a box which asks which integration internal or external just like Photopost

horsetrailertalk · July 17th, 2006, 04:26 PM

Quote:

Originally Posted by Chuck S

did you scroll to the bottom of the page? Once step3 completes there is a box which asks which integration internal or external just like Photopost

talk to you in a few hours

horsetrailertalk · July 17th, 2006, 04:32 PM

Step 3: MySQL error reported: [CREATE TABLE class_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 'class_admlog' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_favorites (id smallint(4) NOT NULL auto_increment, userid int(8) NOT NULL default '0', product int(11) NOT NULL default '0', PRIMARY KEY (id), KEY parent (product)) TYPE=MyISAM]
Result: Table 'class_favorites' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_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 'class_laston' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_categories (id smallint(4) 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,ugnoview VARCHAR(255) NULL,ugnoupload VARCHAR(255) NULL,ugnopost VARCHAR(255),ugnoanno VARCHAR(255) NULL,template INT(5) NOT NULL default '0',extra1 VARCHAR(64) NULL,extra2 VARCHAR(64) NULL,extra3 VARCHAR(64) NULL,extra4 VARCHAR(64) NULL,extra5 VARCHAR(64) NULL,extra6 VARCHAR(64) NULL,children TEXT default NULL,lastproduct INT(11) UNSIGNED,products INT(11) UNSIGNED default '0',posts INT(11) UNSIGNED default '0', adcost float(12,2) default '0' NOT NULL, adhigh float(12,2) default '0' NOT NULL, adbold float(12,2) default '0' NOT NULL, adital float(12,2) default '0' NOT NULL, allowbid varchar(3) default 'no' NOT NULL,moderators TEXT default NULL, thumbnail int(15) NOT NULL default '0',intro VARCHAR(3) default 'no' NOT NULL, introtitle VARCHAR(128) DEFAULT NULL, introcopy TEXT DEFAULT NULL, theme VARCHAR(32) NOT NULL, sortorder INT(2) NOT NULL DEFAULT '1', frames VARCHAR(32) DEFAULT NULL, PRIMARY KEY (id),KEY parent(parent)) TYPE=MyISAM]
Result: Table 'class_categories' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
Result: Duplicate entry '1' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
Result: Duplicate entry '2' for key 1
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_comments (id int(11) NOT NULL auto_increment, username varchar(255) NOT NULL default '', userid mediumint(9) NOT NULL default '0', date int(15) NOT NULL default '0', comment text NOT NULL, product int(11) NOT NULL default '0', cat int(11) NOT NULL default '0', approved int(2) NOT NULL default '0', ipaddress VARCHAR(32) default '', PRIMARY KEY (id), KEY product (product), KEY cat (cat) ) TYPE=MyISAM]
Result: Table 'class_comments' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_products (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',date int(15) NOT NULL default '0',title varchar(255) NULL default '',description text NULL,keywords varchar(150) default NULL,bigimage varchar(100) NOT NULL default '',bigimage2 varchar(100) NOT NULL default '',bigimage3 varchar(100) NOT NULL default '',bigimage4 varchar(100) NOT NULL default '',bigimage5 varchar(100) NOT NULL default '',bigimage6 varchar(100) NOT NULL default '',views int(10) NOT NULL default '0',approved tinyint(2) NOT NULL default '0',price float(12,2) NOT NULL default '0.00',rating varchar(24) NOT NULL default '0',watermarked varchar(5) NOT NULL default 'no',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,enddate int(15) NOT NULL default '0',status int(15) NOT NULL default '0', ipaddress VARCHAR(32) default '', zipcode VARCHAR(5) NULL, adoptions INT(6) default '0' NOT NULL, isauction INT(2) default '0' NOT NULL, highbidder INT(12) default '0' NOT NULL, maxbid float(16,2) default '0' NOT NULL, numbids INT(6) default '0' NOT NULL, paid INT(1) default '0' NOT NULL, duration INT(3) DEFAULT '30' NOT NULL, currency VARCHAR(255) DEFAULT 'USD' NOT NULL, buyit VARCHAR(3) NOT NULL default 'no', PRIMARY KEY (id),KEY userid(userid),KEY cat(cat),KEY bigimage(bigimage,cat)) TYPE=MyISAM]
Result: Table 'class_products' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_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 'class_settings' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (1,'Title for your PhotoPost Classifieds','galleryname','','PhotoPost Classifieds',1,1)]
Result: Duplicate entry '1' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (2,'Web site name','webname','','My Website',2,1)]
Result: Duplicate entry '2' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (3,'Your Website URL (include http://)','domain','','http://www.domain.com',3,1)]
Result: Duplicate entry '3' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (4,'Administrator Email Address','adminemail','','admin@domain.com',4,1)]
Result: Duplicate entry '4' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (5,'Data directory virtual path','datadir','This is the web / virtual path to the data directory.','http://www.domain.com/ppclassifieds/data',25,1)]
Result: Duplicate entry '5' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (6,'Full path to PhotoPost Classifieds 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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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',1,14)]
Result: Duplicate entry '7' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (11,'URL to PhotoPost Classifieds PHP directory','maindir','','http://www.domain.com/ppclassifieds',11,1)]
Result: Duplicate entry '11' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (13,'Default number of comments per page','defaultposts','','15',1,5)]
Result: Duplicate entry '13' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (14,'Show Most Recent Additions on Index page?','mostrecent','','yes',4,9)]
Result: Duplicate entry '14' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (15,'Number of columns for thumbnail pages','thumbcols','','4',1,4)]
Result: Duplicate entry '15' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (18,'Thumbnail image max width and height in pixels','previewwidth','','100',1,6)]
Result: Duplicate entry '18' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (19,'Maximium width of preview image on showpoduct page','maxwidth','This should not be left blank, 250 is a good sized preview image','250',2,6)]
Result: Duplicate entry '19' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (20,'Maximium height of preview image on showpoduct page','maxheight','This should not be left blank, 250 is a good sized preview image','250',3,6)]
Result: Duplicate entry '20' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (21,'Maximium size for a supersized image? (Larger images will be resized down)','maxsupersize','Max image size for the supersized images stored on the server.','250',4,6)]
Result: Duplicate entry '21' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (33,'Display product stats on index page?','stats','','yes',1,3)]
Result: Duplicate entry '33' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (37,'cright','cright','','Powered by: PhotoPost Classifieds --replaceme--
Copyright 2006 All Enthusiast, Inc.',300,'0')]
Result: Duplicate entry '37' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (38,'Use email to notify users?','useemail','Users can be notified of product approvals and deletions.','yes',1,2)]
Result: Duplicate entry '38' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (41,'User Registration System','vbversion','','sellerspost',14,2)]
Result: Duplicate entry '41' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (45,'Number of columns for most recent additions section?','recentcols','','4',1,9)]
Result: Duplicate entry '45' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (46,'Number of products to display in the most recent additions section?','recentnum','','12',2,9)]
Result: Duplicate entry '46' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (49,'URL to PhotoPost Classifieds images directory','idir','','http://www.domain.com/images',13,1)]
Result: Duplicate entry '49' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (50,'Depth (number of levels) of categories to display.','catdepth','','1',2,3)]
Result: Duplicate entry '50' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (57,'Exclude admin uploads from product approval process?','adminexclude','','yes',101,4)]
Result: Duplicate entry '57' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (58,'Show post count and ad details for cats without thumbs?','catdetails','','no',3,3)]
Result: Duplicate entry '58' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (61,'Use COPPA for registration?','coppa','','yes',3,8)]
Result: Duplicate entry '61' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (62,'Full Path to Registration Rules, or leave blank for default','rules','','',4,8)]
Result: Duplicate entry '62' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (63,'Require verification of email address upon registration?','emailverify','','yes',5,8)]
Result: Duplicate entry '63' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (64,'Your mailing address to receive COPPA permission forms?','address','','',6,8)]
Result: Duplicate entry '64' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (66,'Allow new user registrations?','allowregs','','yes',8,8)]
Result: Duplicate entry '66' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (67,'Allow users to upload ads?','allowup','','yes',3,2)]
Result: Duplicate entry '67' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (68,'Allow users to post comments?','allowpost','','yes',4,2)]
Result: Duplicate entry '68' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (69,'Show recent ads in default location (bottom)? (if no, will display at top)','recentdefault','','yes',3,9)]
Result: Duplicate entry '69' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (70,'Your Commission Junction click-through URL','cjurl','','',6,2)]
Result: Duplicate entry '70' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (71,'Notify Admin of New Uploads?','uploadnotify','','yes',10,2)]
Result: Duplicate entry '71' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (75,'PhotoPost Classifieds main table width, percent or pixels.','tablewidth','','100%',5,9)]
Result: Duplicate entry '75' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (76,'Require unique email addresses for user registration?','emailunique','','no',1,8)]
Result: Duplicate entry '76' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (78,'Show Random images on Index page?','disrandom','','no',4,3)]
Result: Duplicate entry '78' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (79,'Show Most Popular images on Index page?','dispopular','','no',5,3)]
Result: Duplicate entry '79' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (81,'PATH to bulkupload directory?','zipuploaddir','','/path/to/uploads',16,1)]
Result: Duplicate entry '81' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (82,'URL to bulkupload directory?','zipuploadurl','','http://www.yoursite.com/uploads',17,1)]
Result: Duplicate entry '82' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (83,'Forum database table prefix','dprefix','','',3,14)]
Result: Duplicate entry '83' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (84,'PhotoPost Classifieds Version','pversion','','2.5',53,0)]
Result: Duplicate entry '84' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (86,'Enable watermarking of products with overlay image?','annotate','','no',1,10)]
Result: Duplicate entry '86' for key 1
Database: turbogli

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

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (88,'Quality setting for resizing/thumbnails?','imgquality','','70',7,6)]
Result: Duplicate entry '88' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (89,'If product upload width or height exceeds maximums, resize upload down to max dimensions?','resizeorig','','yes',8,6)]
Result: Duplicate entry '89' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (90,'Full server path to watermark overlay image.','watermark','','',3,10)]
Result: Duplicate entry '90' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (91,'Allow users to move/delete their own images?','userdel','','no',12,2)]
Result: Duplicate entry '91' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (93,'Require users to be registered to view images?','reqregister','','no',9,8)]
Result: Duplicate entry '93' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (101,'Display new products indicator on index?','displaynew','','no',7,3)]
Result: Duplicate entry '101' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (115,'Display views?','dispviews','','yes',12,5)]
Result: Duplicate entry '115' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (116,'Display date?','dispdate','','yes',13,5)]
Result: Duplicate entry '116' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (118,'Display keywords?','dispkeys','','yes',15,5)]
Result: Duplicate entry '118' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (119,'Display description?','dispdesc','','yes',16,5)]
Result: Duplicate entry '119' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (121,'Display title under product?','disptitle','','yes',18,5)]
Result: Duplicate entry '121' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (122,'Number of days to show sold/closed ads?','numdays','','1',19,5)]
Result: Duplicate entry '122' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (135,'Display number of viewers on categories?', 'displayonline', 'Adds a query to main index, but shows numbers of viewers per category', 'yes', 60, 2)]
Result: Duplicate entry '135' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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)]
Result: Duplicate entry '142' for key 1
Database: turbogli

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

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (145,'Sidebar Width', 'sidebar_width', ' Choose the width for your sidebar', '20%', 4, 11)]
Result: Duplicate entry '145' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (146,'Under Category Bar', 'undercat', ' Display Recent Comments and Who\'s Online Pals', 'no', 5, 11)]
Result: Duplicate entry '146' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (147,'Statistics Bar', 'statspal', ' Display Statistics Pal?', 'yes', 6, 11)]
Result: Duplicate entry '147' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (149,'Random Ad', 'randompal', ' Display Random Image?', 'yes', 8, 11)]
Result: Duplicate entry '149' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (150,'Display Most Viewed Ads Pal', 'ratingspal', ' Display Ads with highest views?', 'no', 9, 11)]
Result: Duplicate entry '150' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (151,'Show Sidebar on Index Page?', 'sidebar_index', '', 'no', 2, 11)]
Result: Duplicate entry '151' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (152,'Show Sidebar Globally?', 'sidebar_global', 'Showsidebar on showcat and showproduct pages?', 'no', 3, 11)]
Result: Duplicate entry '152' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (153,'UBBThreads Users: Default theme setting', 'threads', 'Threads Users: We need to know what the site default theme setting is.', 'infopop', 14, 5)]
Result: Duplicate entry '153' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (154,'Show signatures?', 'showsigs', 'When available, display signatures?', 'yes', 27, 5)]
Result: Duplicate entry '154' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (155,'Show Avatars', 'showavatar', 'When available, show avatars?', 'yes', 28, 5)]
Result: Duplicate entry '155' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (161,'Number of Last Comments to display', 'numcompal', '', '5', 14, 11)]
Result: Duplicate entry '161' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (162,'Number of Most Viewed Ads to display', 'mostpoppal', '', '5', 15, 11)]
Result: Duplicate entry '162' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_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, 14)]
Result: Duplicate entry '163' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (164,'Display ads with no photos in features?', 'featureads', 'By default the featured ads only display ads which contain photos', 'no', 56, 2)]
Result: Duplicate entry '164' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (165,'Feedback points required for 5 stars', 'feedfive', '', '100', 2, 7)]
Result: Duplicate entry '165' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (166,'Feedback points required for 4 stars', 'feedfour', '', '75', 3, 7)]
Result: Duplicate entry '166' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (167,'Feedback points required for 3 stars', 'feedthree', '', '50', 4, 7)]
Result: Duplicate entry '167' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (168,'Feedback points required for 2 stars', 'feedtwo', '', '25', 5, 7)]
Result: Duplicate entry '168' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (169,'Feedback points required for 1 stars', 'feedone', '', '0', 6, 7)]
Result: Duplicate entry '169' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (170,'Enable Zip Code integration (requires third-party zip code database)', 'zipcode', '', 'no', 10, 9)]
Result: Duplicate entry '170' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (171,'Currency symbol', 'currency', '', '$', 19, 1)]
Result: Duplicate entry '171' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (173,'Your PayPal email address for your account?', 'paypalemail', 'Required to receive payments!', '', 2, 12)]
Result: Duplicate entry '173' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (174,'PayPal currency code?', 'paypalcur', 'USD for US Dollar', 'USD', 3, 12)]
Result: Duplicate entry '174' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (175,'SMF Users: Specify your SMF Cookie Name', 'smfcookie', 'You need to specify your cookie name here . This is IMPORTANT!', 'craftsterYaBBSE151', 20, 13)]
Result: Duplicate entry '175' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (176,'BotBuster Integration', 'botbuster', 'Set to yes if you have BotBuster on your system (this includes the necessary tag)', 'no', 22, 1)]
Result: Duplicate entry '176' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (177,'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 '177' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (178,'Date format', 'ppdateformat', 'Keywords: dow, month, mm, dd, yyyy', 'dow month dd, yyyy', 24, 1)]
Result: Duplicate entry '178' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (179,'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 '179' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (180,'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 '180' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (181,'PhotoPost Classifieds Cookie Path', 'cookie_path', 'This should be set to match the path/domain for your cookies. Setting to / enables entire site.', '/', 1, 13)]
Result: Duplicate entry '181' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (182,'Forum Cookie Prefix', 'cookieprefix', 'Some Default values vB3: bb, phpBB2: phpbb2mysql, Threads: w3t_', '', 2, 13)]
Result: Duplicate entry '182' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (183,'PhotoPost Classifieds Cookie Domain', 'domain_path', '.yourdomain.com; sets the cookie to be usable across the domain', '', 3, 13)]
Result: Duplicate entry '183' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (184,'Debug Setting', 'debug', 'How do you want PhotoPost Classifieds to handle errors?', '0', 27, 1)]
Result: Duplicate entry '184' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (185,'Enable On-The-Fly Watermarks', 'onthefly', 'Requires GD2 and you must edit the file watermark.php', 'no', 29, 5)]
Result: Duplicate entry '185' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (186,'Imaging Integration (IM or GD)', 'usegd', 'Select ImageMagick or GD1/GD2 for image processing', '0', 28, 1)]
Result: Duplicate entry '186' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (187,'Directory for backups?', 'backupdir', 'The full path to the directory to store backups', '', 29, 1)]
Result: Duplicate entry '187' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (188,'Path to mysqldump', 'mysqldumppath', 'The full path to your mysqldump executable', '', 30, 1)]
Result: Duplicate entry '188' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (189,'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)]
Result: Duplicate entry '189' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (190,'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)]
Result: Duplicate entry '190' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (191,'Classifieds Open?', 'ppboards', 'Select Open or Closed - when Closed only Admin can view.', 'open', 20, 1)]
Result: Duplicate entry '191' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (192,'Message displayed when closed', 'closedmsg', '', 'The boards are temporarily down for maintainence.', 21, 1)]
Result: Duplicate entry '192' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (193,'Minutes to cache index page data for featured ads, statistics and PALs?','cachetimeout','Number of minutes to cache information. Default is 10 minutes, 0 means no caching.','10',36,1)]
Result: Duplicate entry '193' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (194,'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 '194' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (195,'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 cateogry', 'no', 15, 3)]
Result: Duplicate entry '195' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (196, '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 '196' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (197, 'Maximum PHP file upload size?', 'phpmax', '', '2048', 13, 6)]
Result: Duplicate entry '197' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (198,'Show Calendar PAL?','calpal','Do you want to display the calendar pal, yes or no.','yes',16,11)]
Result: Duplicate entry '198' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (199, 'Show Category Avatars?', 'indexavatars', 'Do you want to display the Index Avatars?', 'yes', 9, 3)]
Result: Duplicate entry '199' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (200, 'Show Avatars on Showcat pages?', 'hasimage', '', 'yes', 6, 4)]
Result: Duplicate entry '200' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (201,'Do you want to enable the Announcement box?','news', '', 'no', 12, 3)]
Result: Duplicate entry '201' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (202,'Title for the Announcement box?','newstitle', '', 'News', 13, 3)]
Result: Duplicate entry '202' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (203,'Contents of the Announcement box?','newscopy', 'This block can contain HTML code (200 character limit)', '', 14, 3)]
Result: Duplicate entry '203' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (204, 'Use Whos Online PAL?', 'onlinepal', '', 'yes', 10, 11)]
Result: Duplicate entry '204' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (205, 'Use Spider-friendly URLs?','spider','','no',17,1)]
Result: Duplicate entry '205' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (206,'Use Anti-leeching code?', 'right-click', 'Use Right-Click Disable JavaScript to try and prevent right-clicking images', 'no', 23, 5)]
Result: Duplicate entry '206' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (207,'Use category cache?','catcache','On some larger sites, using the category cache can actually reduce performance.','yes',36,1)]
Result: Duplicate entry '207' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (208,'Display Featured Ads on this page?','features','On larger sites this option can slow down the showcat page. Turn off to speed up this page.','yes',8,5)]
Result: Duplicate entry '208' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (209,'Display Admin quick move/delete options under ad?','quickopts','On larger sites this option can slow down the showproduct page. Turn off to speed up this page.','yes',8,5)]
Result: Duplicate entry '209' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (210,'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 '210' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (211, 'Which Payment Processor do you want to use?', 'processor', 'currently paypal and authorize.net are supported', 'paypal', 3, 12)]
Result: Duplicate entry '211' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (212, 'Authorize.Net Login ID', 'authorizeid', 'Your Login ID for Authorize.Net.', '', 4, 12)]
Result: Duplicate entry '212' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (213, 'Authorize.Net Transaction Key', 'authorizekey', 'The transaction key as specified within the Security section of the Authorize.Net merchant account system.', '', 5, 12)]
Result: Duplicate entry '213' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (214, 'MoneyBookers Email', 'mbemail', 'Please enter your MoneyBookers email, all references to the subscription service will use this email.', '', 6, 12)]
Result: Duplicate entry '214' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (215, 'Moneybookers Secret Word', 'mbsecret', 'Secret Word in lowercase as typed into your Moneybookers Profile.', '', 7, 12)]
Result: Duplicate entry '215' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (216, 'WorldPay Installation ID', 'wp_instid', 'The Install ID that is generated by the WorldPay CMS for the subscription callback.
You must set your callback url to point to your payment.php script', '', 8, 12)]
Result: Duplicate entry '216' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (217, 'WorldPay Callback Password', 'wp_password', 'The password entered during the creation of the subscription callback within the WorldPay CMS.', '', 9, 12)]
Result: Duplicate entry '217' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (218,'Comments increment user post count?','cpostcount','','yes',11,2)]
Result: Duplicate entry '218' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_settings VALUES (219,'Photo uploads increment user post count?','ppostcount','','yes',12,2)]
Result: Duplicate entry '219' for key 1
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_sort (sortid int(15) NOT NULL auto_increment, name varchar(35) NOT NULL default '', code varchar(75) NOT NULL default '', PRIMARY KEY (sortid)) TYPE=MyISAM]
Result: Table 'class_sort' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (1,'Most Recent','ORDER BY disporder,date DESC')]
Result: Duplicate entry '1' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (2,'Most Views','ORDER BY disporder,views DESC')]
Result: Duplicate entry '2' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (3,'Most Popular','ORDER BY disporder,rating DESC, views DESC')]
Result: Duplicate entry '3' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (4,'Random', 'ORDER BY disporder,RAND()')]
Result: Duplicate entry '4' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (5,'Least Popular', 'ORDER BY disporder,rating,views')]
Result: Duplicate entry '5' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (6,'Product Title', 'ORDER BY disporder,title')]
Result: Duplicate entry '6' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (7,'Lowest Price', 'ORDER BY disporder,price ASC')]
Result: Duplicate entry '7' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (8,'Highest Price', 'ORDER BY disporder,price DESC')]
Result: Duplicate entry '8' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_sort VALUES (9, 'ZipCode', 'ORDER BY zipcode')]
Result: Duplicate entry '9' for key 1
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_admingroups (id int(3) NOT NULL auto_increment,name varchar(35) NOT NULL default '',PRIMARY KEY (id)) TYPE=MyISAM]
Result: Table 'class_admingroups' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (1,'Global Options')]
Result: Duplicate entry '1' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (2,'Admin Options')]
Result: Duplicate entry '2' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (3,'Index Options')]
Result: Duplicate entry '3' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (4,'Show Categories Options')]
Result: Duplicate entry '4' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (5,'Show Ads Options')]
Result: Duplicate entry '5' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (6,'Upload Ads Options')]
Result: Duplicate entry '6' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (7,'Comments Options')]
Result: Duplicate entry '7' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (8,'Registration Options')]
Result: Duplicate entry '8' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (9,'Layout Options')]
Result: Duplicate entry '9' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (10,'Watermark Options')]
Result: Duplicate entry '10' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (11, 'Sidebar Settings')]
Result: Duplicate entry '11' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (12,'Payment Options')]
Result: Duplicate entry '12' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (13,'Cookie Settings')]
Result: Duplicate entry '13' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_admingroups VALUES (14,'Forum Settings')]
Result: Duplicate entry '14' for key 1
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_notify (id int(15) NOT NULL auto_increment,userid int(25) NOT NULL default '0',product int(25) NOT NULL default '0',type INT(2) DEFAULT '0' NOT NULL,PRIMARY KEY (id),KEY product(product)) TYPE=MyISAM]
Result: Table 'class_notify' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_users (userid int(25) NOT NULL auto_increment,usergroupid int(5) NOT NULL default '0',username varchar(30) NOT NULL default '',password varchar(50) NOT NULL default '',email varchar(75) NOT NULL default '',homepage varchar(100) default NULL,icq varchar(50) default NULL,aim varchar(30) default NULL,yahoo varchar(30) default NULL,joindate int(25) NOT NULL default '0',posts int(20) NOT NULL default '0',birthday date NOT NULL default '0000-00-00',ipaddress varchar(18) default NULL,location varchar(100) default NULL,interests varchar(250) default NULL,occupation varchar(250) default NULL,bio varchar(250) default NULL,site VARCHAR(30) default NULL,offset SMALLINT(2) DEFAULT '0' NOT NULL,views int(10) NOT NULL default '0',solditems int(8) NOT NULL default '0',PRIMARY KEY (userid)) TYPE=MyISAM]
Result: Table 'class_users' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_ipcache (id int(10) NOT NULL auto_increment,userid INT(25) NOT NULL, ipaddr VARCHAR(75) NOT NULL, date INT(11) UNSIGNED, type VARCHAR(4) NOT NULL, product INT(10) NOT NULL, PRIMARY KEY (id)) TYPE=MyISAM]
Result: Table 'class_ipcache' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_iponline (userid VARCHAR(128) NOT NULL default '', ipaddr VARCHAR(75) NOT NULL default '', date INT(11) UNSIGNED, what VARCHAR(64) NOT NULL default '',item VARCHAR(16) NOT NULL default '', PRIMARY KEY (ipaddr)) TYPE=MyISAM]
Result: Table 'class_iponline' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_adtypes (id int(12) NOT NULL default '0', adtype varchar(64) NOT NULL default '', isactive tinyint(1) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id)) TYPE=MyISAM]
Result: Table 'class_adtypes' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_adtypes VALUES (0, 'For Sale', 1)]
Result: Duplicate entry '0' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_adtypes VALUES (1, 'Wanted', 1)]
Result: Duplicate entry '1' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_adtypes VALUES (2, 'Personals', 0)]
Result: Duplicate entry '2' for key 1
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_adtypes VALUES (3, 'Help Wanted', 1)]
Result: Duplicate entry '3' for key 1
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_feedback (id int(12) NOT NULL auto_increment, foruser int(12) NOT NULL default '0', fromuser int(12) NOT NULL default '0', username varchar(64) NOT NULL default '', postdate int(16) NOT NULL default '0', rating int(2) NOT NULL default '0', comment TEXT NULL default '', approved tinyint(1) NOT NULL default '0', ip varchar(16) NOT NULL default '', PRIMARY KEY (id)) TYPE=MyISAM]
Result: Table 'class_feedback' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_stats (id int(2) NOT NULL auto_increment, amt_sold float(12,2) NOT NULL default '0', ads_sold int(12) NOT NULL default '0', lastupdate INT(12) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM]
Result: Table 'class_stats' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_stats VALUES (1, 0, 0, 0)]
Result: Duplicate entry '1' for key 1
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_payments (id int(2) NOT NULL auto_increment, ad_id INT(12) NOT NULL default '0', ad_amount float(12,2) NOT NULL default '0', ad_key varchar(32) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM]
Result: Table 'class_payments' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_bidding (id int(2) NOT NULL auto_increment, ad_id INT(12) NOT NULL default '0', user_id INT(12) NOT NULL default '0', username VARCHAR(128) NOT NULL default '', bid float(12,2) NOT NULL default '0', maxbid float(12,2) NOT NULL default '0', bid_date int(12) NOT NULL default '0', bid_ip varchar(12) NULL, PRIMARY KEY (id) ) TYPE=MyISAM]
Result: Table 'class_bidding' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_bids ( id int(2) NOT NULL auto_increment, ad_id int(12) NOT NULL default '0', user_id int(12) NOT NULL default '0', username varchar(128) NOT NULL default '', bid float(12,2) NOT NULL default '0.00', maxbid float(12,2) NOT NULL default '0.00', bid_date int(12) NOT NULL default '0', bid_ip varchar(16) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM]
Result: Table 'class_bids' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE zipData (zipcode varchar(5) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lon varchar(8) NOT NULL default '', lat varchar(8) NOT NULL default '') TYPE=MyISAM]
Result: Table 'zipData' already exists
Database: turbogli

Step 3: MySQL error reported: [CREATE TABLE class_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 'class_cache' already exists
Database: turbogli

Step 3: MySQL error reported: [INSERT INTO class_cache VALUES (1,'',null,null,null,null,null,null,null)]
Result: Duplicate entry '1' for key 1
Database: turbogli

horsetrailertalk · July 17th, 2006, 04:33 PM

There you go....after all day of trying and trying...deleting and reinstalling....

That is ALL I see

Chuck S · July 17th, 2006, 05:24 PM

Does the script stop there? Could be a PHP timeout issue

You can PM me ftp database login and url to look at

when I go to your site I see classifieds already installed and you only own one Photopost classifieds license so why are you installing it again?

horsetrailertalk · July 17th, 2006, 09:43 PM

Yes it stops there. I am going to move my classifieds from one site to this one. But I wanted to make sure I can get it installed ok first. Then I'll remove it from the other site.

Yes it seems to install...I only tried it 4 times today. It just never promps me for the vb integration. I could email the config files that I have or anything else that you would need.

I really would like to put this to rest. Waiting an hours between responses doesn't help either.

Thanks.

horsetrailertalk · July 18th, 2006, 09:17 AM

OK...so on the install step 1 where it asks for your site path and database name...login...etc... Should you have the same info in the both the top and bottom areas?

Is having it in there twice why it is giving me the duplicate errors?

I am wanting this to run with my vbulletin 3.54

Chuck S · July 18th, 2006, 09:35 AM

You should have the classifieds database in the top portion and the vbulletin database info in the user database portion.

I would need ftp info etc to see what your server is going. I would still say it is a PHP timeout issue. You can try upping the php memory_limit line from 20 to say 32

horsetrailertalk · July 18th, 2006, 09:37 AM

Well if I am using the same database...wouldn't this be the same information?

horsetrailertalk · July 18th, 2006, 09:40 AM

Quote:

Originally Posted by Chuck S

You should have the classifieds database in the top portion and the vbulletin database info in the user database portion.

I would need ftp info etc to see what your server is going. I would still say it is a PHP timeout issue. You can try upping the php memory_limit line from 20 to say 32

where would i find the memory_limit file to try that?

Chuck S · July 18th, 2006, 09:59 AM

Yes if you are then the same database info gets entered twice

The ini_set lines in the install.php file raise the 20 to say 32 or 48

Code:

Content visible to verified customers only.

horsetrailertalk · July 18th, 2006, 10:21 AM

Thanks for the help Chuck...

much appreciated

josehernandezpr · July 23rd, 2006, 10:29 AM

Hola,

I'm having exactly the same problem as horsetrailertalk. I tried to make an install for 4 times now, I deleted all the duplicated tables at my BD, I deleted all files just to make a fresh install and got the same prob., i get a page of errors that says the tables already exists.

Can anyone help me to resolve this?

Chuck S · July 23rd, 2006, 03:50 PM

Do what is in post 16

josehernandezpr · July 24th, 2006, 06:31 AM

I did, still doing exactly the same