[Solved] Adding a NEW Country error

[Aficionado]

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

[Aficionado]

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]

Hi,

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]

Thanks Teseo.

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

[teseo]

I guess some of your new codes were already taken by other countries...

You're welcome. Regards

[Aficionado]

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 .....