Osclass forums

Support forums => General help => 3.6.x => Topic started by: Aficionado on September 09, 2016, 04:34:33 pm

Title: [Solved] Adding a NEW Country error
Post by: Aficionado 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

Title: Re: Adding a NEW Country error
Post by: Aficionado 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.

Title: Re: Adding a NEW Country error
Post by: teseo 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

Title: Re: Adding a NEW Country error
Post by: Aficionado on September 09, 2016, 06:12:22 pm

Thanks Teseo.

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

Title: Re: [Solved] Adding a NEW Country error
Post by: teseo 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

Title: Re: [Solved] Adding a NEW Country error
Post by: Aficionado on September 09, 2016, 09:17:49 pm

Quote from: teseo 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

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