Sorry I should have put this in the first time. Rushing...

Here is the output from running cgrlog with debug=1

Cqrlog Ver:2.3.0 (101) Date:2018-06-19
**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/wtj1/
Program home directory: /home/wtj1/.config/cqrlog/
Data directory: /home/wtj1/.config/cqrlog/database/
Memebers directory: /home/wtj1/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/wtj1/.config/cqrlog/database/mysql.cnf --datadir=/home/wtj1/.config/cqrlog/database/ --socket=/home/wtj1/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:2
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

use cqrlog003

use cqrlog003

use cqrlog003

use cqrlog003

use cqrlog003

SELECT * FROM cqrlog_config

select * from db_version

[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 1 -r -t 4532
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1

1
2
3
4
5
6

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1

rotctld started!
Connected to localhost:4533
FreqmemSql:select id,freq,mode,bandwidth from freqmem order by id

FreqmemFirst:0 FreqmemLast:0
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = 1

select locator from profiles where nr = 1

select locator from profiles where nr = 1

1-FN21CI;Duryea PA;
select * from view_cqrlog_main_by_qsodate where qsodate >= '2018-07-07' order by qsodate,time_on

LoadForm: frmNewQSO
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in ())) as foo

TApplication.HandleException TMySQL57Connection : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))) as foo' at line 1
Stack trace:
$0000000000918EAF
$000000000091A598
$000000000044AB66
$0000000000431F6F
$0000000000656B2D
$000000000044CD42
$0000000000662958
$0000000000654561
$0000000000654491
$0000000000450849
$0000000000652867
$000000000066D91C
$000000000066A37E
$000000000044A5BB
$000000000044F71C
$00000000004F64FE
$00000000006B006A
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: cqrlog.cfg
Deleting config file: 3cqrlog.cfg
Closing dData
/home/wtj1/.config/cqrlog/database/epasec.pid
Command:
kill 2049
WARNING: TMenuItem.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?

mysql.err log attached.

After reading all the posts and trying to figure out where things were going I did my own experiment.

Rather straight forward. Moved the cqrlog config directory out of the way.

Used Synaptic to remove CQRLOG and then install it again. Just to get a clean starting point after all that file moving and downloading.

Recreated my logfile, DID NOT ACCEPT THE QSLMGR & DXCC UPDATE, recreated my preferences, imported my ADIF backup, and all is well. Now I just have to import the FT8 entries that I made while waiting to see what greater minds than mine came up with as a root cause.

Many thanks to the CQRLOG guys for all the hard work. Sincerely appreciate everything.

73
WT
WN3LIF

Rob,

I saw that missing date too. I put a date in but it didn't solve the issue. So I just decided that up and running was better for me than trying to debug the problem.

I'll let the CQRLOG guys do that.

73!
WT
WN3LIF