<Solved> Membership tracking problem

14 posts / 0 new
Last post
ei6kw
ei6kw's picture
<Solved> Membership tracking problem

I added third club to tracking membership and got strange effect.
As always I set Award field to be filled with club name in Preferences... but if I go to qso list window and next to 'Statistics->Membership tracking->Rebuild membership statistics' then award field for several qso is filled but for the call signs which even are not in my /.config/cqrlog/members txt file.
If I am trying to do this with the same qsos but manually by edit qso or if I simulate live qso its never happens and working fine only with call signs which are in txt file.

I am tried to do this few times and it always happens for exactly the same qsos.

BTW how to remove tracking clubs from 'Preferences->Membership' ?

Thanks,
Slav, EI6KW

oh1kh
Membership tracking problem

Hi!

I shouldn't answer this because I do not use any clubs.
If I understood ok adding a qso sets always club as it should, but membership rebuild finds calls that are not members of any selected club.

I suggest that you next check club databases with SQL console:
select * from club1;
Same command for all clubs from 1 to 5, just change the number.
I assume contents are equal with club txt files (because qso enter works ok). Are they?

Then start cqrlog with debug to file
cqrlog debug=1 > /tmp/debug.txt

Do membership recreation and close cqrlog.. Then study /tmp/debug.txt
I looked source a bit and it seems to debug write every rebuild operation's sql command. I do not know what it looks like but it is the only way to seek some glue what happens.

If you do backup copy ~/.config/cqrlog before start (and you have log data in local machine) you can return back by restoring the old copy.
What is interesting is: What happens if you do recreation again after restoring directory (close cqrlog whlie restoring). Does new rebuild same erros or are fake joins random?

--
Saku
OH1KH

ei6kw
ei6kw's picture
Membership tracking problem

Thanks Saku,

If I understood ok adding a qso sets always club as it should, but membership rebuild finds calls that are not members of any selected club.

That's right, but it happens only for club3 and always for the same qsos. Clubs 1 and 2 working as it should.

I suggest that you next check club databases with SQL console:
select * from club1;
Same command for all clubs from 1 to 5, just change the number.
I assume contents are equal with club txt files (because qso enter works ok). Are they?

Checked and they are. What I got after is equal to club txt file.

Then start cqrlog with debug to file
cqrlog debug=1 > /tmp/debug.txt

Please find attached file.

What is interesting is: What happens if you do recreation again after restoring directory (close cqrlog whlie restoring). Does new rebuild same erros or are fake joins random?

Same errors after. I also create new database and import adif file to it with the same effect and same errors after rebuilding club membership for club3.

Slav, EI6KW

File: 

73!
Slav, EI6KW

ei6kw
ei6kw's picture
Just to save our time. I

Just to save our time. I install fresh cqrlog and it changed case in this way that now all clubs tracking working fine except of Thracian Rose Club (TRC) and it is same club from my initial post. I checked 4 other clubs and all worked without any problems. I thought that I have faulty trc.txt file but it doesn't matter if I take trc.txt file from cqrlog page or I made my own - it's not working at all.

Slav, EI6KW

73!
Slav, EI6KW

oh1kh
Membership tracking problem

Yep!

Bug 1)
"comm: for qso" selection is faulty. When chaged to "award" there is no error anymore.
It must be fiixed by stripping dot and spaces.

Bug 2)
if I make rebuild for HSC (award field) every qso in log gets mark HSC.
Same if I do rebuild for both HSC and TRC

if I make rebuild for TRC (award field) every qso in log gets mark TRC.

How ever there are only two calls from HSC list and two calls from TRC list added to this test log that has total 10 qsos.

Does this fit with your findings?

--
Saku
OH1KH

oh1kh
Membership tracking problem

Bug 1) fixed

I have messed it up a long ago when I changed terms "remarks" to "comment to qso" in several places to make similar outlook everywhere.
I did not know that this selector in club settings must have same name as cqrlog_main database field "remarks" that shows up at NewQSO with label "Comment for qso" (which is confusing)

Work continues...

--
Saku
OH1KH

oh1kh
Membership tracking problem

Hi Slav!

Please check the trc.txt file you have done with hex editor.
Does it have LFs or CRLFs at the end of lines (0x0A or 0x0D 0x0A).

I installed HSC and TRC clubs and direct qso enter works ok.
When I run rebuild I get error (see pic). It looks like the "comm. for QSO" would not be ok as it has spaces between.
I have to check further...

File: 

--
Saku
OH1KH

ei6kw
ei6kw's picture
Membership tracking problem

Please check the trc.txt file you have done with hex editor.
Does it have LFs or CRLFs at the end of lines (0x0A or 0x0D 0x0A).

Checked and there is not any CRLFs but only LFs (0A in hex and one dot on asci side). But 0A is in every *.txt file which is working with membership's tracking.

I also changed filed to store club info for qso comment instead of award field but then I got:

TMySQL57Connection : 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 'for QSO='TRC'
where qsodate >= '1945-01-01'
and comm. for QSO=''' at line 3

BTW membership tracking still working fine if I edit qso or with new qso.

73!
Slav, EI6KW

oh1kh
Membership tracking problem

Yep!

"comm. for QSO=''' at line 3" is just bug what I have already found and fixed (msg #6). Until the bugfix is merged to source "comm. for QSO" should not be used in Club settings.

Membership tracking is working fine if editing qso or with new qso. That is confirmed also here.
But membership recreation via Qso list/statistics set every qso marked as club member if selected fields (I used "award" for testing) are empty in all qsos before running recreation.

This seems to be problem with the SQL sentence that should handle the job.

I start to study that part as next job.

--
Saku
OH1KH

oh1kh
Membership tracking problem

Hi Slav!

Can you compile from source?
I have now pushed up a fix to my GitHub branch "member_rebuild"

If you can't I could send you a link to ready compiled binary for testing.
It would be interesting to know does it now work.

I have tested it now with log of 10 qsos having 2 qsos both HSC and TRC and used group edit to clear all previous markings before new run.
Would be interesting to see results from bigger log.

--
Saku
OH1KH

ei6kw
ei6kw's picture
Membership tracking problem

Thanks Saku,

I can compile tomorrow morning, wil let you know effects. Some of 6k qsos in log so will be good test.

73!
Slav, EI6KW

ei6kw
ei6kw's picture
Membership tracking problem

Hi Saku,
Compiled from your github and it's working now! Checked few times with 4 clubs and working. Thanks a million, Saku!

But... ;)
Now after every start cqrlog inform me that new DXCC tables are available and asking me if I want to download it.

73!
Slav, EI6KW

oh1kh
Membership tracking problem

HI Slav !

Fine. Then I can make pull request for that.
Do not worry DXCC. I did PM to Martin, OK1RR, and he fixed the broken update. Should be OK now.

--
Saku
OH1KH

ei6kw
ei6kw's picture
Hi Saku,

Hi Saku,
Thats fine, thanks again

73!
Slav, EI6KW