IotaIslandID in MySQL too short

Yes, sometimes it happens... Please report any bugs here
Post Reply
OE6CLD
Old Man
Posts: 140
Joined: 04 Jun 2013, 08:54
Location: Munich

IotaIslandID in MySQL too short

Post by OE6CLD » 21 Apr 2014, 16:01

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
Claus, EI7JZ/OE6CLD/DJ0DX

User avatar
IW3HMH
Site Admin
Posts: 2378
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: IotaIslandID in MySQL too short

Post by IW3HMH » 21 Apr 2014, 21:09

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
Daniele Pistollato - IW3HMH

OE6CLD
Old Man
Posts: 140
Joined: 04 Jun 2013, 08:54
Location: Munich

Re: IotaIslandID in MySQL too short

Post by OE6CLD » 22 Apr 2014, 13:39

Thanks Daniele;

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

73,
Claus, EI7JZ/OE6CLD
Claus, EI7JZ/OE6CLD/DJ0DX

User avatar
IW3HMH
Site Admin
Posts: 2378
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: IotaIslandID in MySQL too short

Post by IW3HMH » 22 Apr 2014, 13:47

Fixed in data structure, ready for next release.
Thanks for reporting the issue
Daniele Pistollato - IW3HMH

Post Reply