Greetings,

Due to a SNAFU on my part I managed to hork my radio box (Ubuntu 16.04.4) with a messed up kernel upgrade/downgrade and secure booting EFI (yuck). Anyways, backups and all that made it just a couple hours.

However, when reinstalling CQRLOG I had a hell of a time, throwing the dreaded SQL warning that I'm breaking things (even with 101 patch) and looking at the logs was confusing. Reinstalled MySQL, reinstalled CQRLOG, blew away DB, restored from ADIF, etc.

In any event, I discovered what I believe may be causing a lot of issues for me and maybe for others. There is a missing date in qslmgr.csv 0H0X; OH2TA; (Oscar Hotel Zero Xray) where it is missing the date and the load explodes. I put the date form the above entry in (2014-03-14 or some such) and it loaded and my CQRLOG loves life again. I'm assuming that some cleanup never happens since it blows out SQL at that point with a missing value and that is cascading into other issues.

73
Rob AG5OV

diff -u

--- qslmgr.csv 2018-07-13 19:18:39.461324199 -0500
+++ qslmgr.csv-orig 2018-07-13 19:18:27.069117983 -0500
@@ -9425,7 +9425,7 @@
OH0TA;OH2TA;2015-08
OH0V;OH6LI;2016-05
OH0W;OH2BH;2014-03
-OH0X;OH2TA;
+OH0X;OH2TA;2014-03
OH0Z;W0MM;2015-09
OH1/DL2VFR;DL2VFR;2018-05
OH1/DL2YBG;DL2YBG;2018-05