Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Zone error

iessence

By iessence
in General Support

Recommended Posts

iessence

iessence

Posted
Posted

To install a shipping module i gotta insert the new zones into the zones table, using the included zones.sql

 

Zones.sql:

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (130, 30, 'AC', 'AC Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (131, 30, 'AL', 'AL Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (132, 30, 'AP', 'AP Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (133, 30, 'AM', 'AM Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (134, 30, 'BA', 'BA Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (135, 30, 'CE', 'CE Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (136, 30, 'DF', 'DF');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (137, 30, 'ES', 'ES Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (138, 30, 'GO', 'GO Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (139, 30, 'MA', 'MA Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (140, 30, 'MT', 'MT Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (141, 30, 'MS', 'MS Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (142, 30, 'MG', 'MG Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (143, 30, 'PA', 'PA Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (144, 30, 'PB', 'PB Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (145, 30, 'PR', 'PR Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (146, 30, 'PI', 'PI Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (147, 30, 'RJ', 'RJ Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (148, 30, 'RN', 'RN Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (149, 30, 'RS', 'RS Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (150, 30, 'RO', 'RO Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (151, 30, 'RR', 'RR Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (152, 30, 'SC', 'SC Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (153, 30, 'SP', 'SP');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (154, 30, 'SE', 'SE Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (155, 30, 'TO', 'TO Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (156, 30, 'PE', 'PE Interior');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (157, 30, 'AC', 'AC Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (158, 30, 'AL', 'AL?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (159, 30, 'AP', 'AP?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (160, 30, 'AM', 'AM?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (161, 30, 'BA', 'BA?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (162, 30, 'CE', 'CE?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (163, 30, 'ES', 'ES?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (164, 30, 'GO', 'GO?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (165, 30, 'MA', 'MA?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (166, 30, 'MT', 'MT?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (167, 30, 'MS', 'MS?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (168, 30, 'MG', 'MG?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (169, 30, 'PA', 'PA?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (170, 30, 'PB', 'PB?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (171, 30, 'PE', 'PE?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (172, 30, 'PR', 'PR?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (173, 30, 'PI', 'PI?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (174, 30, 'RJ', 'RJ?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (175, 30, 'RN', 'RN?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (176, 30, 'RS', 'RS?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (177, 30, 'RO', 'RO?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (178, 30, 'RR', 'RR?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (179, 30, 'SC', 'SC?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (180, 30, 'SE', 'SE?Capital');

INSERT INTO zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (181, 30, 'TO', 'TO?Capital');

 

 

But mySQL display this error message:

#1062 - Duplicate entry '130' for key 1

 

 

How do i fix it?

 

 

 

 

 

 

 

And then i got to in checkout_payment.php in the catalog directory find line 54 approx

 

$address = tep_db_query("select entry_postcode as postcode, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $customer_id . "' and address_book_id = '" . $sendto . "'");

$address_values = tep_db_fetch_array($address);

 

 

and replace with

 

$address = tep_db_query("select entry_zone_id as zone_id, entry_postcode as postcode, entry_country_id as country_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . $customer_id . "' and address_book_id = '" . $sendto . "'");

$address_values = tep_db_fetch_array($address);

 

 

 

and there is no such line in checkout_payment

 

 

please, help me.. it's the best shipping way avaible for my country

~

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...