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?