A question from a Linux-Newbie. I tried installing CQRLog under freshly-installed Ubuntu 17.10 using Synaptic Package Manager and Petr's repository.
It installed 2.0.5 (not the more recent 2.1) and has trouble finding and starting up a SQL database connection.
Was it a mistake trying this under 17.10 or is there a way to get this to work? I could back down to 17.04 if I need to.
Kevin, KW0KW
HI !
Lots of people have reported same things:
1. problems with Ubuntu and SQL.
2. Petr's repository giving 2.0.5 instead of 2.1.0.
Try to seek this forum with related search words for both problems.
I think Ubuntu needs some kind of library package to add. I'm Fedora user, so can't help further.
One, tested way to get running 2.1.0 with instructions found from this forum, is to remove old install from package and install manually from binary tgz files.
--
Saku
OH1KH
--
Saku
OH1KH
Thanks, Saku. I'll give that a try.
73,
Kevin, KW0KW
Kevin, did you add the ppa according to the instruction found here: https://www.cqrlog.com/download
OH2GBA
Yes, I did. I think I've slowly realized that the source of my problem is that the repository has not moved up to Ubuntu 17.10 yet. That will come in due time, I suppose.
Kevin, KW0KW
The packages for Artful Aarvark (17.10) are not in the repo, therefore you can't install them directly.
Err:6 http://ppa.launchpad.net/ok2cqr/ppa/ubuntu artful Release
404 Not Found
73 Mike K5TRI
I was able to install CQRLog on Kubuntu 17.10, but I ran into a couple of problems. When I tried to import the ADIF from Amateur Contact Log, it doesn't import all of my QSOs and it gives a bunch of errors. Like 95 errors or so. I looked for an ADIF error log file but I can't find one. The only error log file I see is a mysql error log file. How do I find out what QSOs weren't imported? Is there an easy way to delete all of the QSOs from the database and start over?
73
Stan
KM4HQE
Hi Stan!
First backup what you have.
Then if there are just imported qsos delete whole log and create new /NewQSO/File/Open or create new log.
If there are other qsos to save use NewQSO/Wndow/qso list/filter/sql console.
If imported qsos have date after "some day" or between dates finding them should be easy.
Typing this to sql console and pressing leftmost top green start button:
select * from cqrlog_main where qsodate > '2017-12-03' and qsodate < '2017-12-05'
Should give yesterdays qsos. Change dates to fit you purposes.
When you get list ok, change "select *" from start of line to "delete" and next pressing leftmost top green start button will remove those qsos.
Syntax you can find from here : https://dev.mysql.com/doc/refman/5.7/en/delete.html
--
Saku
OH1KH
--
Saku
OH1KH
Hi Stan!
First backup what you have.
Then if there are just imported qsos delete whole log and create new /NewQSO/File/Open or create new log.
If there are other qsos to save use NewQSO/Wndow/qso list/filter/sql console.
If imported qsos have date after "some day" or between dates finding them should be easy.
Typing this to sql console and pressing leftmost top green start button:
select * from cqrlog_main where qsodate > '2017-12-03' and qsodate < '2017-12-05'
Should give yesterdays qsos. Change dates to fit you purposes.
When you get list ok, change "select *" from start of line to "delete" and next pressing leftmost top green start button will remove those qsos.
Syntax you can find from here : https://dev.mysql.com/doc/refman/5.7/en/delete.html
--
Saku
OH1KH
--
Saku
OH1KH
Hi Saku,
I was able to delete the QSO's. I see where I goofed. 2.0.5 is the version I have installed. Looks like the errors are from digital modes that were added in version 2.1
So, I tried building it from source and get this error.
/home/stan/cqrlog-2.1.0/src/./richmemo/richmemortf.pas(492,8) Error: (5000) Identifier not found "UTF8Length"
500 207.764/212.640 Kb Used
600 207.776/212.640 Kb Used
700 207.850/212.640 Kb Used
800 207.946/212.896 Kb Used
richmemortf.pas(870) Fatal: (10026) There were 1 errors compiling module, stopping
Fatal: (1018) Compilation aborted
Error: /usr/bin/ppcx64 returned an error exitcode
Error: (lazarus) Compile Project, Target: cqrlog: stopped with exit code 256
Error: (lazbuild) failed compiling of project /home/stan/cqrlog-2.1.0/src/cqrlog.lpi
Makefile:9: recipe for target 'cqrlog' failed
make: *** [cqrlog] Error 2
stan@radio:~/cqrlog-2.1.0$
Stan
KM4HQE
Hi Stan,
download recent source code from GitHub. I already fixed the problem.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi Petr,
I downloaded cqrlog-master.zip from GitHub. It compiled fine. I still get a few errors when I import the ADIF file from Amateur Contact Log. It imports all but 8 QSOs. Is there an easy way to find out what 8 are missing?
73
Stan
KM4HQE
Hi Petr,
I found the ADIF error logs. I see what's wrong with 3 of the QSOs. CQRLog doesn't like a frequency that's formatted like 14.273.3 It's saying wrong QSO for the others. Looks like it's unhappy about the grid square on those.
73
Stan
KM4HQE