Cqrlog Ver:2.3.0 (001) Date:2018-06-17 **** DEBUG LEVEL 1 **** SSL libraries: /usr/lib64/libssl.so.1.0.2o /usr/lib64/libcrypto.so.1.0.2o Loading libmariadbclient: ************************** MySQL version: 10. ************************** ********************************** MySQL version assigned: 5.6 ********************************** Loaded 118377 LoTW users Loaded 115544 eQSL users Loaded 40133 SCP calls * User home directory: /home/chris/ Program home directory: /home/chris/.config/cqrlog/ Data directory: /home/chris/.config/cqrlog/database/ Memebers directory: /home/chris/.config/cqrlog/members/ ZIP code directory: /usr/share/cqrlog/zipcodes/ Binary dir: /usr/bin/ Share dir: /usr/share/cqrlog/ TConnection to MySQL: 5.6 * 56 us states loaded /usr/bin/mysqld_safe --defaults-file=/home/chris/.config/cqrlog/database/mysql.cnf --datadir=/home/chris/.config/cqrlog/database/ --socket=/home/chris/.config/cqrlog/database/sock --port=64000 Trying to connect to dat180713 13:46:21 mysqld_safe Logging to '/home/chris/.config/cqrlog/database//mysql.err'. 180713 13:46:21 mysqld_safe Starting mysqld daemon with databases from /home/chris/.config/cqrlog/database/ abase TMySQL56Connection : Server connect failed. Trying:1 select * from tables where table_schema = 'cqrlog_common' SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr use cqrlog001 use cqrlog001 use cqrlog001 use cqrlog001 use cqrlog001 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 2 -r -t 4532 RunRigCtld: FALSE RigDevice: RigCtldPort:4532 RigCtldHost:localhost RigPoll: 500 RigSendCWR: FALSE RigId: 2 rigctld started! Connected to localhost:4532 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 Sending: fmv CW init select upper(left(loc,4)) as lo from cqrlog_main where loc<>'' and eqsl_qsl_rcvd<>'E' and lotw_qslr<>'L' and qsl_r<>'Q' select upper(left(loc,4)) as lo from cqrlog_main where loc<>'' and (eqsl_qsl_rcvd='E' or lotw_qslr='L' or qsl_r='Q') select count(distinct upper(left(loc,2))) as main,count(distinct upper(left(loc,4))) as sub from cqrlog_main where loc<>'' select count(callsign) as qso from cqrlog_main where callsign<>''union all select count(callsign) from cqrlog_main where callsign<>'' 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 Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv WkdGrids-TimerTick. FlwRig stage0 is:TRUE FlwRig stage 1 is:TRUE FlwRig getmode returns(st-m-b):FALSE Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv 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 TMySQL56Connection : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))) as foo' at line 1 Stack trace: $00000000009151EF $00000000009168D8 $000000000044CF76 $0000000000431F7F $0000000000658C5D $000000000044F152 $0000000000664A88 $0000000000656691 $00000000006565C1 $0000000000452C59 $0000000000654997 $000000000066FA4C $000000000066C4AE $000000000044C9CB $0000000000451B2C $00000000004F86EE $00000000004F790D Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv WkdGrids-TimerTick. FlwRig stage0 is:TRUE FlwRig stage 1 is:TRUE FlwRig getmode returns(st-m-b):FALSE Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv NOTE: Window with stalled focus found!, faking focus-out event Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv WkdGrids-TimerTick. FlwRig stage0 is:TRUE FlwRig stage 1 is:TRUE FlwRig getmode returns(st-m-b):FALSE Sending: fmv Sending: fmv Sending: fmv SaveForm: frmMain Section:frmMain Saving window size a position (frmMain) (height|width|top|left):607|925|256|612 Closing QSO list window Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0 LoadForm: frmMain SELECT COUNT(*) FROM cqrlog_main TApplication.HandleException Transaction already active Stack trace: $00000000008C4440 $00000000008F0353 $000000000044CF76 $0000000000431F7F $0000000000658C5D $000000000044F152 $0000000000664A88 $0000000000656691 $00000000006565C1 $0000000000452C59 $0000000000654997 $000000000066FA4C $000000000066C4AE $000000000044C9CB $0000000000451B2C $00000000004F86EE $00000000004F790D Sending: fmv WkdGrids-TimerTick. FlwRig stage0 is:TRUE FlwRig stage 1 is:TRUE FlwRig getmode returns(st-m-b):FALSE Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv NOTE: Window with stalled focus found!, faking focus-out event Sending: fmv WkdGrids-TimerTick. FlwRig stage0 is:TRUE FlwRig stage 1 is:TRUE FlwRig getmode returns(st-m-b):FALSE Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv SaveForm: frmMain Section:frmMain Saving window size a position (frmMain) (height|width|top|left):607|925|256|612 Closing QSO list window Sending: fmv Sending: fmv Sending: fmv Sending: fmv Sending: fmv SELECT COUNT(*) FROM cqrlog_main select * from profiles order by nr SELECT * FROM view_cqrlog_main_by_qsodate WkdGrids-TimerTick. FlwRig stage0 is:TRUE OZ1GNN_2018-07-13_13-46-52.adi FlwRig stage 1 is:TRUE FlwRig getmode returns(st-m-b):FALSE Sending: fmv Sending: fmv Sending: fmv Command line: tar -cvzf OZ1GNN_2018-07-13_13-46-52.tar.gz OZ1GNN_2018-07-13_13-46-52.adi Closing rigs... 1 2 3 4 5 6 Closing Details window Section:frmQSODetails Saving window size a position (frmQSODetails) (height|width|top|left):210|382|653|6 Section:frmWorkedGrids Saving window size a position (frmWorkedGrids) (height|width|top|left):441|753|95|772 Section:frmLogUploadStatus Saving window size a position (frmLogUploadStatus) (height|width|top|left):295|450|27|20 Section:frmNewQSO Saving window size a position (frmNewQSO) (height|width|top|left):705|807|80|585 select count(*) from cqrlog001.cqrlog_config Saving ini file to database select count(*) from cqrlog001.cqrlog_config Saving ini file to database 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: 1cqrlog.cfg Closing dData /home/chris/.config/cqrlog/database/t520.pid Command: kill 15470