Hi all,
I'm trying to import the install sql file from the MultiGeoZone / MultiTable Shipping module for OS Commerce. When I try to import the sql file in PHPMyAdmin I get this error message: #1062 - Duplicate entry '0' for key 1
Can anyone tell me what to change in the import file to avoid this? This is the file. I have already tried changing both zeroes to ones but got the same message. Thanks.
INSERT INTO configuration_group VALUES ('', 'MultiGeoZone MultiTable Shipping', 'The options which configure the MultiGeoZone MultiTable Shipping Module', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
INSERT INTO configuration VALUES ('', 'Number of Geo Zones', 'MODULE_SHIPPING_MZMT_NUMBER_GEOZONES', '3', 'The number of shipping geo zones.', last_insert_id(), '0', NULL, now(), NULL, NULL),
('', 'Number of Tables per Geo Zone', 'MODULE_SHIPPING_MZMT_NUMBER_TABLES', '3', 'The number of shipping tables per geo zone.', last_insert_id(), '0', NULL, now(), NULL, NULL);
