Good Day!

Thanks for such awesome Linux software. I am having my first major issue after many years of use and am requesting your assistance to get my DB back in use. When I go to the QSO List window, I get the following error message:

"TMySQL57Connection : 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."

I am currently on Linux Mint 19, CQRLOG 2.3.0, and MySQL 5.7.22-0ubuntu18.04.1

Just of a sudden, CQRLOG gives this message when I open the QSO list:

TMySQL57Connection : 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.

Press OK to ignore and risk data corruption
Press Abort to kill the program.

I started cqrlog in the console woth --debug=1 and get the attached log.

I am running Kubuntu 18.04 and I'm not aware of any changes.

Hi,

Could/would you add some new modes to the preference-band-frequencies tab? With the newer digital mode, like FT8, it seems impossible for the DX Cluster and DXCC statistics to properly recognize when you have worked an entity on a given band using a digital mode other than RTTY. For example, I have worked an entity on a given band using FT8, but the program sees that segment of the band as RTTY and any spot in DX Cluster on the normal FT8 segment of the band gets flagged as unworked/needed. Seems like FT8 would fall in the DIGI mode, but it doesn't seem to do that.

Hello all,

As a great fan of linuxmint , i jumped on the LM19 train quick.....
I did a fresh install of LM19 on my main HAM pc, and after all the normal stuff I usually install, I installed CQRlog.
I used the install instructions on this site, adding the repository, updating and then installing CQRlog.

And i am happy to report that at least the basic functions seem to work out of the box :)
(will test some more, but i do not see anything going wrong, most software versions used, are the same as in LM18.3)

regards,
Alex
PA1SBM

How does one go about changing the lotw_qsls field? I edited a QSO and all I changed was the signal report and the lotw_qsls changed from Y to blank.

73

Stan
KM4HQE

Hi All,

I worked KH1/KH7Z earlier on 20 meters FT8 and noticed when WSJT prompted me to log the QSO, the QSO was logged in CQRLog. I "thought" CQRLog had to be in remote mode in order for the WSJT QSO to be automatically logged? KH1/KH7Z calls CQ so seldom, I didn't bother with remote mode.

73

Stan
KM4HQE

Hi, is there a way that I can program where the CQ Monitor goes to get data for stations?, I've noticed that CQ Monitor is displaying certain stations as located in a particular state in the US and when the qso is made I see that they are in a different location. As soon as I begin the qso, in the New Qso Window the correct information is displayed and often differs from what is shown in Cq Monitor.

Can I direct CqMonitor to look into QRZ.com for example?

73

Santiago
HI8SMX

Need help. Here are the facts:

- I have a Raspberry 3 Pi
- Running Linux in ARM
- I have CQRlog 2.2
- ssl-lib dev is up to date, I have the latest version
- If I export the log to a file I can perfectly sign and upload it thru Tqsl
- I can perfectly download the report from Lotw and import it in Cqrlog

But, I'm having problems uploading and downloading to LOTW.

When I try to upload to Lotw I get:

Error: -2

And when I try to download from Lotw I get:

Not Logged
Error: -2
Error:
Error: ssl_openssl

system Linux Mint 18.3 cinnamon 64-bit
cinnamon 3.6.6
4.13.0-45-generic

All was ok before I update to cqrlog-2.3.0. Now the log shows the qso done before but when I want to log a new qso these messages appear :

"Database upgrade crashed with this error:
TMySQL57Connection : Error executing query: Duplicate column name 'rxfreq'

TMySQL57Connection : Error executing query: Unknown column 'prop_mode' in 'field list'. "

And when I want to close the program there is this message :

"Q : Field not found : "RxFreq".

I get the following error when I try to launch:

Error during connection to database: TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (5.7).

I fixed it by removing libmysqlclient-dev. Cqrlog now starts & works fine (2.3).

Synaptic wont't let me remove it because Cqrlog depends on it. I went to the terminal and ran the following command:
sudo apt-get install libmariadbclient-dev-compat

It executed with some errors but removed libmysqlclient-dev.

I am running on Raspberry Pi 3+
I am having trouble with downloading and uploading to LOTW.

LOTW software is already installed and works fine directly.

I tried a filter to see what I could come up with on the DXCC entities I've worked and sent a QSL to but haven't received one back. With the goal being to re-work the ones I need in order to get closer to making Challenge.

What column/field in cqrlog_main is dxcc_ref? I tried this from the SQL console and it fails since there is no column/field named dxcc_ref

select qsodate,time_on,callsign,band, dxcc_ref, lotw_qsls, lotw_qslr from cqrlog_main where lotw_qslr=""