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
IotaIslandID in MySQL too short
IotaIslandID in MySQL too short
Claus, OE6CLD/DJ0DX/EI7JZ
- IW3HMH
- Site Admin
- Posts: 2926
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: IotaIslandID in MySQL too short
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
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
Re: IotaIslandID in MySQL too short
Thanks Daniele;
I already have changed this is my environment, just wanted to let you know.
73,
Claus, EI7JZ/OE6CLD
I already have changed this is my environment, just wanted to let you know.
73,
Claus, EI7JZ/OE6CLD
Claus, OE6CLD/DJ0DX/EI7JZ
- IW3HMH
- Site Admin
- Posts: 2926
- Joined: 21 Jan 2013, 14:20
- Location: Quarto d'Altino - Venezia (ITA)
- Contact:
Re: IotaIslandID in MySQL too short
Fixed in data structure, ready for next release.
Thanks for reporting the issue
Thanks for reporting the issue
Daniele Pistollato - IW3HMH