Hi, since I first entered text in "Comment to QSO" for a qso, this comment is systematically entered in all new qso while the space for "Comment to QSO" is empty. However, the box fills with the text very quickly when I record a new qso. It's quite annoying to have to edit all new qso before sending them to the logging sites.
I suppose that this comment must be saved in the database, but I do not how to connect with the mysql command, nor with phpmyadmin. I tried to import the database with phpmyadmin but there are many errors.
73'
Cqrlog Ver:Alpha_(136)_Gtk2 Build:1 Date:2025-05-01
Hi!
Perhaps it is a bug.
I have to check this when I have next "programming time".
meanwhile...
Do filter of your qsos with wrong comment (maybe based on date?, or comment text?)
Then use Qso list/File/Group edit and select Comment to qso and leave text clear then press apply.
Check that it had effect.
NOTE: There is no "OOOPS" button. Do backup of your log first. It is very easy to clean all comments from whole log.
--
Saku
OH1KH
Hi!
I can not see that happen here.
Could it be some kind of Desktop autofill property doing that?
If I fill "Comment to qso" with text and save qso it appears in "remarks" column of Qso list.
When I save next qso without filling "Comment to qso" and save "remarks" stay empty.
Fedora 41 with LXDE desktop
--
Saku
OH1KH
Do you use program like this?
https://keepass.info/index.html
Then check it's settings.
--
Saku
OH1KH
Thanks,
I use cqrlog with wsjtx-improved. Perhaps I should look that way. When I open the ADI log from wsjtx, there is this stray comment. I suppose that cqrlog don't modify the wsjtx adi logs. But I don't understand how and where cqrlog is going to look this comment.
I have too keepass, but it is closed the most of time.
Can you tell me how to use sql commands to find cqrlog database ?
cqrlog --debug=1 :
/usr/bin/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/fab2/.config/cqrlog/database/mysql.cnf
--datadir=/home/fab2/.config/cqrlog/database/
--socket=/home/fab2/.config/cqrlog/database/sock
--port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog001
If I use this in terminal, with sudo mysql, use cqrlog001 --> MariaDB [(none)]> use cqrlog001;
ERROR 1049 (42000): Unknown database 'cqrlog001'
If you use "save log data to local machine" checked then you can to connect mysql via "Qso list/Filter/SQL console"
Or from command terminal giving command:
mysql -S /home/fab2/.config/cqrlog/database/sock
127.0.0.1 address with port 64000 should also work:
mysql -h 127.0.0.1 -P 64000
But in both cases your Cqrlog must be running while you connect to database. The sock file exist only when Cqrlog is active and also the mysql server is also running only during that time.
There is no username/password for that extra mysql server and the access is "wide open" also from local network.
As you have MariaDB installed you have also mysql server running all the time at 127.0.0.1 port 3306 but Cqrlog does use that if your "save log data to local machine" is checked.
Of course you can do mysqldump from the sock running mysql server and drop the dump to server at 3306 and make username and password for using databases from there. Then uncheck "save log data to local machine" and put required information to Cqrlog's Database connection window.
All Cqrlog databases begin with cqr% you need to dump.
--
Saku
OH1KH
Hi!
Ok that explains. You have same setup as I do; WSJTX-Improved with Cqrlog.
If you fill comment, propagation or contest exchange at WSJT-X login window and then click OK having Cqrlog's WSJT remote active you get the qso logged with those additional information.
See the "Retain" check boxes at WSJT-X log window. If checked you selected propagation or written comment will be there for all logged WSJTX-qsos as long as check boxes are checked.
--
Saku
OH1KH