Country file import problem

3 posts / 0 new
Last post
K6BSD
Country file import problem

The country files shipped with 1.8.2 contain longitudes 11 characters long for JD1(M) and JD1(O).  Since the longit column in cqrlog_common.dxcc_ref is a varchar(10), this results in an import error which prevents the deleted entities from being imported.  In turn, this results in illegal SQL queries when populating the QSO list.
 
I worked around it on my system by changing the column to varchar(12), opening the QSO list (ignoring the error), and re-importing the country files with File->Import->DXCC data.  After this, CQRLOG works perfectly again.

ok1rr
ok1rr's picture
Country file import problem

Modified country.tab to meet the criteria. The difference is not very important, it means tens of meters!

K6BSD
Country file import problem

That was my initial solution as well, but there were other files with the same values and I wasn't certain that just the one file was enough.
 
Thanks for the quick solution!

73 de K6BSD/VE5BSD