Guest Lunnmh Posted May 18, 2005 Share Posted May 18, 2005 Hi, Everytime i install Cubecart i get this error. All the details seem correct. Any tips. Thanks Mark MySQL Error Occured 1060: Duplicate column name 'cat_id' QUERY = CREATE TABLE `CubeCart_category` ( `cat_name` text NOT NULL, `cat_id` int(16) NOT NULL auto_increment, `cat_father_id` int(16) NOT NULL default '0', `cat_image` varchar(250) NOT NULL default '', `per_ship` decimal(20,2) NOT NULL default '0.00', `item_ship` decimal(20,2) NOT NULL default '0.00', `item_int_ship` decimal(20,2) NOT NULL default '0.00', `per_int_ship` decimal(20,2) NOT NULL default '0.00', `noProducts` int(11) default '0', PRIMARY KEY (`cat_id`,`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=2; Quote Link to comment Share on other sites More sharing options...
Guest Posted May 18, 2005 Share Posted May 18, 2005 this happens about 3 times in the file in the three sections find the duplicates and delete 1 then drop all tables and reupload sql file e.g QUERY = CREATE TABLE `CubeCart_category` ( `cat_name` text NOT NULL, `cat_id` int(16) NOT NULL auto_increment, `cat_father_id` int(16) NOT NULL default '0', `cat_image` varchar(250) NOT NULL default '', `per_ship` decimal(20,2) NOT NULL default '0.00', `item_ship` decimal(20,2) NOT NULL default '0.00', `item_int_ship` decimal(20,2) NOT NULL default '0.00', `per_int_ship` decimal(20,2) NOT NULL default '0.00', `noProducts` int(11) default '0', PRIMARY KEY (`cat_id`,`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=2; delete the red bit i think the other 2 u r looking for is countries and name Quote Link to comment Share on other sites More sharing options...
Guest Posted May 31, 2005 Share Posted May 31, 2005 Where is that file? Quote Link to comment Share on other sites More sharing options...
Guest twisted Posted May 31, 2005 Share Posted May 31, 2005 install.php, in the "upload" folder. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.