Guest manmademan123 Posted April 1, 2005 Share Posted April 1, 2005 I have tried to install CC3 both ways. With Manual Method as soon as I go to url: http://www.uksoundlabs.net/store/admin/ i get a 404 error on index.php, it cant find it, but it is there. Also the url changes to: http://www.uksoundlabs.net/admin/index.php? When I do Auto Method install i get: MySQL Error Occured 1050: Table 'CubeCart_Downloads' already exists QUERY = CREATE TABLE `CubeCart_Downloads` ( `id` int(11) NOT NULL auto_increment, `customerId` int(11) NOT NULL default '0', `cart_order_id` varchar(32) NOT NULL default '', `noDownloads` int(11) NOT NULL default '0', `expire` int(11) NOT NULL default '0', `productId` int(11) NOT NULL default '0', `accessKey` varchar(10) NOT NULL default '', KEY `id` (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1;f I have started fresh, no pre installed versions of cubecart. Linux server. Globals on. any ideas? cheers Quote Link to comment Share on other sites More sharing options...
Guest manmademan123 Posted April 1, 2005 Share Posted April 1, 2005 this is weird, i click on the link in above post and it works now? if I type it into browser it fails? Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted April 1, 2005 Share Posted April 1, 2005 You need to empty the database of the CubeCart_ tables and try again. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 1, 2005 Share Posted April 1, 2005 yeh when you do the auto method dont put anything in the database like brooky said Quote Link to comment Share on other sites More sharing options...
Guest Feldon Posted April 1, 2005 Share Posted April 1, 2005 I've just tried to install (Auto Method) CC3 And after step 4 I reseived this message. 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=32; This comes when I try to load the store page: MySQL Error Occured 1146: Table 'feldon_store.CubeCart_sessions' doesn't exist QUERY = INSERT INTO CubeCart_sessions (`location`, `sessId`, `timeStart`, `timeLast`, `customer_id`) VALUES ('/store/index.php?', 'fb519e94353609cf5ca63fa63af1f5c2', '1112376337', '1112376337', 0) And this when I'm in Admin panel MySQL Error Occured 1146: Table 'feldon_store.CubeCart_inventory' doesn't exist QUERY = SELECT count(productId) as noProducts FROM CubeCart_inventory I went through it 3 time all over (clean all DB users... every time I've got the same problems) What's wrong. Quote Link to comment Share on other sites More sharing options...
Guest billmc Posted April 1, 2005 Share Posted April 1, 2005 Hi feldon, Dump the database and edit in the SQL file the duplicat reference to 'cat_id' Change PRIMARY KEY (`cat_id`,`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=32; to PRIMARY KEY (`cat_id`) ) TYPE=MyISAM AUTO_INCREMENT=32; your other errors are dependent on the database not having been installed correctly hth billmc :wacko: Quote Link to comment Share on other sites More sharing options...
Guest Feldon Posted April 1, 2005 Share Posted April 1, 2005 OK. Im' 1 step further Before I had 6 entrys in my DB. CubeCart_Downloads CubeCart_Modules CubeCart_admin_permissions CubeCart_admin_sections CubeCart_admin_sessions CubeCart_admin_users Now there's 8 CubeCart_Downloads CubeCart_Modules CubeCart_admin_permissions CubeCart_admin_sections CubeCart_admin_sessions CubeCart_admin_users CubeCart_category CubeCart_cats_idx And again ERROR : Server: localhost Database: feldon_store Error SQL-query: -- -------------------------------------------------------- -- -- Table structure for table `CubeCart_countries` -- CREATE TABLE `CubeCart_countries` ( `country` text NOT NULL , `country_id` int( 16 ) NOT NULL default '0', `status` char( 1 ) NOT NULL default 'i', PRIMARY KEY ( `country_id` , `country_id` ) ) TYPE = MYISAM MySQL said: #1060 - Duplicate column name 'country_id' [ Back ] Why with me DUPLICATE names ? I'm using the same db.sql as everybody I THINK :P Quote Link to comment Share on other sites More sharing options...
Guest Feldon Posted April 1, 2005 Share Posted April 1, 2005 Ok Billmc. Thanks for your help. I've also deleted 'country_id' Now it works and I have finaly 27 entries in my DB. 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.