Fresh Install - TONS (Literally 500 pages) of errors!!

camarosource · May 13th, 2010, 04:09 AM

Well I installed PhotoPost.. And now I am installed Classifieds and I've configured it all correctly I get

Quote:

Step 2: Checking Your Server

You have selected to use GD2 for your image needs.

Verification Completed!

The next step will configure your database.
Click here to continue to Step 3 -->

I click to go to Step 3 and there is a 10second delay and then literally 500 pages of ERRORS pop up.

Quote:

Step 3: MySQL error reported: [CREATE TABLE cp_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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [CREATE TABLE cp_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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [CREATE TABLE cp_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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [CREATE TABLE cp_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),ugnopay 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 VARCHAR(125) 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, numextra INT(3) NOT NULL default '0', PRIMARY KEY (id),KEY parent(parent)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_categories VALUES (1,'Main','',1,'no',0,NULL,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,'','0','', 0);]
Result: Table 'camaro92_classifieds.cp_categories' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_categories VALUES (2,'A Category','Products of a particular type',1,'yes',1,NULL,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,'','0','', 0);]
Result: Table 'camaro92_classifieds.cp_categories' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [CREATE TABLE cp_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) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [CREATE TABLE cp_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 '',bigimage7 varchar(100) NOT NULL default '',bigimage8 varchar(100) NOT NULL default '',bigimage9 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',shipping 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.00' 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', reserve float(12,2) NOT NULL default '0.00', reslimit float(12,2) NOT NULL default '0.00', quantity INT(10) NOT NULL DEFAULT '0', PRIMARY KEY (id),KEY userid(userid),KEY cat(cat),KEY bigimage(bigimage,cat)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [CREATE TABLE cp_settings (id int(11) NOT NULL auto_increment,title varchar(255) NOT NULL default '',varname varchar(25) 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)) ENGINE=MyISAM DEFAULT CHARSET=utf8 ]
Result: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 1
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (1, 'setting1', 'galleryname', 'PhotoPost Classifieds', 1, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (2, 'setting2', 'webname', 'domain.com', 2, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (3, 'setting3', 'domain', 'http://www.domain.com', 3, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (4, 'setting4', 'adminemail', 'admin@domain.com', 4, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (5, 'setting5', 'datadir', 'http://www.domain.com/classifieds/data', 25, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (6, 'setting6', 'datafull', '/var/www/domain/classifieds/data/', 6, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (7, 'setting7', 'vbulletin', 'http://www.domain.com/forum', 1, 14);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (8, 'setting8', 'header', '/path/to/classifieds/header.htm', 8, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (9, 'setting9', 'footer', '/path/to/classifieds/footer.htm', 9, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (10, 'setting10', 'headtags', '/path/to/classifieds/headtags.htm', 10, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (11, 'setting11', 'maindir', 'http://www.domain.com/classifieds', 11, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (13, 'setting13', 'defaultposts', '15', 1, 5);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (14, 'setting14', 'mostrecent', 'yes', 4, 9);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (15, 'setting15', 'thumbcols', '4', 1, 4);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (18, 'setting18', 'previewwidth', '100', 1, 6);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (19, 'setting19', 'maxwidth', '400', 2, 6);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (20, 'setting20', 'maxheight', '400', 3, 6);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (21, 'setting21', 'maxsupersize', '1024', 4, 6);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (33, 'setting33', 'stats', 'yes', 1, 3);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (37, 'setting37', 'cright', 'Powered by: PhotoPost Classifieds 4.0 --replaceme--
Copyright 2010 All Enthusiast, Inc.', 300, 0);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (38, 'setting38', 'useemail', 'yes', 1, 2);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (41, 'setting41', 'vbversion', 'sellerspost', 14, 2);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (45, 'setting45', 'recentcols', '4', 1, 9);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (46, 'setting46', 'recentnum', '12', 2, 9);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (49, 'setting49', 'idir', 'http://www.domain.com/classifieds/images', 13, 1);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (50, 'setting50', 'catdepth', '1', 2, 3);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (51, 'setting51', 'usenotify', 'yes', 2, 2);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (57, 'setting57', 'adminexclude', 'yes', 101, 4);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (58, 'setting58', 'catdetails', 'no', 3, 3);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (61, 'setting61', 'coppa', 'yes', 3, 8);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (62, 'setting62', 'rules', '', 4, 8);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (63, 'setting63', 'emailverify', 'yes', 5, 8);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (64, 'setting64', 'address', '', 6, 8);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (65, 'setting65', 'copparules', '', 7, 8);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (66, 'setting66', 'allowregs', 'yes', 8, 8);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

Step 3: MySQL error reported: [INSERT INTO cp_settings VALUES (67, 'setting67', 'allowup', 'yes', 3, 2);]
Result: Table 'camaro92_classifieds.cp_settings' doesn't exist
Database: camaro92_classifieds

You get the point ;-)

At this point there IS NOTHING is the classifieds database. The database already exists but nothing in it. No tables. I have searched the forum and some others have had this similar error and was told to turn off the "Strict mode" in MYSQL 5 but I don't see how this could be it as my server is running PHP4/MySQL4?

Thanks

Chuck S · May 13th, 2010, 08:45 AM

HMM wonder if its an issue with an older MYSQL

Try removing from the install.php this on the queries

Code:

Content visible to verified customers only.

You can do a search and replace in notepad or wordpad should take a minute just make sure the file is saved as all files and name install.php you dont want to save it as a txt file.