IotaIslandID in MySQL too short
Posted: 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
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