Printable View
Howdy all,
I deleted all of the zones from zen_zones database and know I can only select one state when making an account.
I need to add the other 49 states back in. What is the easiest way to to this? Im not that familiar with sql. Can I make a spreadsheet with the required info and upload it?
Any help would be appreciated.
Brent
Best to restore from the backup you made before deleting them.
IF no backup, perhaps http://tinyurl.com/7mjaw5l can help.
I dont have a back up. I was working with a fresh installation. Thanks though.Quote:
Originally Posted by DrByte
Look at your database in phpMyAdmin ...
How many records are in the zones table now?
Only one for Nevada. I put this together and was planning on pasting it in SQL tools.Quote:
Originally Posted by Ajeh
Code:INSERT INTO 'zones' ('zone_id', 'zone_country_id', 'zone_code', 'zone_name') VALUES
(1, 223, AL, Alabama),
(2, 223, AK, Alaska),
(3, 223, AZ, Arizona),
(4, 223, AR, Arkansas),
(5, 223, CA, California),
(6, 223, CO, Colorado),
(7, 223, CT, Connecticut),
(8, 223, DE, Delaware),
(9, 223, FL, Florida),
(10, 223, GA, Georgia),
(11, 223, HI, Hawaii),
(12, 223, ID, Idaho),
(13, 223, IL, Illinois),
(14, 223, IN, Indiana),
(15, 223, IA, Iowa),
(16, 223, KS, Kansas),
(17, 223, KY, Kentucky),
(18, 223, LA, Louisiana),
(19, 223, ME, Maine),
(20, 223, MD, Maryland),
(21, 223, MA, Massachusetts),
(22, 223, MI, Michigan),
(23, 223, MN, Minnesota),
(24, 223, MS, Mississippi),
(25, 223, MO, Missouri),
(26, 223, MT, Montana),
(27, 223, NE, Nebraska),
(28, 223, NV, Nevada),
(29, 223, NH, New Hampshire),
(30, 223, NJ, New Jersey),
(31, 223, NM, New Mexico),
(32, 223, NY, New York),
(33, 223, NC, North Carolina),
(34, 223, ND, North Dakota),
(35, 223, OH, Ohio),
(36, 223, OK, Oklahoma),
(37, 223, OR, Oregon),
(38, 223, PA, Pennsylvania),
(39, 223, RI, Rhode Island),
(40, 223, SC, South Carolina),
(41, 223, SD, South Dakota),
(42, 223, TN, Tennessee),
(43, 223, TX, Texas),
(44, 223, UT, Utah),
(45, 223, VT, Vermont),
(46, 223, VA, Virginia),
(47, 223, WA, Washington),
(48, 223, WV, West Virginia),
(49, 223, WI, Wisconsin),
(50, 223, WY, Wyoming);
The first line in the code above should read:
When i past the code it get this error:Code:INSERT INTO `zones` (`zone_id`, `zone_country_id`, `zone_code`, `zone_name`) VALUES
There isn't any obvious errors in my code. Do you have any ideas?Quote:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN, Indiana), (15, 223, IA, Iowa), (16, 223, KS, Kansas), (17, 223, KY, Kentucky' at line 1
in:
[INSERT INTO zen_zones (zone_id, zone_country_id, zone_code, zone_name) VALUES (1, 223, AL, Alabama), (2, 223, AK, Alaska), (3, 223, AZ, Arizona), (4, 223, AR, Arkansas), (5, 223, CA, California), (6, 223, CO, Colorado), (7, 223, CT, Connecticut), (8, 223, DE, Delaware), (9, 223, FL, Florida), (10, 223, GA, Georgia), (11, 223, HI, Hawaii), (12, 223, ID, Idaho), (13, 223, IL, Illinois), (14, 223, IN, Indiana), (15, 223, IA, Iowa), (16, 223, KS, Kansas), (17, 223, KY, Kentucky), (18, 223, LA, Louisiana), (19, 223, ME, Maine), (20, 223, MD, Maryland), (21, 223, MA, Massachusetts), (22, 223, MI, Michigan), (23, 223, MN, Minnesota), (24, 223, MS, Mississippi), (25, 223, MO, Missouri), (26, 223, MT, Montana), (27, 223, NE, Nebraska), (28, 223, NV, Nevada), (29, 223, NH, New Hampshire), (30, 223, NJ, New Jersey), (31, 223, NM, New Mexico), (32, 223, NY, New York), (33, 223, NC, North Carolina), (34, 223, ND, North Dakota), (35, 223, OH, Ohio), (36, 223, OK, Oklahoma), (37, 223, OR, Oregon), (38, 223, PA, Pennsylvania), (39, 223, RI, Rhode Island), (40, 223, SC, South Carolina), (41, 223, SD, South Dakota), (42, 223, TN, Tennessee), (43, 223, TX, Texas), (44, 223, UT, Utah), (45, 223, VT, Vermont), (46, 223, VA, Virginia), (47, 223, WA, Washington), (48, 223, WV, West Virginia), (49, 223, WI, Wisconsin), (50, 223, WY, Wyoming);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Also, I noticed that zone_id is set as auto increment. Should i remove that from my code?
Those do not match the defaults in a clean install ...
You might look in the /zc_install/sql/mysql_latin1.sql or the /zc_install/sql/mysql_utf8.sql depending on how you set up your database and you will see the INSERT statements for USA ...
I would back everything up and rebuild that table ...
Why exactly did you delete things in the first place?
If it was a fresh install, then another fresh install will put back everything as it was.Quote:
Originally Posted by mentose457
I Thought I was deleting the ability to set up shipping/taxing zones. Not the ability to select the state while signing in.Quote:
Originally Posted by DrByte
Thanks. Ill give that a try.Quote:
Originally Posted by Ajeh
I'd go with DrByte's suggestions if this is a new install ...
Then, you can make Zone Definitions and set in the DETAILS who you want to ship to ...
This way, Grandma in the UK can buy little Tiny Tim in the US a new crutch for Christmas ... :smile:
The zones table contains zones which are associated with their country counterparts. In the US those are called States. In most countries they're called Provinces. The predefined entries should not be deleted.
The geo_zones and zones_to_geo_zones tables are what's used to define the zone definitions you use for assigning to taxes and shipping etc.
YOU NEVER NEED TO EDIT THOSE TABLES MANUALLY. The admin console gives you all the tools you need for managing those tables. There's no need to go to the raw database data. Especially for US stores.
Thanks for the replies guys.
So... If i make a back up of everything in public_html can i restore it after i re-install zen cart?
A proper backup consists of all the files in your Zen Cart folder on your server (sounds like in YOUR case that's public_html), plus an export of your database: https://www.zen-cart.com/tutorials/i...hp?article=103