If I select the QSO-list I get the following error{1]
If I select "DXCC Statistics", I get[2]
I don't know, if its the same bug, but this messages appeared at the same time this evening.
With an older backup of my mysql database, everything is fine.
I am working with cqrlog 1.8.1 i386 on debian testing.
 
Thanks for your good work, let me know if I can help you out with debugigng information on this issue!
73, Bernhard DL8BH
 
 
 
[1]
select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in ())) as foo TApplication.HandleException  : 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:  $083D7555  $08412B2F  $08413E5A  $084097B3  $0840A02E  $083D9A82  $08409205  $080AA5D6  $080B03A1  $08081E0E  $08081132  $0806D3F6  $082AA69F  $08082B7A  $082B6088  $082A834C  $082A82AF
 
 
[2]
select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif <> 0 and ((mode='SSB') or (mode = 'AM') or (mode='FM')) and (dxcc_id.dxcc_ref not like '%*')) as fooselect count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE  cqrlog_main.adif <> 0 and lotw_qslr = 'L' and (dxcc_id.dxcc_ref not like '%*') and ((mode='SSB') or (mode = 'AM') or (mode='FM'))) as fooselect count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif <> 0 and  ((mode='CW') or (mode = 'CWR')) and (dxcc_id.dxcc_ref not like '%*')) as fooselect count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif <> 0 and  lotw_qslr = 'L' and (dxcc_id.dxcc_ref not like '%*') and ((mode='CW') or (mode = 'CWR'))) as fooselect count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif <> 0 and  (mode<>'CW') and (mode <> 'CWR')and (mode<>'SSB') and (mode<>'FM') and (mode<>'AM') and (dxcc_id.dxcc_ref not like '%*')) as fooselect count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif <> 0 and  lotw_qslr = 'L' and (mode<>'CW') and (mode <> 'CWR')and (mode<>'SSB') and (mode<>'FM') and (mode<>'AM') and (dxcc_id.dxcc_ref not like '%*')) as fooTApplication.HandleException Transaction already active  Stack trace:  $083D73D8  $081097F8  $08117AEA  $082B836E  $082DE37F  $082DEAD6  $082DF131  $082DE2AA  $0806D3F6  $082AA69F  $083686CB  $0837504D  $B6FC5729