mysql error occured..

xyncro · April 19, 2005

... :angry:

i made a clean new install of cc3 alpha-2 and the error i keep getting from trying over and over again is...

MySQL Error Occured
1050: Table 'CubeCart_category' already exists

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;

..to be able to setup the db at all, i also had to add a little fix from here

anyone...???

thx..

April 27, 2005

I also started from scratch and try to instal the database file that you provided on the alpha2, this is the error I got.

Error

SQL-query :

INSERT INTO `CubeCart_admin_users`
VALUES ( 1, 'Default User', 'root', '5f4dcc3b5aa765d61d8327deb882cf99', '[email protected]', 1, 1, 'This is the default user.' )

MySQL said:

Table 'rtest.CubeCart_admin_users' doesn't exist

April 27, 2005

Well I solve my problem, please take a look what you put in the file on Alpa2.

CREATE TABLE `latest_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 ;

CREATE TABLE `latest_CubeCart_Modules` (
`moduleId` int(11) NOT NULL auto_increment,
`module` varchar(10) NOT NULL default '',
`folder` varchar(30) NOT NULL default '',
`status` smallint(1) NOT NULL default '0',
`default` int(1) NOT NULL default '0',
KEY `moduleId` (`moduleId`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

INSERT INTO `latest_CubeCart_Modules` VALUES (1, 'shipping', 'Free_Shipping', 1, 1);
INSERT INTO `latest_CubeCart_Modules` VALUES (2, 'gateway', 'Print_Order_Form', 1, 1);

CREATE TABLE `latest_CubeCart_admin_permissions` (
`permissionId` int(11) NOT NULL auto_increment,
`sectId` int(11) NOT NULL default '0',
`adminId` int(11) NOT NULL default '0',
`read` int(11) NOT NULL default '0',
`write` int(11) NOT NULL default '0',
`edit` int(11) NOT NULL default '0',
`delete` int(11) NOT NULL default '0',
PRIMARY KEY (`permissionId`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `latest_CubeCart_admin_sections` (
`sectId` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
KEY `sectId` (`sectId`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

INSERT INTO `latest_CubeCart_admin_sections` VALUES (1, 'users', 'For the administration of admin users and their permissions.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (2, 'products', 'For the administration of products.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (3, 'categories', 'For the administration of categories.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (4, 'documents', 'For the administration of site documents.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (5, 'customers', 'For the administration of customers details.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (6, 'shipping', 'For the administration of shipping methods.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (7, 'filemanager', 'For the administration of the website images.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (8, 'statistics', 'This section displays store statistics.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (9, 'settings', 'For the administration of the code store settings.');
INSERT INTO `latest_CubeCart_admin_sections` VALUES (10, 'orders', 'Access rights for the orders section.');

CREATE TABLE `CubeCart_admin_sessions` (
`loginId` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL default '',
`time` int(11) NOT NULL default '0',
`ipAddress` varchar(20) NOT NULL default '',
`success` int(11) NOT NULL default '0',
KEY `loginId` (`loginId`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `CubeCart_admin_users` (
`adminId` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`username` varchar(255) NOT NULL default '',
`password` varchar(32) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`noLogins` int(11) NOT NULL default '0',
`isSuper` int(11) NOT NULL default '0',
`notes` text,
KEY `adminId` (`adminId`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `CubeCart_admin_users` VALUES (1, 'Default User', 'root', '5f4dcc3b5aa765d61d8327deb882cf99', '[email protected]', 1, 1, 'This is the default user.');

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 ;

INSERT INTO `CubeCart_category` VALUES ('Test Category', 1, 0, '', 0.00, 0.00, 0.00, 0.00, 1);

CREATE TABLE `CubeCart_cats_idx` (
`id` int(11) NOT NULL auto_increment,
`cat_id` int(11) NOT NULL default '0',
`productId` int(11) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `CubeCart_cats_idx` VALUES (1, 1, 1);

CREATE TABLE `CubeCart_currencies` (
`currencyId` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`code` varchar(5) NOT NULL default '',
`symbolLeft` varchar(10) default NULL,
`symbolRight` varchar(10) default NULL,
`value` decimal(10,5) NOT NULL default '0.00000',
`decimalPlaces` int(11) NOT NULL default '0',
`lastUpdated` int(10) NOT NULL default '0',
`active` int(1) NOT NULL default '0',
KEY `curencyId` (`currencyId`)
) TYPE=MyISAM AUTO_INCREMENT=12 ;

INSERT INTO `CubeCart_currencies` VALUES (1, 'British Pounds', 'GBP', 'Â£', '', 0.52778, 2, 1111670592, 1);
INSERT INTO `CubeCart_currencies` VALUES (2, 'US Dollars', 'USD', '$', '', 1.00000, 2, 1112128377, 1);
INSERT INTO `CubeCart_currencies` VALUES (3, 'Euro', 'EUR', 'â‚¬', '', 0.76626, 2, 1111669701, 1);
INSERT INTO `CubeCart_currencies` VALUES (4, 'Japanese Yen', 'JPY', 'Â¥', '', 105.53000, 0, 1111669706, 0);
INSERT INTO `CubeCart_currencies` VALUES (5, 'Canadian Dollars', 'CAD', '$', '', 1.23062, 2, 1108994873, 0);
INSERT INTO `CubeCart_currencies` VALUES (6, 'Australian Dollars', 'AUD', '$', '', 1.26895, 2, 1108994869, 0);
INSERT INTO `CubeCart_currencies` VALUES (7, 'Swiss Francs', 'CHF', 'CHF', '', 1.18312, 2, 1108994881, 0);
INSERT INTO `CubeCart_currencies` VALUES (8, 'Russian Rubles', 'RUB', '', 'R', 27.94500, 0, 1108994885, 0);
INSERT INTO `CubeCart_currencies` VALUES (9, 'Chinese Yuan', 'CNY', '', 'Yuan', 8.27650, 2, 1108994875, 0);
INSERT INTO `CubeCart_currencies` VALUES (10, 'South African Rand', 'ZAR', 'R', '', 5.93606, 0, 1108994883, 0);
INSERT INTO `CubeCart_currencies` VALUES (11, 'Mexican Peso', 'MXN', '', 'MXP', 11.05500, 2, 1108994888, 0);

CREATE TABLE `CubeCart_customer` (
`email` varchar(50) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`title` varchar(10) default NULL,
`firstName` varchar(255) NOT NULL default '',
`lastName` varchar(255) NOT NULL default '',
`add_1` varchar(100) NOT NULL default '',
`add_2` varchar(100) NOT NULL default '',
`town` varchar(100) NOT NULL default '',
`county` varchar(100) NOT NULL default '',
`zoneId` int(3) NOT NULL default '0',
`postcode` varchar(15) NOT NULL default '',
`country` char(3) NOT NULL default '',
`phone` varchar(20) NOT NULL default '',
`mobile` varchar(50) default NULL,
`customer_id` int(11) NOT NULL auto_increment,
`regTime` int(10) NOT NULL default '0',
`ipAddress` varchar(30) NOT NULL default '',
`noOrders` int(11) default '0',
`optIn1st` int(11) NOT NULL default '0',
`htmlEmail` int(11) NOT NULL default '1',
`type` int(11) default '0',
PRIMARY KEY (`customer_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `CubeCart_docs` (
`doc_name` varchar(255) NOT NULL default '',
`doc_content` text NOT NULL,
`doc_id` int(16) NOT NULL auto_increment,
KEY `doc_id` (`doc_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

INSERT INTO `CubeCart_docs` VALUES ('About Us', 'This can be managed under Documents - Site Documents in the admin control panel. \r\n', 1);
INSERT INTO `CubeCart_docs` VALUES ('Contact Us', 'This can be managed under Documents - Site Documents in the admin control panel.', 2);
INSERT INTO `CubeCart_docs` VALUES ('Terms & Conditions', 'This can be managed under Documents - Site Documents in the admin control panel.', 3);
INSERT INTO `CubeCart_docs` VALUES ('Privacy Policy', 'This can be managed under Documents - Site Documents in the admin control panel.', 4);

CREATE TABLE `CubeCart_docs_lang` (
`id` int(11) NOT NULL auto_increment,
`doc_master_id` int(11) NOT NULL default '0',
`doc_lang` varchar(20) NOT NULL default '',
`doc_name` varchar(255) NOT NULL default '',
`doc_content` text NOT NULL,
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `CubeCart_img_idx` (
`id` int(11) NOT NULL auto_increment,
`productId` int(11) NOT NULL default '0',
`img` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `CubeCart_inv_lang` (
`id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`prod_lang` varchar(20) NOT NULL default '',
`prod_master_id` int(11) NOT NULL default '0',
`description` text NOT NULL,
KEY `id` (`id`)
) TYPE=MyISAM;

CREATE TABLE `CubeCart_inventory` (
`productId` int(11) NOT NULL auto_increment,
`productCode` varchar(60) NOT NULL default '',
`quantity` int(16) NOT NULL default '1',
`description` text NOT NULL,
`image` varchar(250) NOT NULL default '',
`noImages` int(11) NOT NULL default '0',
`price` decimal(30,2) NOT NULL default '0.00',
`name` varchar(250) NOT NULL default '0',
`cat_id` int(16) NOT NULL default '0',
`popularity` bigint(64) NOT NULL default '0',
`sale_price` decimal(30,2) NOT NULL default '0.00',
`stock_level` int(11) default '0',
`useStockLevel` int(11) default '1',
`digital` int(11) NOT NULL default '0',
`digitalDir` varchar(255) default NULL,
`prodWeight` decimal(10,2) default NULL,
`taxType` int(11) default NULL,
`showFeatured` int(11) NOT NULL default '1',
PRIMARY KEY (`productId`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

INSERT INTO `CubeCart_inventory` VALUES (1, 'TESA31', 1, 'This is the main copy for the product. ', '', 0, 10.00, 'Test Product', 1, 18, 6.99, 0, 0, 0, '', 4.00, 1, 1);

CREATE TABLE `CubeCart_iso_counties` (
`id` int(11) NOT NULL auto_increment,
`countryId` int(4) NOT NULL default '0',
`abbrev` varchar(4) NOT NULL default '',
`name` varchar(40) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=441 ;

INSERT INTO `CubeCart_iso_counties` VALUES (1, 226, 'AL', 'Alabama');
INSERT INTO `CubeCart_iso_counties` VALUES (2, 226, 'AK', 'Alaska');
INSERT INTO `CubeCart_iso_counties` VALUES (3, 226, 'AS', 'American Samoa');
INSERT INTO `CubeCart_iso_counties` VALUES (4, 226, 'AZ', 'Arizona');
INSERT INTO `CubeCart_iso_counties` VALUES (5, 226, 'AR', 'Arkansas');
INSERT INTO `CubeCart_iso_counties` VALUES (6, 226, 'AF', 'Armed Forces Africa');
INSERT INTO `CubeCart_iso_counties` VALUES (7, 226, 'AA', 'Armed Forces Americas');
INSERT INTO `CubeCart_iso_counties` VALUES (8, 226, 'AC', 'Armed Forces Canada');
INSERT INTO `CubeCart_iso_counties` VALUES (9, 226, 'AE', 'Armed Forces Europe');
INSERT INTO `CubeCart_iso_counties` VALUES (10, 226, 'AM', 'Armed Forces Middle East');
INSERT INTO `CubeCart_iso_counties` VALUES (11, 226, 'AP', 'Armed Forces Pacific');
INSERT INTO `CubeCart_iso_counties` VALUES (12, 226, 'CA', 'California');
INSERT INTO `CubeCart_iso_counties` VALUES (13, 226, 'CO', 'Colorado');
INSERT INTO `CubeCart_iso_counties` VALUES (14, 226, 'CT', 'Connecticut');
INSERT INTO `CubeCart_iso_counties` VALUES (15, 226, 'DE', 'Delaware');
INSERT INTO `CubeCart_iso_counties` VALUES (16, 226, 'DC', 'District of Columbia');
INSERT INTO `CubeCart_iso_counties` VALUES (17, 226, 'FM', 'Federated States Of Micronesia');
INSERT INTO `CubeCart_iso_counties` VALUES (18, 226, 'FL', 'Florida');
INSERT INTO `CubeCart_iso_counties` VALUES (19, 226, 'GA', 'Georgia');
INSERT INTO `CubeCart_iso_counties` VALUES (20, 226, 'GU', 'Guam');
INSERT INTO `CubeCart_iso_counties` VALUES (21, 226, 'HI', 'Hawaii');
INSERT INTO `CubeCart_iso_counties` VALUES (22, 226, 'ID', 'Idaho');
INSERT INTO `CubeCart_iso_counties` VALUES (23, 226, 'IL', 'Illinois');
INSERT INTO `CubeCart_iso_counties` VALUES (24, 226, 'IN', 'Indiana');
INSERT INTO `CubeCart_iso_counties` VALUES (25, 226, 'IA', 'Iowa');
INSERT INTO `CubeCart_iso_counties` VALUES (26, 226, 'KS', 'Kansas');
INSERT INTO `CubeCart_iso_counties` VALUES (27, 226, 'KY', 'Kentucky');
INSERT INTO `CubeCart_iso_counties` VALUES (28, 226, 'LA', 'Louisiana');
INSERT INTO `CubeCart_iso_counties` VALUES (29, 226, 'ME', 'Maine');
INSERT INTO `CubeCart_iso_counties` VALUES (30, 226, 'MH', 'Marshall Islands');
INSERT INTO `CubeCart_iso_counties` VALUES (31, 226, 'MD', 'Maryland');
INSERT INTO `CubeCart_iso_counties` VALUES (32, 226, 'MA', 'Massachusetts');
INSERT INTO `CubeCart_iso_counties` VALUES (33, 226, 'MI', 'Michigan');
INSERT INTO `CubeCart_iso_counties` VALUES (34, 226, 'MN', 'Minnesota');
INSERT INTO `CubeCart_iso_counties` VALUES (35, 226, 'MS', 'Mississippi');
INSERT INTO `CubeCart_iso_counties` VALUES (36, 226, 'MO', 'Missouri');
INSERT INTO `CubeCart_iso_counties` VALUES (37, 226, 'MT', 'Montana');
INSERT INTO `CubeCart_iso_counties` VALUES (38, 226, 'NE', 'Nebraska');
INSERT INTO `CubeCart_iso_counties` VALUES (39, 226, 'NV', 'Nevada');
INSERT INTO `CubeCart_iso_counties` VALUES (40, 226, 'NH', 'New Hampshire');
INSERT INTO `CubeCart_iso_counties` VALUES (41, 226, 'NJ', 'New Jersey');
INSERT INTO `CubeCart_iso_counties` VALUES (42, 226, 'NM', 'New Mexico');
INSERT INTO `CubeCart_iso_counties` VALUES (43, 226, 'NY', 'New York');
INSERT INTO `CubeCart_iso_counties` VALUES (44, 226, 'NC', 'North Carolina');
INSERT INTO `CubeCart_iso_counties` VALUES (45, 226, 'ND', 'North Dakota');
INSERT INTO `CubeCart_iso_counties` VALUES (46, 226, 'MP', 'Northern Mariana Islands');
INSERT INTO `CubeCart_iso_counties` VALUES (47, 226, 'OH', 'Ohio');
INSERT INTO `CubeCart_iso_counties` VALUES (48, 226, 'OK', 'Oklahoma');
INSERT INTO `CubeCart_iso_counties` VALUES (49, 226, 'OR', 'Oregon');
INSERT INTO `CubeCart_iso_counties` VALUES (50, 226, 'PW', 'Palau');
INSERT INTO `CubeCart_iso_counties` VALUES (51, 226, 'PA', 'Pennsylvania');
INSERT INTO `CubeCart_iso_counties` VALUES (52, 226, 'PR', 'Puerto Rico');
INSERT INTO `CubeCart_iso_counties` VALUES (53, 226, 'RI', 'Rhode Island');
INSERT INTO `CubeCart_iso_counties` VALUES (54, 226, 'SC', 'South Carolina');
INSERT INTO `CubeCart_iso_counties` VALUES (55, 226, 'SD', 'South Dakota');
INSERT INTO `CubeCart_iso_counties` VALUES (56, 226, 'TN', 'Tennessee');
INSERT INTO `CubeCart_iso_counties` VALUES (57, 226, 'TX', 'Texas');
INSERT INTO `CubeCart_iso_counties` VALUES (58, 226, 'UT', 'Utah');
INSERT INTO `CubeCart_iso_counties` VALUES (59, 226, 'VT', 'Vermont');
INSERT INTO `CubeCart_iso_counties` VALUES (60, 226, 'VI', 'Virgin Islands');
INSERT INTO `CubeCart_iso_counties` VALUES (61, 226, 'VA', 'Virginia');
INSERT INTO `CubeCart_iso_counties` VALUES (62, 226, 'WA', 'Washington');
INSERT INTO `CubeCart_iso_counties` VALUES (63, 226, 'WV', 'West Virginia');
INSERT INTO `CubeCart_iso_counties` VALUES (64, 226, 'WI', 'Wisconsin');
INSERT INTO `CubeCart_iso_counties` VALUES (65, 226, 'WY', 'Wyoming');
INSERT INTO `CubeCart_iso_counties` VALUES (66, 38, 'AB', 'Alberta');
INSERT INTO `CubeCart_iso_counties` VALUES (67, 38, 'BC', 'British Columbia');
INSERT INTO `CubeCart_iso_counties` VALUES (68, 38, 'MB', 'Manitoba');
INSERT INTO `CubeCart_iso_counties` VALUES (69, 38, 'NF', 'Newfoundland');
INSERT INTO `CubeCart_iso_counties` VALUES (70, 38, 'NB', 'New Brunswick');
INSERT INTO `CubeCart_iso_counties` VALUES (71, 38, 'NS', 'Nova Scotia');
INSERT INTO `CubeCart_iso_counties` VALUES (72, 38, 'NT', 'Northwest Territories');
INSERT INTO `CubeCart_iso_counties` VALUES (73, 38, 'NU', 'Nunavut');
INSERT INTO `CubeCart_iso_counties` VALUES (74, 38, 'ON', 'Ontario');
INSERT INTO `CubeCart_iso_counties` VALUES (75, 38, 'PE', 'Prince Edward Island');
INSERT INTO `CubeCart_iso_counties` VALUES (76, 38, 'QC', 'Quebec');
INSERT INTO `CubeCart_iso_counties` VALUES (77, 38, 'SK', 'Saskatchewan');
INSERT INTO `CubeCart_iso_counties` VALUES (78, 38, 'YT', 'Yukon Territory');
INSERT INTO `CubeCart_iso_counties` VALUES (79, 80, 'NDS', 'Niedersachsen');
INSERT INTO `CubeCart_iso_counties` VALUES (80, 80, 'BAW', 'Baden-WÃ¼rttemberg');
INSERT INTO `CubeCart_iso_counties` VALUES (81, 80, 'BAY', 'Bayern');
INSERT INTO `CubeCart_iso_counties` VALUES (82, 80, 'BER', 'Berlin');
INSERT INTO `CubeCart_iso_counties` VALUES (83, 80, 'BRG', 'Brandenburg');
INSERT INTO `CubeCart_iso_counties` VALUES (84, 80, 'BRE', 'Bremen');
INSERT INTO `CubeCart_iso_counties` VALUES (85, 80, 'HAM', 'Hamburg');
INSERT INTO `CubeCart_iso_counties` VALUES (86, 80, 'HES', 'Hessen');
INSERT INTO `CubeCart_iso_counties` VALUES (87, 80, 'MEC', 'Mecklenburg-Vorpommern');
INSERT INTO `CubeCart_iso_counties` VALUES (88, 80, 'NRW', 'Nordrhein-Westfalen');
INSERT INTO `CubeCart_iso_counties` VALUES (89, 80, 'RHE', 'Rheinland-Pfalz');
INSERT INTO `CubeCart_iso_counties` VALUES (90, 80, 'SAR', 'Saarland');
INSERT INTO `CubeCart_iso_counties` VALUES (91, 80, 'SAS', 'Sachsen');
INSERT INTO `CubeCart_iso_counties` VALUES (92, 80, 'SAC', 'Sachsen-Anhalt');
INSERT INTO `CubeCart_iso_counties` VALUES (93, 80, 'SCN', 'Schleswig-Holstein');
INSERT INTO `CubeCart_iso_counties` VALUES (94, 80, 'THE', 'ThÃ¼ringen');
INSERT INTO `CubeCart_iso_counties` VALUES (95, 14, 'WIE', 'Wien');
INSERT INTO `CubeCart_iso_counties` VALUES (96, 14, 'NO', 'NiederÃ¶sterreich');
INSERT INTO `CubeCart_iso_counties` VALUES (97, 14, 'OO', 'OberÃ¶sterreich');
INSERT INTO `CubeCart_iso_counties` VALUES (98, 14, 'SB', 'Salzburg');
INSERT INTO `CubeCart_iso_counties` VALUES (99, 14, 'KN', 'KÃ¤rnten');
INSERT INTO `CubeCart_iso_counties` VALUES (100, 14, 'ST', 'Steiermark');
INSERT INTO `CubeCart_iso_counties` VALUES (101, 14, 'TI', 'Tirol');
INSERT INTO `CubeCart_iso_counties` VALUES (102, 14, 'BL', 'Burgenland');
INSERT INTO `CubeCart_iso_counties` VALUES (103, 14, 'VB', 'Voralberg');
INSERT INTO `CubeCart_iso_counties` VALUES (104, 206, 'AG', 'Aargau');
INSERT INTO `CubeCart_iso_counties` VALUES (105, 206, 'AI', 'Appenzell Innerrhoden');
INSERT INTO `CubeCart_iso_counties` VALUES (106, 206, 'APP', 'Appenzell Ausserrhoden');
INSERT INTO `CubeCart_iso_counties` VALUES (107, 206, 'BE', 'Bern');
INSERT INTO `CubeCart_iso_counties` VALUES (108, 206, 'BLA', 'Basel-Landschaft');
INSERT INTO `CubeCart_iso_counties` VALUES (109, 206, 'BS', 'Basel-Stadt');
INSERT INTO `CubeCart_iso_counties` VALUES (110, 206, 'FR', 'Freiburg');
INSERT INTO `CubeCart_iso_counties` VALUES (111, 206, 'GE', 'Genf');
INSERT INTO `CubeCart_iso_counties` VALUES (112, 206, 'GL', 'Glarus');
INSERT INTO `CubeCart_iso_counties` VALUES (113, 206, 'JUB', 'GraubÃ¼nden');
INSERT INTO `CubeCart_iso_counties` VALUES (114, 206, 'JU', 'Jura');
INSERT INTO `CubeCart_iso_counties` VALUES (115, 206, 'LU', 'Luzern');
INSERT INTO `CubeCart_iso_counties` VALUES (116, 206, 'NEU', 'Neuenburg');
INSERT INTO `CubeCart_iso_counties` VALUES (117, 206, 'NW', 'Nidwalden');
INSERT INTO `CubeCart_iso_counties` VALUES (118, 206, 'OW', 'Obwalden');
INSERT INTO `CubeCart_iso_counties` VALUES (119, 206, 'SG', 'St. Gallen');
INSERT INTO `CubeCart_iso_counties` VALUES (120, 206, 'SH', 'Schaffhausen');
INSERT INTO `CubeCart_iso_counties` VALUES (121, 206, 'SO', 'Solothurn');
INSERT INTO `CubeCart_iso_counties` VALUES (122, 206, 'SZ', 'Schwyz');
INSERT INTO `CubeCart_iso_counties` VALUES (123, 206, 'TG', 'Thurgau');
INSERT INTO `CubeCart_iso_counties` VALUES (124, 206, 'TE', 'Tessin');
INSERT INTO `CubeCart_iso_counties` VALUES (125, 206, 'UR', 'Uri');
INSERT INTO `CubeCart_iso_counties` VALUES (126, 206, 'VD', 'Waadt');
INSERT INTO `CubeCart_iso_counties` VALUES (127, 206, 'VS', 'Wallis');
INSERT INTO `CubeCart_iso_counties` VALUES (128, 206, 'ZG', 'Zug');
INSERT INTO `CubeCart_iso_counties` VALUES (129, 206, 'ZH', 'ZÃ¼rich');
INSERT INTO `CubeCart_iso_counties` VALUES (130, 199, 'ACOR', 'A CoruÃ±a');
INSERT INTO `CubeCart_iso_counties` VALUES (131, 199, 'ALAV', 'Alava');
INSERT INTO `CubeCart_iso_counties` VALUES (132, 199, 'ALBA', 'Albacete');
INSERT INTO `CubeCart_iso_counties` VALUES (133, 199, 'ALIC', 'Alicante');
INSERT INTO `CubeCart_iso_counties` VALUES (134, 199, 'ALME', 'Almeria');
INSERT INTO `CubeCart_iso_counties` VALUES (135, 199, 'ASTU', 'Asturias');
INSERT INTO `CubeCart_iso_counties` VALUES (136, 199, 'AVIL', 'Avila');
INSERT INTO `CubeCart_iso_counties` VALUES (137, 199, 'BADA', 'Badajoz');
INSERT INTO `CubeCart_iso_counties` VALUES (138, 199, 'BALE', 'Baleares');
INSERT INTO `CubeCart_iso_counties` VALUES (139, 199, 'BARC', 'Barcelona');
INSERT INTO `CubeCart_iso_counties` VALUES (140, 199, 'BURG', 'Burgos');
INSERT INTO `CubeCart_iso_counties` VALUES (141, 199, 'CACE', 'Caceres');
INSERT INTO `CubeCart_iso_counties` VALUES (142, 199, 'CADI', 'Cadiz');
INSERT INTO `CubeCart_iso_counties` VALUES (143, 199, 'CANT', 'Cantabria');
INSERT INTO `CubeCart_iso_counties` VALUES (144, 199, 'CAST', 'Castellon');
INSERT INTO `CubeCart_iso_counties` VALUES (145, 199, 'CEUT', 'Ceuta');
INSERT INTO `CubeCart_iso_counties` VALUES (146, 199, 'CIUD', 'Ciudad Real');
INSERT INTO `CubeCart_iso_counties` VALUES (147, 199, 'CORD', 'Cordoba');
INSERT INTO `CubeCart_iso_counties` VALUES (148, 199, 'CUEN', 'Cuenca');
INSERT INTO `CubeCart_iso_counties` VALUES (149, 199, 'GIRO', 'Girona');
INSERT INTO `CubeCart_iso_counties` VALUES (150, 199, 'GRAN', 'Granada');
INSERT INTO `CubeCart_iso_counties` VALUES (151, 199, 'GUAD', 'Guadalajara');
INSERT INTO `CubeCart_iso_counties` VALUES (152, 199, 'GUIP', 'Guipuzcoa');
INSERT INTO `CubeCart_iso_counties` VALUES (153, 199, 'HUEL', 'Huelva');
INSERT INTO `CubeCart_iso_counties` VALUES (154, 199, 'HUES', 'Huesca');
INSERT INTO `CubeCart_iso_counties` VALUES (155, 199, 'JAEN', 'Jaen');
INSERT INTO `CubeCart_iso_counties` VALUES (156, 199, 'LAR', 'La Rioja');
INSERT INTO `CubeCart_iso_counties` VALUES (157, 199, 'LAS', 'Las Palmas');
INSERT INTO `CubeCart_iso_counties` VALUES (158, 199, 'LEON', 'Leon');
INSERT INTO `CubeCart_iso_counties` VALUES (159, 199, 'LLEI', 'Lleida');
INSERT INTO `CubeCart_iso_counties` VALUES (160, 199, 'LUGO', 'Lugo');
INSERT INTO `CubeCart_iso_counties` VALUES (161, 199, 'MADR', 'Madrid');
INSERT INTO `CubeCart_iso_counties` VALUES (162, 199, 'MALA', 'Malaga');
INSERT INTO `CubeCart_iso_counties` VALUES (163, 199, 'MELI', 'Melilla');
INSERT INTO `CubeCart_iso_counties` VALUES (164, 199, 'MURC', 'Murcia');
INSERT INTO `CubeCart_iso_counties` VALUES (165, 199, 'NAVA', 'Navarra');
INSERT INTO `CubeCart_iso_counties` VALUES (166, 199, 'OURE', 'Ourense');
INSERT INTO `CubeCart_iso_counties` VALUES (167, 199, 'PALE', 'Palencia');
INSERT INTO `CubeCart_iso_counties` VALUES (168, 199, 'PONT', 'Pontevedra');
INSERT INTO `CubeCart_iso_counties` VALUES (169, 199, 'SALA', 'Salamanca');
INSERT INTO `CubeCart_iso_counties` VALUES (170, 199, 'SANT', 'Santa Cruz de Tenerife');
INSERT INTO `CubeCart_iso_counties` VALUES (171, 199, 'SEGO', 'Segovia');
INSERT INTO `CubeCart_iso_counties` VALUES (172, 199, 'SEVI', 'Sevilla');
INSERT INTO `CubeCart_iso_counties` VALUES (173, 199, 'SORI', 'Soria');
INSERT INTO `CubeCart_iso_counties` VALUES (174, 199, 'TARR', 'Tarragona');
INSERT INTO `CubeCart_iso_counties` VALUES (175, 199, 'TERU', 'Teruel');
INSERT INTO `CubeCart_iso_counties` VALUES (176, 199, 'TOLE', 'Toledo');
INSERT INTO `CubeCart_iso_counties` VALUES (177, 199, 'VALE', 'Valencia');
INSERT INTO `CubeCart_iso_counties` VALUES (178, 199, 'VALL', 'Valladolid');
INSERT INTO `CubeCart_iso_counties` VALUES (179, 199, 'VIZC', 'Vizcaya');
INSERT INTO `CubeCart_iso_counties` VALUES (180, 199, 'ZAMO', 'Zamora');
INSERT INTO `CubeCart_iso_counties` VALUES (181, 199, 'ZARA', 'Zaragoza');
INSERT INTO `CubeCart_iso_counties` VALUES (182, 225, 'ABE', 'Aberdeen');
INSERT INTO `CubeCart_iso_counties` VALUES (183, 225, 'ABD', 'Aberdeenshire');
INSERT INTO `CubeCart_iso_counties` VALUES (184, 225, 'AGY', 'Anglesey');
INSERT INTO `CubeCart_iso_counties` VALUES (185, 225, 'ANS', 'Angus');
INSERT INTO `CubeCart_iso_counties` VALUES (186, 225, 'ANT', 'Antrim');
INSERT INTO `CubeCart_iso_counties` VALUES (187, 225, 'ARD', 'Ards');
INSERT INTO `CubeCart_iso_counties` VALUES (188, 225, 'AGB', 'Argyll and Bute');
INSERT INTO `CubeCart_iso_counties` VALUES (189, 225, 'ARM', 'Armagh');
INSERT INTO `CubeCart_iso_counties` VALUES (190, 225, 'BLA', 'Ballymena');
INSERT INTO `CubeCart_iso_counties` VALUES (191, 225, 'BLY', 'Ballymoney');
INSERT INTO `CubeCart_iso_counties` VALUES (192, 225, 'BNB', 'Banbridge');
INSERT INTO `CubeCart_iso_counties` VALUES (193, 225, 'BDG', 'Barking and Dagenham');
INSERT INTO `CubeCart_iso_counties` VALUES (194, 225, 'BNE', 'Barnet');
INSERT INTO `CubeCart_iso_counties` VALUES (195, 225, 'BNS', 'Barnsley');
INSERT INTO `CubeCart_iso_counties` VALUES (196, 225, 'BAS', 'Bath and North East Somerset');
INSERT INTO `CubeCart_iso_counties` VALUES (197, 225, 'BDF', 'Bedfordshire');
INSERT INTO `CubeCart_iso_counties` VALUES (198, 225, 'BFS', 'Belfast');
INSERT INTO `CubeCart_iso_counties` VALUES (199, 225, 'BEX', 'Bexley');
INSERT INTO `CubeCart_iso_counties` VALUES (200, 225, 'BIR', 'Birmingham');
INSERT INTO `CubeCart_iso_counties` VALUES (201, 225, 'BBD', 'Blackburn with Darwen');
INSERT INTO `CubeCart_iso_counties` VALUES (202, 225, 'BPL', 'Blackpool');
INSERT INTO `CubeCart_iso_counties` VALUES (203, 225, 'BGW', 'Blaenau Gwent');
INSERT INTO `CubeCart_iso_counties` VALUES (204, 225, 'BOL', 'Bolton');
INSERT INTO `CubeCart_iso_counties` VALUES (205, 225, 'BMH', 'Bournemouth');
INSERT INTO `CubeCart_iso_counties` VALUES (206, 225, 'BRC', 'Bracknell Forest');
INSERT INTO `CubeCart_iso_counties` VALUES (207, 225, 'BRD', 'Bradford');
INSERT INTO `CubeCart_iso_counties` VALUES (208, 225, 'BEN', 'Brent');
INSERT INTO `CubeCart_iso_counties` VALUES (209, 225, 'BGE', 'Bridgend');
INSERT INTO `CubeCart_iso_counties` VALUES (210, 225, 'BNH', 'Brighton and Hove');
INSERT INTO `CubeCart_iso_counties` VALUES (211, 225, 'BST', 'Bristol');
INSERT INTO `CubeCart_iso_counties` VALUES (212, 225, 'BRY', 'Bromley');
INSERT INTO `CubeCart_iso_counties` VALUES (213, 225, 'BKM', 'Buckinghamshire');
INSERT INTO `CubeCart_iso_counties` VALUES (214, 225, 'BUR', 'Bury');
INSERT INTO `CubeCart_iso_counties` VALUES (215, 225, 'CAY', 'Caerphilly');
INSERT INTO `CubeCart_iso_counties` VALUES (216, 225, 'CLD', 'Calderdale');
INSERT INTO `CubeCart_iso_counties` VALUES (217, 225, 'CAM', 'Cambridgeshire');
INSERT INTO `CubeCart_iso_counties` VALUES (218, 225, 'CMD', 'Camden');
INSERT INTO `CubeCart_iso_counties` VALUES (219, 225, 'CRF', 'Cardiff');
INSERT INTO `CubeCart_iso_counties` VALUES (220, 225, 'CMN', 'Carmarthenshire');
INSERT INTO `CubeCart_iso_counties` VALUES (221, 225, 'CKF', 'Carrickfergus');
INSERT INTO `CubeCart_iso_counties` VALUES (222, 225, 'CSR', 'Castlereagh');
INSERT INTO `CubeCart_iso_counties` VALUES (223, 225, 'CGN', 'Ceredigion');
INSERT INTO `CubeCart_iso_counties` VALUES (224, 225, 'CHS', 'Cheshire');
INSERT INTO `CubeCart_iso_counties` VALUES (225, 225, 'CLK', 'Clackmannanshire');
INSERT INTO `CubeCart_iso_counties` VALUES (226, 225, 'CLR', 'Coleraine');
INSERT INTO `CubeCart_iso_counties` VALUES (227, 225, 'CWY', 'Conwy');
INSERT INTO `CubeCart_iso_counties` VALUES (228, 225, 'CKT', 'Cookstown');
INSERT INTO `CubeCart_iso_counties` VALUES (229, 225, 'CON', 'Cornwall');
INSERT INTO `CubeCart_iso_counties` VALUES (230, 225, 'COV', 'Coventry');
INSERT INTO `CubeCart_iso_counties` VALUES (231, 225, 'CGV', 'Craigavon');
INSERT INTO `CubeCart_iso_counties` VALUES (232, 225, 'CRY', 'Croydon');
INSERT INTO `CubeCart_iso_counties` VALUES (233, 225, 'CMA', 'Cumbria');
INSERT INTO `CubeCart_iso_counties` VALUES (234, 225, 'DAL', 'Darlington');
INSERT INTO `CubeCart_iso_counties` VALUES (235, 225, 'DEN', 'Denbighshire');
INSERT INTO `CubeCart_iso_counties` VALUES (236, 225, 'DER', 'Derby');
INSERT INTO `CubeCart_iso_counties` VALUES (237, 225, 'DBY', 'Derbyshire');
INSERT INTO `CubeCart_iso_counties` VALUES (238, 225, 'DRY', 'Derry');
INSERT INTO `CubeCart_iso_counties` VALUES (239, 225, 'DEV', 'Devon');
INSERT INTO `CubeCart_iso_counties` VALUES (240, 225, 'DNC', 'Doncaster');
INSERT INTO `CubeCart_iso_counties` VALUES (241, 225, 'DOR', 'Dorset');
INSERT INTO `CubeCart_iso_counties` VALUES (242, 225, 'DOW', 'Down');
INSERT INTO `CubeCart_iso_counties` VALUES (243, 225, 'DUD', 'Dudley');
INSERT INTO `CubeCart_iso_counties` VALUES (244, 225, 'DGY', 'Dumfries and Galloway');
INSERT INTO `CubeCart_iso_counties` VALUES (245, 225, 'DND', 'Dundee');
INSERT INTO `CubeCart_iso_counties` VALUES (246, 225, 'DGN', 'Dungannon');
INSERT INTO `CubeCart_iso_counties` VALUES (247, 225, 'DUR', 'Durham');
INSERT INTO `CubeCart_iso_counties` VALUES (248, 225, 'EAL', 'Ealing');
INSERT INTO `CubeCart_iso_counties` VALUES (249, 225, 'EAY', 'East Ayrshire');
INSERT INTO `CubeCart_iso_counties` VALUES (250, 225, 'EDU', 'East Dunbartonshire');
INSERT INTO `CubeCart_iso_counties` VALUES (251, 225, 'ELN', 'East Lothian');
INSERT INTO `CubeCart_iso_counties` VALUES (252, 225, 'ERW', 'East Renfrewshire');
INSERT INTO `CubeCart_iso_counties` VALUES (253, 225, 'ERY', 'East Riding of Yorkshire');
INSERT INTO `CubeCart_iso_counties` VALUES (254, 225, 'ESX', 'East Sussex');
INSERT INTO `CubeCart_iso_counties` VALUES (255, 225, 'EDH', 'Edinburgh');
INSERT INTO `CubeCart_iso_counties` VALUES (256, 225, 'ELS', 'Eilean Siar');
INSERT INTO `CubeCart_iso_counties` VALUES (257, 225, 'ENF', 'Enfield');
INSERT INTO `CubeCart_iso_counties` VALUES (258, 225, 'ESS', 'Essex');
INSERT INTO `CubeCart_iso_counties` VALUES (259, 225, 'FAL', 'Falkirk');
INSERT INTO `CubeCart_iso_counties` VALUES (260, 225, 'FER', 'Fermanagh');
INSERT INTO `CubeCart_iso_counties` VALUES (261, 225, 'FIF', 'Fife');
INSERT INTO `CubeCart_iso_counties` VALUES (262, 225, 'FLN', 'Flintshire');
INSERT INTO `CubeCart_iso_counties` VALUES (263, 225, 'GAT', 'Gateshead');
INSERT INTO `CubeCart_iso_counties` VALUES (264, 225, 'GLG', 'Glasgow');
INSERT INTO `CubeCart_iso_counties` VALUES (265, 225, 'GLS', 'Gloucestershire');
INSERT INTO `CubeCart_iso_counties` VALUES (266, 225, 'GRE', 'Greenwich');
INSERT INTO `CubeCart_iso_counties` VALUES (267, 225, 'GSY', 'Guernsey');
INSERT INTO `CubeCart_iso_counties` VALUES (268, 225, 'GWN', 'Gwynedd');
INSERT INTO `CubeCart_iso_counties` VALUES (269, 225, 'HCK', 'Hackney');
INSERT INTO `CubeCart_iso_counties` VALUES (270, 225, 'HAL', 'Halton');
INSERT INTO `CubeCart_iso_counties` VALUES (271, 225, 'HMF', 'Hammersmith and Fulham');
INSERT INTO `CubeCart_iso_counties` VALUES (272, 225, 'HAM', 'Hampshire');
INSERT INTO `CubeCart_iso_counties` VALUES (273, 225, 'HRY', 'Haringey');
INSERT INTO `CubeCart_iso_counties` VALUES (274, 225, 'HRW', 'Harrow');
INSERT INTO `CubeCart_iso_counties` VALUES (275, 225, 'HPL', 'Hartlepool');
INSERT INTO `CubeCart_iso_counties` VALUES (276, 225, 'HAV', 'Havering');
INSERT INTO `CubeCart_iso_counties` VALUES (277, 225, 'HEF', 'Herefordshire');
INSERT INTO `CubeCart_iso_counties` VALUES (278, 225, 'HRT', 'Hertfordshire');
INSERT INTO `CubeCart_iso_counties` VALUES (279, 225, 'HLD', 'Highland');
INSERT INTO `CubeCart_iso_counties` VALUES (280, 225, 'HIL', 'Hillingdon');
INSERT INTO `CubeCart_iso_counties` VALUES (281, 225, 'HNS', 'Hounslow');
INSERT INTO `CubeCart_iso_counties` VALUES (282, 225, 'IVC', 'Inverclyde');
INSERT INTO `CubeCart_iso_counties` VALUES (283, 225, 'IOM', 'Isle of Man');
INSERT INTO `CubeCart_iso_counties` VALUES (284, 225, 'IOW', 'Isle of Wight');
INSERT INTO `CubeCart_iso_counties` VALUES (285, 225, 'IOS', 'Isles of Scilly');
INSERT INTO `CubeCart_iso_counties` VALUES (286, 225, 'ISL', 'Islington');
INSERT INTO `CubeCart_iso_counties` VALUES (287, 225, 'JSY', 'Jersey');
INSERT INTO `CubeCart_iso_counties` VALUES (288, 225, 'KEC', 'Kensington and Chelsea');
INSERT INTO `CubeCart_iso_counties` VALUES (289, 225, 'KEN', 'Kent');
INSERT INTO `CubeCart_iso_counties` VALUES (290, 225, 'KHL', 'Kingston upon Hull');
INSERT INTO `CubeCart_iso_counties` VALUES (291, 225, 'KTT', 'Kingston upon Thames');
INSERT INTO `CubeCart_iso_counties` VALUES (292, 225, 'KIR', 'Kirklees');
INSERT INTO `CubeCart_iso_counties` VALUES (293, 225, 'KWL', 'Knowsley');
INSERT INTO `CubeCart_iso_counties` VALUES (294, 225, 'LBH', 'Lambeth');
INSERT INTO `CubeCart_iso_counties` VALUES (295, 225, 'LAN', 'Lancashire');
INSERT INTO `CubeCart_iso_counties` VALUES (296, 225, 'LRN', 'Larne');
INSERT INTO `CubeCart_iso_counties` VALUES (297, 225, 'LDS', 'Leeds');
INSERT INTO `CubeCart_iso_counties` VALUES (298, 225, 'LCE', 'Leicester');
INSERT INTO `CubeCart_iso_counties` VALUES (299, 225, 'LEC', 'Leicestershire');
INSERT INTO `CubeCart_iso_counties` VALUES (300, 225, 'LEW', 'Lewisham');
INSERT INTO `CubeCart_iso_counties` VALUES (301, 225, 'LMV', 'Limavady');
INSERT INTO `CubeCart_iso_counties` VALUES (302, 225, 'LIN', 'Lincolnshire');
INSERT INTO `CubeCart_iso_counties` VALUES (303, 225, 'LSB', 'Lisburn');
INSERT INTO `CubeCart_iso_counties` VALUES (304, 225, 'LIV', 'Liverpool');
INSERT INTO `CubeCart_iso_counties` VALUES (305, 225, 'LND', 'London');
INSERT INTO `CubeCart_iso_counties` VALUES (306, 225, 'LUT', 'Luton');
INSERT INTO `CubeCart_iso_counties` VALUES (307, 225, 'MFT', 'Magherafelt');
INSERT INTO `CubeCart_iso_counties` VALUES (308, 225, 'MAN', 'Manchester');
INSERT INTO `CubeCart_iso_counties` VALUES (309, 225, 'MDW', 'Medway');
INSERT INTO `CubeCart_iso_counties` VALUES (310, 225, 'MTY', 'Merthyr Tydfil');
INSERT INTO `CubeCart_iso_counties` VALUES (311, 225, 'MRT', 'Merton');
INSERT INTO `CubeCart_iso_counties` VALUES (312, 225, 'MDB', 'Middlesbrough');
INSERT INTO `CubeCart_iso_counties` VALUES (313, 225, 'MLN', 'Midlothian');
INSERT INTO `CubeCart_iso_counties` VALUES (314, 225, 'MIK', 'Milton Keynes');
INSERT INTO `CubeCart_iso_counties` VALUES (315, 225, 'MON', 'Monmouthshire');
INSERT INTO `CubeCart_iso_counties` VALUES (316, 225, 'MRY', 'Moray');
INSERT INTO `CubeCart_iso_counties` VALUES (317, 225, 'MYL', 'Moyle');
INSERT INTO `CubeCart_iso_counties` VALUES (318, 225, 'NTL', 'Neath Port Talbot');
INSERT INTO `CubeCart_iso_counties` VALUES (319, 225, 'NET', 'Newcastle upon Tyne');
INSERT INTO `CubeCart_iso_counties` VALUES (320, 225, 'NWM', 'Newham');
INSERT INTO `CubeCart_iso_counties` VALUES (321, 225, 'NWP', 'Newport');
INSERT INTO `CubeCart_iso_counties` VALUES (322, 225, 'NYM', 'Newry and Mourne');
INSERT INTO `CubeCart_iso_counties` VALUES (323, 225, 'NTA', 'Newtownabbey');
INSERT INTO `CubeCart_iso_counties` VALUES (324, 225, 'NFK', 'Norfolk');
INSERT INTO `CubeCart_iso_counties` VALUES (325, 225, 'NTH', 'Northamptonshire');
INSERT INTO `CubeCart_iso_counties` VALUES (326, 225, 'NAY', 'North Ayrshire');
INSERT INTO `CubeCart_iso_counties` VALUES (327, 225, 'NDN', 'North Down');
INSERT INTO `CubeCart_iso_counties` VALUES (328, 225, 'NEL', 'North East Lincolnshire');
INSERT INTO `CubeCart_iso_counties` VALUES (329, 225, 'NLK', 'North Lanarkshire');
INSERT INTO `CubeCart_iso_counties` VALUES (330, 225, 'NLN', 'North Lincolnshire');
INSERT INTO `CubeCart_iso_counties` VALUES (331, 225, 'NSM', 'North Somerset');
INSERT INTO `CubeCart_iso_counties` VALUES (332, 225, 'NTY', 'North Tyneside');
INSERT INTO `CubeCart_iso_counties` VALUES (333, 225, 'NBL', 'Northumberland');
INSERT INTO `CubeCart_iso_counties` VALUES (334, 225, 'NYK', 'North Yorkshire');
INSERT INTO `CubeCart_iso_counties` VALUES (335, 225, 'NGM', 'Nottingham');
INSERT INTO `CubeCart_iso_counties` VALUES (336, 225, 'NTT', 'Nottinghamshire');
INSERT INTO `CubeCart_iso_counties` VALUES (337, 225, 'OLD', 'Oldham');
INSERT INTO `CubeCart_iso_counties` VALUES (338, 225, 'OMH', 'Omagh');
INSERT INTO `CubeCart_iso_counties` VALUES (339, 225, 'ORK', 'Orkney Islands');
INSERT INTO `CubeCart_iso_counties` VALUES (340, 225, 'OXF', 'Oxfordshire');
INSERT INTO `CubeCart_iso_counties` VALUES (341, 225, 'PEM', 'Pembrokeshire');
INSERT INTO `CubeCart_iso_counties` VALUES (342, 225, 'PKN', 'Perthshire and Kinross');
INSERT INTO `CubeCart_iso_counties` VALUES (343, 225, 'PTE', 'Peterborough');
INSERT INTO `CubeCart_iso_counties` VALUES (344, 225, 'PLY', 'Plymouth');
INSERT INTO `CubeCart_iso_counties` VALUES (345, 225, 'POL', 'Poole');
INSERT INTO `CubeCart_iso_counties` VALUES (346, 225, 'POR', 'Portsmouth');
INSERT INTO `CubeCart_iso_counties` VALUES (347, 225, 'POW', 'Powys');
INSERT INTO `CubeCart_iso_counties` VALUES (348, 225, 'RDG', 'Reading');
INSERT INTO `CubeCart_iso_counties` VALUES (349, 225, 'RDB', 'Redbridge');
INSERT INTO `CubeCart_iso_counties` VALUES (350, 225, 'RCC', 'Redcar and Cleveland');
INSERT INTO `CubeCart_iso_counties` VALUES (351, 225, 'RFW', 'Renfrewshire');
INSERT INTO `CubeCart_iso_counties` VALUES (352, 225, 'RCT', 'Rhondda, Cynon, Taff');
INSERT INTO `CubeCart_iso_counties` VALUES (353, 225, 'RIC', 'Richmond upon Thames');
INSERT INTO `CubeCart_iso_counties` VALUES (354, 225, 'RCH', 'Rochdale');
INSERT INTO `CubeCart_iso_counties` VALUES (355, 225, 'ROT', 'Rotherham');
INSERT INTO `CubeCart_iso_counties` VALUES (356, 225, 'RUT', 'Rutland');
INSERT INTO `CubeCart_iso_counties` VALUES (357, 225, 'SHN', 'Saint Helens');
INSERT INTO `CubeCart_iso_counties` VALUES (358, 225, 'SLF', 'Salford');
INSERT INTO `CubeCart_iso_counties` VALUES (359, 225, 'SAW', 'Sandwell');
INSERT INTO `CubeCart_iso_counties` VALUES (360, 225, 'SCB', 'Scottish Borders');
INSERT INTO `CubeCart_iso_counties` VALUES (361, 225, 'SFT', 'Sefton');
INSERT INTO `CubeCart_iso_counties` VALUES (362, 225, 'SHF', 'Sheffield');
INSERT INTO `CubeCart_iso_counties` VALUES (363, 225, 'ZET', 'Shetland Islands');
INSERT INTO `CubeCart_iso_counties` VALUES (364, 225, 'SHR', 'Shropshire');
INSERT INTO `CubeCart_iso_counties` VALUES (365, 225, 'SLG', 'Slough');
INSERT INTO `CubeCart_iso_counties` VALUES (366, 225, 'SOL', 'Solihull');
INSERT INTO `CubeCart_iso_counties` VALUES (367, 225, 'SOM', 'Somerset');
INSERT INTO `CubeCart_iso_counties` VALUES (368, 225, 'STH', 'Southampton');
INSERT INTO `CubeCart_iso_counties` VALUES (369, 225, 'SAY', 'South Ayrshire');
INSERT INTO `CubeCart_iso_counties` VALUES (370, 225, 'SOS', 'Southend-on-Sea');
INSERT INTO `CubeCart_iso_counties` VALUES (371, 225, 'SGC', 'South Gloucestershire');
INSERT INTO `CubeCart_iso_counties` VALUES (372, 225, 'SLK', 'South Lanarkshire');
INSERT INTO `CubeCart_iso_counties` VALUES (373, 225, 'STY', 'South Tyneside');
INSERT INTO `CubeCart_iso_counties` VALUES (374, 225, 'SWK', 'Southwark');
INSERT INTO `CubeCart_iso_counties` VALUES (375, 225, 'STS', 'Staffordshire');
INSERT INTO `CubeCart_iso_counties` VALUES (376, 225, 'STG', 'Stirling');
INSERT INTO `CubeCart_iso_counties` VALUES (377, 225, 'SKP', 'Stockport');
INSERT INTO `CubeCart_iso_counties` VALUES (378, 225, 'STT', 'Stockton-on-Tees');
INSERT INTO `CubeCart_iso_counties` VALUES (379, 225, 'STE', 'Stoke-on-Trent');
INSERT INTO `CubeCart_iso_counties` VALUES (380, 225, 'STB', 'Strabane');
INSERT INTO `CubeCart_iso_counties` VALUES (381, 225, 'SFK', 'Suffolk');
INSERT INTO `CubeCart_iso_counties` VALUES (382, 225, 'SND', 'Sunderland');
INSERT INTO `CubeCart_iso_counties` VALUES (383, 225, 'SRY', 'Surrey');
INSERT INTO `CubeCart_iso_counties` VALUES (384, 225, 'STN', 'Sutton');
INSERT INTO `CubeCart_iso_counties` VALUES (385, 225, 'SWA', 'Swansea');
INSERT INTO `CubeCart_iso_counties` VALUES (386, 225, 'SWD', 'Swindon');
INSERT INTO `CubeCart_iso_counties` VALUES (387, 225, 'TAM', 'Tameside');
INSERT INTO `CubeCart_iso_counties` VALUES (388, 225, 'TFW', 'Telford and Wrekin');
INSERT INTO `CubeCart_iso_counties` VALUES (389, 225, 'THR', 'Thurrock');
INSERT INTO `CubeCart_iso_counties` VALUES (390, 225, 'TOB', 'Torbay');
INSERT INTO `CubeCart_iso_counties` VALUES (391, 225, 'TOF', 'Torfaen');
INSERT INTO `CubeCart_iso_counties` VALUES (392, 225, 'TWH', 'Tower Hamlets');
INSERT INTO `CubeCart_iso_counties` VALUES (393, 225, 'TRF', 'Trafford');
INSERT INTO `CubeCart_iso_counties` VALUES (394, 225, 'VGL', 'Vale of Glamorgan');
INSERT INTO `CubeCart_iso_counties` VALUES (395, 225, 'WKF', 'Wakefield');
INSERT INTO `CubeCart_iso_counties` VALUES (396, 225, 'WLL', 'Walsall');
INSERT INTO `CubeCart_iso_counties` VALUES (397, 225, 'WFT', 'Waltham Forest');
INSERT INTO `CubeCart_iso_counties` VALUES (398, 225, 'WND', 'Wandsworth');
INSERT INTO `CubeCart_iso_counties` VALUES (399, 225, 'WRT', 'Warrington');
INSERT INTO `CubeCart_iso_counties` VALUES (400, 225, 'WAR', 'Warwickshire');
INSERT INTO `CubeCart_iso_counties` VALUES (401, 225, 'WBK', 'West Berkshire');
INSERT INTO `CubeCart_iso_counties` VALUES (402, 225, 'WDU', 'West Dunbartonshire');
INSERT INTO `CubeCart_iso_counties` VALUES (403, 225, 'WLN', 'West Lothian');
INSERT INTO `CubeCart_iso_counties` VALUES (404, 225, 'WSM', 'Westminster');
INSERT INTO `CubeCart_iso_counties` VALUES (405, 225, 'WSX', 'West Sussex');
INSERT INTO `CubeCart_iso_counties` VALUES (406, 225, 'WGN', 'Wigan');
INSERT INTO `CubeCart_iso_counties` VALUES (407, 225, 'WIL', 'Wiltshire');
INSERT INTO `CubeCart_iso_counties` VALUES (408, 225, 'WNM', 'Windsor and Maidenhead');
INSERT INTO `CubeCart_iso_counties` VALUES (409, 225, 'WRL', 'Wirral');
INSERT INTO `CubeCart_iso_counties` VALUES (410, 225, 'WOK', 'Wokingham');
INSERT INTO `CubeCart_iso_counties` VALUES (411, 225, 'WLV', 'Wolverhampton');
INSERT INTO `CubeCart_iso_counties` VALUES (412, 225, 'WOR', 'Worcestershire');
INSERT INTO `CubeCart_iso_counties` VALUES (413, 225, 'WRX', 'Wrexham');
INSERT INTO `CubeCart_iso_counties` VALUES (414, 225, 'YOR', 'York');
INSERT INTO `CubeCart_iso_counties` VALUES (415, 103, 'CW', 'Carlow');
INSERT INTO `CubeCart_iso_counties` VALUES (416, 103, 'CN', 'Cavan');
INSERT INTO `CubeCart_iso_counties` VALUES (417, 103, 'CE', 'Clare');
INSERT INTO `CubeCart_iso_counties` VALUES (418, 103, 'C', 'Cork');
INSERT INTO `CubeCart_iso_counties` VALUES (419, 103, 'DL', 'Donegal');
INSERT INTO `CubeCart_iso_counties` VALUES (420, 103, 'D', 'Dublin');
INSERT INTO `CubeCart_iso_counties` VALUES (421, 103, 'G', 'Galway');
INSERT INTO `CubeCart_iso_counties` VALUES (422, 103, 'KY', 'Kerry');
INSERT INTO `CubeCart_iso_counties` VALUES (423, 103, 'KE', 'Kildare');
INSERT INTO `CubeCart_iso_counties` VALUES (424, 103, 'KK', 'Kilkenny');
INSERT INTO `CubeCart_iso_counties` VALUES (425, 103, 'LS', 'Laoighis');
INSERT INTO `CubeCart_iso_counties` VALUES (426, 103, 'LM', 'Leitrim');
INSERT INTO `CubeCart_iso_counties` VALUES (427, 103, 'LK', 'Limerick');
INSERT INTO `CubeCart_iso_counties` VALUES (428, 103, 'LD', 'Longford');
INSERT INTO `CubeCart_iso_counties` VALUES (429, 103, 'LH', 'Louth');
INSERT INTO `CubeCart_iso_counties` VALUES (430, 103, 'MO', 'Mayo');
INSERT INTO `CubeCart_iso_counties` VALUES (431, 103, 'MH', 'Meath');
INSERT INTO `CubeCart_iso_counties` VALUES (432, 103, 'MN', 'Monaghan');
INSERT INTO `CubeCart_iso_counties` VALUES (433, 103, 'OY', 'Offaly');
INSERT INTO `CubeCart_iso_counties` VALUES (434, 103, 'RN', 'Roscommon');
INSERT INTO `CubeCart_iso_counties` VALUES (435, 103, 'SO', 'Sligo');
INSERT INTO `CubeCart_iso_counties` VALUES (436, 103, 'TA', 'Tipperary');
INSERT INTO `CubeCart_iso_counties` VALUES (437, 103, 'WD', 'Waterford');
INSERT INTO `CubeCart_iso_counties` VALUES (438, 103, 'WH', 'Westmeath');
INSERT INTO `CubeCart_iso_counties` VALUES (439, 103, 'WX', 'Wexford');
INSERT INTO `CubeCart_iso_counties` VALUES (440, 103, 'WW', 'Wicklow');

CREATE TABLE `CubeCart_iso_countries` (
`id` int(11) NOT NULL auto_increment,
`iso` char(2) NOT NULL default '',
`printable_name` varchar(80) NOT NULL default '',
`iso3` char(3) default NULL,
`numcode` smallint(6) default NULL,
PRIMARY KEY (`iso`),
KEY `id` (`id`),
KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=242 ;

INSERT INTO `CubeCart_iso_countries` VALUES (1, 'AF', 'Afghanistan', 'AFG', 4);
INSERT INTO `CubeCart_iso_countries` VALUES (2, 'AL', 'Albania', 'ALB', 8);
INSERT INTO `CubeCart_iso_countries` VALUES (3, 'DZ', 'Algeria', 'DZA', 12);
INSERT INTO `CubeCart_iso_countries` VALUES (4, 'AS', 'American Samoa', 'ASM', 16);
INSERT INTO `CubeCart_iso_countries` VALUES (5, 'AD', 'Andorra', 'AND', 20);
INSERT INTO `CubeCart_iso_countries` VALUES (6, 'AO', 'Angola', 'AGO', 24);
INSERT INTO `CubeCart_iso_countries` VALUES (7, 'AI', 'Anguilla', 'AIA', 660);
INSERT INTO `CubeCart_iso_countries` VALUES (8, 'AQ', 'Antarctica', NULL, NULL);
INSERT INTO `CubeCart_iso_countries` VALUES (9, 'AG', 'Antigua and Barbuda', 'ATG', 28);
INSERT INTO `CubeCart_iso_countries` VALUES (10, 'AR', 'Argentina', 'ARG', 32);
INSERT INTO `CubeCart_iso_countries` VALUES (11, 'AM', 'Armenia', 'ARM', 51);
INSERT INTO `CubeCart_iso_countries` VALUES (12, 'AW', 'Aruba', 'ABW', 533);
INSERT INTO `CubeCart_iso_countries` VALUES (13, 'AU', 'Australia', 'AUS', 36);
INSERT INTO `CubeCart_iso_countries` VALUES (14, 'AT', 'Austria', 'AUT', 40);
INSERT INTO `CubeCart_iso_countries` VALUES (15, 'AZ', 'Azerbaijan', 'AZE', 31);
INSERT INTO `CubeCart_iso_countries` VALUES (16, 'BS', 'Bahamas', 'BHS', 44);
INSERT INTO `CubeCart_iso_countries` VALUES (17, 'BH', 'Bahrain', 'BHR', 48);
INSERT INTO `CubeCart_iso_countries` VALUES (18, 'BD', 'Bangladesh', 'BGD', 50);
INSERT INTO `CubeCart_iso_countries` VALUES (19, 'BB', 'Barbados', 'BRB', 52);
INSERT INTO `CubeCart_iso_countries` VALUES (20, 'BY', 'Belarus', 'BLR', 112);
INSERT INTO `CubeCart_iso_countries` VALUES (21, 'BE', 'Belgium', 'BEL', 56);
INSERT INTO `CubeCart_iso_countries` VALUES (22, 'BZ', 'Belize', 'BLZ', 84);
INSERT INTO `CubeCart_iso_countries` VALUES (23, 'BJ', 'Benin', 'BEN', 204);
INSERT INTO `CubeCart_iso_countries` VALUES (24, 'BM', 'Bermuda', 'BMU', 60);
INSERT INTO `CubeCart_iso_countries` VALUES (25, 'BT', 'Bhutan', 'BTN', 64);
INSERT INTO `CubeCart_iso_countries` VALUES (26, 'BO', 'Bolivia', 'BOL', 68);
INSERT INTO `CubeCart_iso_countries` VALUES (27, 'BA', 'Bosnia and Herzegovina', 'BIH', 70);
INSERT INTO `CubeCart_iso_countries` VALUES (28, 'BW', 'Botswana', 'BWA', 72);
INSERT INTO `CubeCart_iso_countries` VALUES (29, 'BV', 'Bouvet Island', NULL, NULL);
INSERT INTO `CubeCart_iso_countries` VALUES (30, 'BR', 'Brazil', 'BRA', 76);
INSERT INTO `CubeCart_iso_countries` VALUES (31, 'IO', 'British Indian Ocean Territory', NULL, NULL);
INSERT INTO `CubeCart_iso_countries` VALUES (32, 'BN', 'Brunei Darussalam', 'BRN', 96);
INSERT INTO `CubeCart_iso_countries` VALUES (33, 'BG', 'Bulgaria', 'BGR', 100);
INSERT INTO `CubeCart_iso_countries` VALUES (34, 'BF', 'Burkina Faso'

April 27, 2005

well I also got error as the same person that started this post,

My Webpage

April 27, 2005

MySQL Error Occured
1050: Table 'CubeCart_category' already exists

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;

Hi,

to avoid this error I simply changed the declaration of primary key to the following:

PRIMARY KEY (`cat_id`).

Sign In

mysql error occured..

Recommended Posts

xyncro

Link to comment

Share on other sites

Guest OD-UNICRON

Link to comment

Share on other sites

Guest OD-UNICRON

Link to comment

Share on other sites

Guest OD-UNICRON

Link to comment

Share on other sites

Guest

Link to comment

Share on other sites

Join the conversation

Browse

Activity