1.0.2 : Rebuilding membership statistic -> SQL error

5 posts / 0 new
Last post
dl5ybz
1.0.2 : Rebuilding membership statistic -> SQL error

Hi Petr and Martin,

just decided to switch from 0.9.6 to 1.0.2 running debian SID.. works without any big problems up to now for me. Really like the idea to share a database on a server on demand ;) I'm Running the local datastore variant / i386 tar package.

I installed the Membership Lists of 'Activity Grupp CW (AGCW)' and 'World Flora Fauna' using the default time frame ( 1945-01-01)

Testing QSO view -> Statictics -> Rebuilding membership statistic

in order to build up the AGCW statistic I got an Error message:

>>>
: 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 '= c.
and c.fromdate <= q.qsodate and c.todate >= q.qsodate
set q.club_nr1 = c.c' at line 1
<<<<

Aside the Error the program keeps stable and usable, only the requested action fails.

73 de Olaf / DL5YBZ

ok2cqr
ok2cqr's picture
Re: 1.0.2 : Rebuilding membership statistic -> SQL error

Hi Olaf,

could you please run cqrlog from console and send me SQL statement which cqrlog writes into console before this error appears? I remember that Martin has the same problem and we solved it very quickly in preferences but I don't remember what it was. Thank you!

73 Petr, OK2CQR

dl5ybz
Hi Petr, this is the complete

Hi Petr,

this is the complete 'bad' SQL from the console:

>>
update cqrlog_main q left join club1 c on q.= c.
and c.fromdate <= q.qsodate and c.todate >= q.qsodate
set q.club_nr1 = c.club_nr
where qsodate >= '1945-01-01'

<<

Good luck ;)

Olaf

ok2cqr
ok2cqr's picture
Re: Hi Petr, this is the complete

Hi Olaf,

maybe I know where is the problem.
Open Preferences -> choose Membership tab, click to Settings which belongs to your club. "Club settings" window appears. In the right part of window are two combo boxes. One is "Join" and the second is "with". I thing you have "with" combobox empty. Please choose "call" value and it should work as expected. "call" value should be default. It is a bug. I'll fix it. Thank you.

73 Petr, OK2CQR

dl5ybz
No bug.. user Error :) ..Update!

Hi Petr,

you located the source of problem correct... but I have no 'blank' entry for the 'field in main datbase (lol..yes there is typo in the programm.. databse instead of database ... so next to check :) but the suggested 'call'.

But the problem was the 'field in club database' default... it was 'clubcall' and that semas s not work for the AGCW list...

Selecting 'club_nr' instead fixes the problem for me... on the first view.. the sql statement works now,... but I got no Call joined by the AGCW numer as I expected.. also no filter works...

So I get a little bit puzzeled and checked the 'club1' table.. ( my AGCW List..) well.. the club_call should be the right field...

So I switched back to 'club_call' and .. now it was working as expected... sight..

So not a blank entry seems to be the problem but the 'take over' from the drop down list...

73 de Olaf