Advertisement:

Author Topic: [Solved] Adding a NEW Country error  (Read 905 times)

Aficionado

  • Guest
[Solved] Adding a NEW Country error
« on: September 09, 2016, 04:34:33 pm »
Trying to add a new country after 28 countries, gives me:

 already was in the database


Whatever i write after 28 countries tells me the same.

Is there a limit ?

Thanks
« Last Edit: September 09, 2016, 06:13:04 pm by Aficionado »

Aficionado

  • Guest
Re: Adding a NEW Country error
« Reply #1 on: September 09, 2016, 05:16:49 pm »
It appears that there is no limit but some other problem.

If you try to add a country with no Country letters (GB for example) all kind of strange things happen.

For me, i was trying to add GB-ENG (England), GB-NIR (North Ireland), GB-SCT (Scotland) and GB-WLS (Wales).

For some reason that gives an Already Exists error.

Not sure how to solve this.

teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: Adding a NEW Country error
« Reply #2 on: September 09, 2016, 06:01:23 pm »
Hi,

Quote
CREATE TABLE /*TABLE_PREFIX*/t_country (
    pk_c_code CHAR(2) NOT NULL,

Two characters maximum, you'll need to put there EN, NI...

Regards

Aficionado

  • Guest
Re: Adding a NEW Country error
« Reply #3 on: September 09, 2016, 06:12:22 pm »
Thanks Teseo.

Seems to works, but i had to put random letters ...


teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: [Solved] Adding a NEW Country error
« Reply #4 on: September 09, 2016, 08:55:14 pm »
I guess some of your new codes were already taken by other countries...

You're welcome. :) Regards

Aficionado

  • Guest
Re: [Solved] Adding a NEW Country error
« Reply #5 on: September 09, 2016, 09:17:49 pm »
I guess some of your new codes were already taken by other countries...

You're welcome. :) Regards

Actually after i added GB-ENG, abd tried to add GB-SCT apparently the GB part was already added so .....