[#4350] Error when copying Geographic Zone

lousyfool
OFFLINE
Posts: 141
Thanks: 46
Karma: 5

8 years 9 months ago - 8 years 9 months ago #277947 by lousyfool

[#4350] Error when copying Geographic Zone was created by lousyfool

Hi,

When attempting to copy any Geographic Zone (in this example the default "European Union"), the following error is thrown:

Code:

1062 Duplicate entry 'European Union' for key 'name' SQL=INSERT INTO `j_cbsubs_geo_zones` (`name`,`description`,`ordering`,`owner`) VALUES ('European Union','Collection of EU Countries','2','0')

I needed several zones, so I helped myself with CSV export/re-import through phpMyAdmin, but thought I'd let you know that there's a bug in your script.

Thanks for consideration!

CB 2.0.13
CBSubs 4.0.1
J! 3.4.8
PHP 5.5.3

Last edit: 8 years 9 months ago by krileon.

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48548
Thanks: 8290
Karma: 1445

8 years 9 months ago #278365 by krileon

Replied by krileon on topic Error when copying Geographic Zone

The name has to be unique. You can't have 2 identical geographical zones. The copy functionality should handle this, but it doesn't. It should at least append a 2 or something like fields do. I've added a bug ticket for this.

For now you'll need to create the new geographical zone using the New button instead of copying or as you've already done directly do it through a database query.

#4350

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

The following user(s) said Thank You: lousyfool

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon