Page 1 of 1

IotaIslandID in MySQL too short

Posted: 21 Apr 2014, 16:01
by OE6CLD
Hi all,

I found an issue when I tried to import my complete log back into MySQL.

I had two QSOs with IA0MZ which had the following entries in the ADIF:

<IOTA:6>AN-016 <IOTA_ISLAND_ID:64>Antarctica Main island and islands not counting for other groups

In MySQL the field only is 50 chars long:

`IotaIslandId` VARCHAR(50) NULL DEFAULT NULL

so you will get an error when importing and the QSO will not be added. This works fine with SQLite.

Thanks,
Claus, EI7JZ/OE6CLD

Re: IotaIslandID in MySQL too short

Posted: 21 Apr 2014, 21:09
by IW3HMH
Thank you Claus for reporting,
you can enlarge mySql field if you're able to do.
If not i will fix the file in next release and provide asap a script to make the change

73
Daniele

Re: IotaIslandID in MySQL too short

Posted: 22 Apr 2014, 13:39
by OE6CLD
Thanks Daniele;

I already have changed this is my environment, just wanted to let you know.

73,
Claus, EI7JZ/OE6CLD

Re: IotaIslandID in MySQL too short

Posted: 22 Apr 2014, 13:47
by IW3HMH
Fixed in data structure, ready for next release.
Thanks for reporting the issue