Hallo,
today I tried to export QSL-labels for printing. Some time ago (with an older version of cqrlog) it worked very well.
Now I get the error "TMySQL57Connection : Error executing query: Data too long for column 'loc' at row 1."
I am using "cqrlog 2.5.2 (001) 2021-02-12" as provided via github on a debian bookworm (testing).
What I did:
- in QSO list window I selected the QSOs I want to print labels for via "Filter->Create" by selecting the start and end date (both the same day, as I want to print only for one day)
- I opend "QSL -> Export for label printing", there I selected "Export .. marked as SB" and selected the fields to be exported (which does not contain locator fields)
- I chose a place to save the file to (which is writable with enough space available)
- after pressing "Export" the error message is displayed.
I also tried older versions (cqrlog-2.5.1-1 and cqrlog-2.5.1-2) which where provided via debian, but they generate also (but another) error during export ("TRegExpr exec: empty input string").
It seems to me as a bug in cqrlog, so I post it here (as I did not find anything similar in the forum and via search field).
If there is a solution/work around, I would be happy to know it. If further information is needed, I can provide them.
Best 73 de Frank, DL8ABG
Just look qso list. There is some qso, which have too many
marks in "loc" column. Means LOCATOR or GRID
<p>Jarmo</p>
HI Frank!
If you can repeat this error every time with same filter settings please try to export adif with same filter settings.
When exported use fNewQSOfile/open or create a new log to get into "Database open" window.
Use utils/configuration/export to save your curent log settings.
Then create a new log, use utils/configuration/import to make new log have same settings.
Press cancel to return to NewQSO and close cqrlog.
Open cqrlog and open the New log.
Then adif import your qsos and try to make qsl labels again.
Do you get same error again?
If you do, please send your adif export and log configuration export files to me. You find my address from qrz or hamqth.
Note that older versions of cqrlog have TRegExpr error because of FreePascal change and thus do not work.
Your 2021-02-12 version is also nearly year old and have many bugs that are fixed already. You should consider to compile your cqrlog from source code (there are many messages in forum how to do it).
--
Saku
OH1KH
Hallo Saku,
many thanks for the hint (as I should have read the error message more closely to gain that info).
I found one QSO with more than 6 characters in the locator field. After correcting it to only 6 chars, the export worked as expected.
Many thanks for the fast help!
I will think about compiling a newer version.
Best 73 de Frank, DL8ABG
HI Frank!
It was actually Jarmo, OH1MMR, suggested to check locator lengths.
I did make fast check to source code and I thought there is a line where locator is cut to 6 characters. The database can hold locators to length of 10 characters.
Thanks for informing that locator length was the reason. I have to generate a log having long locator and try to test label printing with your instructions to see if I can make same kind of error.
If I can make it happen I may be able to generate a bugfix for it.
--
Saku
OH1KH
HI Frank!
I made a test log having two qsos where SB was set and other qso had a locator "KP01aa00bb".
Made filtering as you did, then exported labes for "SB".
No errors, both qsos were inserted in csv file.
My cqrlog was self compiled from official source:
Cqrlog Ver:2.5.2 (001) Date:2021-12-06
You find it from https://github.com/OH1KH/cqrlog/tree/loc_testing/compiled
(It was "cqr0.zip holds binary for 64bit systems compiled for GTK2 widgets from latest official source (without additions) using linux Mint20" version)
--
Saku
OH1KH
Hallo Saku,
with the version from the official deb-package I can reproduce the error by setting a locator to more than 6 characters.
I have currently not tested the precompiled version.
73 de Frank, DL8ABG
HI Frank!
Official packages are quite far behind. Maybe that is the reason.
If you look at https://github.com/ok2cqr/cqrlog/commits/master and scroll it down towards older commits you can see how much has been changed after the 2.5.2 release:
"Commits on Feb 12, 2021 version changed to 2.5.2"
And some days after release date there has been also fix:
"Commits on Mar 22, 2021 Shorten grid to 6 chars for label export"
That's why it is recommended to learn how to compile latest version from source. It is not very complex. In case of cqrlog it is one of the simplest jobs, but it have to be learned once. Like we all have had to do it in first time.
--
Saku
OH1KH