IotaIslandID in MySQL too short

Yes, sometimes it happens... Please report any bugs here
Locked
OE6CLD
Log4OM Alpha Team
Posts: 207
Joined: 04 Jun 2013, 08:54
Location: Nuremberg
Contact:

IotaIslandID in MySQL too short

Post 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
Claus, OE6CLD/DJ0DX/EI7JZ
User avatar
IW3HMH
Site Admin
Posts: 2926
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: IotaIslandID in MySQL too short

Post 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
Daniele Pistollato - IW3HMH
OE6CLD
Log4OM Alpha Team
Posts: 207
Joined: 04 Jun 2013, 08:54
Location: Nuremberg
Contact:

Re: IotaIslandID in MySQL too short

Post by OE6CLD »

Thanks Daniele;

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

73,
Claus, EI7JZ/OE6CLD
Claus, OE6CLD/DJ0DX/EI7JZ
User avatar
IW3HMH
Site Admin
Posts: 2926
Joined: 21 Jan 2013, 14:20
Location: Quarto d'Altino - Venezia (ITA)
Contact:

Re: IotaIslandID in MySQL too short

Post by IW3HMH »

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