ITU zones statistics problem

3 posts / 0 new
Last post
OH4NDU
ITU zones statistics problem

Hello!

Every time i try to open ITU zones statistics window, i get tho following error message: Index Out of range Cell[Col=6 Row=80].
Screenshot of the error message is here: https://www.dropbox.com/s/2gyc3y6n3k5tfhv/cqrlog_error.jpg?dl=0
Also the "Details" window shows a notification "QSL needed for WAZ!" and "QSL needed for ITU!" for every contact i have.
And if i ignore the error message and click "OK", the statistics table show but the rows from 79 to 89 are missing. So the last row in the window in number 90, and second last row is 78.
The debug log is below.
Any ideas how to fix this?

73, de Jallu, OH4NDU

(cqrlog:72427): Gtk-WARNING **: 21:54:35.950: Unable to locate theme engine in module_path: "pixmap",

(cqrlog:72427): Gtk-WARNING **: 21:54:35.951: Unable to locate theme engine in module_path: "pixmap",

(cqrlog:72427): Gtk-WARNING **: 21:54:35.951: Unable to locate theme engine in module_path: "pixmap",

(cqrlog:72427): Gtk-WARNING **: 21:54:35.952: Unable to locate theme engine in module_path: "pixmap",

(cqrlog:72427): Gtk-WARNING **: 21:54:35.952: Unable to locate theme engine in module_path: "pixmap",

Cqrlog Ver:2.5.2 (001) Date:2021-02-12

**** DEBUG LEVEL 2 ****

OS:

Linux version 5.4.0-81-generic (buildd@lgw01-amd64-052) (gcc version 9.3.0 (Ubuntu 9.3.0-17ubuntu1~20.04)) #91-Ubuntu SMP Thu Jul 15 19:09:17 UTC 2021

SSL libraries:

   libssl.so

   libcrypto.so

Loaded 160730 LoTW users

Loaded 144992 eQSL users

Loaded 34784 SCP calls

*

User home directory:    /home/<user>/

Program home directory: /home/<user>/.config/cqrlog/

Data directory:         /home/<user>/.config/cqrlog/database/

Memebers directory:     /home/<user>/.config/cqrlog/members/

ZIP code directory:     /usr/share/cqrlog/zipcodes/

Binary dir:             /usr/bin/

Share dir:              /usr/share/cqrlog/

*

56 us states loaded

Grid map created

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: 18  cDB_MAIN_VER: 18

select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.bands 

Settings:

-----------------------------------------------------

RigCtldPath:/usr/bin/rigctld

RigCtldArgs:-m 1 -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:-m 1 -t 4533  

RunRotCtld: FALSE

RotDevice:  

RotCtldPort:4533

RotCtldHost:localhost

RotPoll:    500

RotId:      1

Not started rotctld process. (Run is set FALSE)

Connected to rotctld @ localhost:4533

FreqmemSql:select id,freq,mode,bandwidth,info from freqmem order by id

FreqmemNR:0=0

FreqmemFirst:0  FreqmemLast:0

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 (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo 

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 (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo

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

WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TStringGrid

select itu,band,qsl_r,lotw_qslr,eqsl_qsl_rcvd from cqrlog_main  group by itu,band,qsl_r,lotw_qslr,eqsl_qsl_rcvd having (itu > 0) and (itu < 91) order by itu

SaveForm: frmWAZITUStat

Section:frmWAZITUStat

Saving window size a position (frmWAZITUStat) (height|width|top|left):587|668|1107|20

Closing rigs... 

Closing Details window

Section:frmQSODetails

Saving window size a position (frmQSODetails) (height|width|top|left):198|1109|1234|13

SaveForm: frmMain

Section:frmMain

Saving window size a position (frmMain) (height|width|top|left):669|986|2377|103

Closing QSO list window

Section:frmNewQSO

Saving window size a position (frmNewQSO) (height|width|top|left):728|1032|1547|45

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

End dmDXCC

Complete end dmDXCC

Closing dDXCC

Deleting config file: 1cqrlog.cfg

Deleting config file: cqrlog.cfg

Closing dData

oh1kh
ITU zones statistics problem

Moi Jallu!

The details window does not count eQSL and LoTW as confirmed (perhaps needs fix there...) If you edit old qso and put QSL-R to Q deltails will tell about confirmed ITU and WAZ nex time you enter a new qso from that country and same band.

Having problem at row 80 sounds weird. There are not so many rows in ITU grid.
Caption := 'ITU statistic';
grdStat.Cells[0,0] := 'ITU';
grdStat.RowCount := 78;
for i:=1 to 75 do
grdStat.Cells[0,i] := IntToStr(i);
grdStat.Cells[0,76] := '78';
grdStat.Cells[0,77] := '90';

First row is 0 and that holds header texts.
Then there is loop from row 1 to row 75. That corresponds ITU numbers in order.
Rows 76 and 77 are labelled outside of the loop as ITU numbers skip from 75 to 78 and from 78 to 90

That makes total of 78 rows.

Unfortunately there are no debug lines in this process to see what happens. And as it works for me I cannot catch the problem here.
Can you do full adif export, create a new log and import all qsos from adif and check does ITU statistic fail in same way?

If it does, then you can send your adif file for me for further checking.
If new log works ok, then there is a problem in your current logs database.

Check also if you have created user defined digital modes in preferences/modes are they ok (no spaces and other characters than A-Z 0-9 with comma separated).
How may bands you have checked in preferences/bands? That affects to column count of ITU grid

--
Saku
OH1KH

oh1kh
ITU zones statistics problem

I have opened an issue relating to this: https://github.com/ok2cqr/cqrlog/issues/433

--
Saku
OH1KH