Cannot Install

[Guest cybermidi]

I am trying to install to an existing database and am getting the message

below. This is the latest alpha release.

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;

[Guest [email protected]]

When you say existing database, was it used by another script?

Did you clean it out before trying to use it with cc3?

Always better to use a totally fresh database in my opinion.

[Guest]

as lee said, you'll either have to DROP all the tables in the databse first, or create a new database. You cannot install it over the top of existing tables.

[Guest cybermidi]

It is an EMPTY database.

Still getting

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;

[Guest jbdancer]

Can you change it to this :

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`) ) TYPE=MyISAM AUTO_INCREMENT=32;

[Guest cybermidi]

Thanks, but I figured it out, there was an error in the install script.

Cat_Id and Country Id were both repeated twice.

So i fixed it. But now I'm having the registered globals problem

(as well documented into another forum so I won't repeat it here)

Bottom line, is I can't get permissions to modify the store as admin.