Bogus SQL data shown in NewQSO Window (Alpha_135_QT6)

6 posts / 0 new

Last post

Mon, 2024-12-30 00:20

JQ1UCG

Hi, Does anyone know the cause of Bogus SQL Text shown in New QSO window ?
Or please tell me how to fix this.
Like:

Always SQL error shown when Quit button pressed at this moment Like:

After re-launch CQRLOG, bugus text gone always like

My environment:
CQRLOG Alpha_(135)_QT6, Source code pulled from git,
here"s the last updated shown in 'git log'

>commit c72c5e27912b149b8fe4d5f47b17b8173d689a84 (HEAD -> loc_testing, origin/loc_testing)
>Author: OH1KH <oh1kh@oh1af.fi>
>Date: Sat Dec 28 17:37:15 2024 +0200
> Fixed bad formatted members/marconista.txt file

Regard, AO

Mon, 2024-12-30 08:57

oh1kh

Bogus SQL data shown in NewQSO Window (Alpha_135_QT6)

HI!

It looks like your database is corrupted.
"cqrlog_config"."config_file" is a longtext column that stores all the information from preferences.
Same data that you can export from "Database connection" window button utils/configuration/export.

Those HEX numbers could be just errors from file system or they can be illegal characters (UTF8 variants) in the data.

What comes to "END WAR!" text it is weird. If you have not added it, or it has not come from QRZ or other Ham Call data source and if you have Windows at same machine I would like to offer a virus explanation. Well, plain Linuxes also can have viruses but more seldom.

Maybe easiest way is to make full ADIF backup and then make a new log and do the import and set the preferences manually.
If you have only one log and it is "save log data to local machine", I.E. in your user folder, it would maybe be best to rename the ~/.config/cqrlog folder after ADIF backups are done and start Cqrlog from clean creating all from beginning and after that make ADIF import.

You can also try to make configuration export/import. That might be easy and quick way but may be that it does not solve your problem like clean start does (but it has less work):
At "Database connection" window , when you have selected your log but NOT opened it, press button utils/configuration/export and save configurations to file.
Open the file with plain text editor (nano, leafpad or similar) and go through all lines.
There should not be any corrupted lines. Just plain, readable text and numbers. If there are something weird just remove those lines. Finally save file.
After that at "Database connection" window , when you have selected your log but NOT opened it, press button utils/configuration/import and read the file.
Then open log and see if the problem disappeared.

--
Saku
OH1KH

Mon, 2024-12-30 15:17

(Reply to #2) #3

JQ1UCG

hi Saku, tks give a comment

hi Saku, tks give a comment to me, and your support !
I'm using linuxbox w/ CQRLOG and there's no Windows machine on the same subnet.

I'll do backup & restore to resume normal. (Using CQRLOG w/ mariadb so not chosen
"save log data to local machine")

Thank you again, AO.

Mon, 2024-12-30 16:25

(Reply to #3) #4

JQ1UCG

hm weird New QSO list header

hm weird New QSO list header again...

at this moment, CQRLOG -> quit shows me incorrect string value

here's mariadb query.log (a part)

srx_string=0\nstx_string=0\ncontestname=0\ndok=0\noperator=0\n\n[frmMain]\nHeight=399\nWidth=1277\nTop=410\nLeft=58\nMax=0\n\n[frmNewQSO_dbgrdQSOBefore]\n�\�4\0\0\0\0�\0\0\0\0\0\0\0�\n   ��\0\0�\n ��\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0eqsl_qsl_sent=0\0\0\0\0\0\0\0\0\0A\0\0\0\0\0\0\00*7\0\0\0\0�\n     ��\0\0\0=60\n��6\0\0\0\0!\0\0\0\0\0\0\0�\n     ��\0\0�\n      ��\0\0 \0\0\0\0\0\0\0 \0\0\0\0\0\0\\0\0\0\0\0\0\\0\0\0   \0\0\0\0\0\0\0\0\0Q\0\0\0\0\0\0\08\0\0\0\0\0\0\0\�\0\0\0\0\0\0\'\0\0\0\0\0\0\0߄��\0\0\0\0\0\0\0\0\0�\0\0\0JA4\0qrlog_m\0\0\0\0\0\0\0\0P\0\0\0\0\0\0\0Q\0\0\0\0\0\0\0p�j��\0\0\0\0\0\0\0\0 \0\0\0\0\04@\0\0\0\0\0\0\0\0\0\0\0\0\0\0
                                                       \0\0\0\0\0\0\�\�j��\0\0\0\0ʬn��?=60\ng\�4\0\0\0\0\�\0\0\0\0\0\0\0�\n    ��\0\0�\n      ��=60\n��4\0\0\0\0Q\0\0\0\0\0\0�
                                                                                                                                                                                        ��\0\0�
                                                                                                                                                                                                        ��\0\0�c�4\0\0\0\0\�\0\0L\0\0�\0\0\0\0\0\0@\0\0\0\0\0\0\0\��\�6\0\0\0\0▒%�\0\0\0\0\0�\�+7\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\�\0\0\0\0\0\0\0�
                                                                                                                                                                                        ��\0\0�
                                                                                                                                                                                                        ��\0\0h
     �4\0\0\0\0H��4\0\0\0\0x��4\0\0\0\0�<�4\0\0\0\0(Z�4\0\0\0\0؇�4\0\0\0\0�>�4\0\0\0\0�S�4\0\0\0\0�\n   ��\0\0�\n      ��\0\08��4\0\0\0\0q\0\0\0\0\0\0\0\�X;7\0\0\0\0�=60\nst\0\0\0\0\01\0\0\0\0\0\0\0�\n��\0\0��:7\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0��\0\0\�n\0x��\0\0�\n      ��\0\0!\0\0\0\0\0\0\0\0\0\0��=60\n;�4\0\0\0\0�\0\0\0\0\0\0�\n ��\0\0\�T�6\0\0\0\0�C�4\0\0\0\0x��4\0\0\0\0��4\0\0\0\0�c�4\0\0\0\0xx�4\0\0\0\0\�ԑ4\0\0\0\0hF�4\0\0\0\0a\0\0\0\0\0\0\0`\�\�6\0\0\0\0\��\�6\0\0\0\0 \0\0\0\0\0\0\0@\0\0\0\0\0\0\0�\�6\0\0\0\0▒%�\0\0\0\0\0x\�\�6\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0�\0\0\0\0\0\0\0\0\0\0\0\0\0\�\0\0\0\0\0\0\0P\ni9\0\0\0\0Q\0\0\0\0\0\0\0�\n     ��\0\0@8�4\0\0\0\0\0\0\0\0\0\0\0\0▒\0\0\0\0\0\0\0SET_MODE: CWR 500\nRPRT 0\0\0\0\0\0\0P=60\n��6\0\0\0\0Q\0\0\0\0\0\0\0�\n ��\0\0�\n      ��\0\0RPRT\0ode1\0\0\0\0\0\0\0�\��6\0\0\0\0\�\n        ��\0\0��6\0\0\0\0\0\0\0\0\0\0\0P\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\05\0\0\0\0\0\0\0\0\0\0\0\0\0�\�=60\n26 q\0\0\0\0\0\0\0�\n      ��\0\0�\��6\0\0\0\0Z\nDX de DL9GTB-#: 10109.6 RA3GAA         CW    11 dB=60\n00\nRPRT�\0\0\0\0\0\0�\n        ��\0\0\�\�
        7\0\0\0\0\0\0\0�\n      ��\0\0�\n      ��\0\0RPR=60\nqsodate=60\ntime_on=60\ncallsign=60\nmode=60\nfreq=60\nrst_s=60\nrst_r=60\nname=60\nqth=60\nremarks=60\nlotw_qslsdate=60\nlotw_qslrdate=60\neqsl_qslsdate=60\neqsl_qslrdate=60\nqslr=60\n�\�4\0\0\0\0�\0\0\0\0\0\0\0�=100\n��\0\0�=100\n��\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0eqsl_qsl_sent=100\n��6\0\0\0\0!\0\0\0\0\0\0\0�=100\n��\0\0�=100\n��\0\0 \0\0\0\0\0\0\0 \0\0\0\0\0\0\\0\0\0\0\0\0\\0\0\0   \0\0\0\0\0\0\0\0\0Q\0\0\0\0\0\0\08\0\0\0\0\0\0\0\�\0\0\0\0\0\0\'\0\0\0\0\0\0\0߄��\0\0\0\0\0\0\0\0\0�\0\0\0JA4\0qrlog_m\0\0\0\0\0\0\0\0P\0\0\0\0\0\0\0Q\0\0\0\0\0\0\0p�j��\0\0\0\0\0\0\0\0 \0\0\0\0\04@\0\0\0\0\0\0\0\0\0\0\0\0\0\0
                                                                           \0\0\0\0\0\0\�\�j��\0\0\0\0ʬn��?=100\ng\�4\0\0\0\0\�\0\0\0\0\0\0\0�=100\n��\0\0�=100\n��=100\n��4\0\0\0\0Q\0\0\0\0\0\0�
                                                                                                                                                                                                        ��\0\0�
        ��\0\0�c�4\0\0\0\0\�\0\0L\0\0�\0\0\0\0\0\0@\0\0\0\0\0\0\0\��\�6\0\0\0\0▒%�\0\0\0\0\0�\�+7\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\�\0\0\0\0\0\0\0�
                                                                                                                                                                                                ��\0\0�
                                                                                                                                                                                                          ��\0\0h
       �4\0\0\0\0H��4\0\0\0\0x��4\0\0\0\0�<�4\0\0\0\0(Z�4\0\0\0\0؇�4\0\0\0\0�>�4\0\0\0\0�S�4\0\0\0\0�=100\n��\0\0�=100\n��\0\08��4\0\0\0\0q\0\0\0\0\0\0\0\�X;7\0\0\0\0�=100\nst\0\0\0\0\01\0\0\0\0\0\0\0�=100\n��\0\0��:7\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00\0\0\0\0\0\0\0 \0\0\0\0\0\0\0\0\0\0��\0\0\�n\0x��\0\0�=100\n��\0\0!\0\0\0\0\0\0\0\0\0\0��=100\n1\0\0\0\0\0\0\0\�J\��\0\0\0\0\0\0\0\0\0\0�\��4\0\0\0\0pG\�6\0\0\0\05\0\0\0\0\0\0\0a\0\0\0\0\0\0\0\0\0\0\0\�\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0▒%�\0\0\0\0\00��6\0\0\0\0�D\�6\0\0\0\0view_cqrlog_main_by_qsodate\0\0\0\0\0`=60\nQ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\01\0\0\0\0\0\0\0��\�6\0\0\0\0�6\0\0\0\0�6\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\01=60\ni9\0\0\0\0Q\0\0\0\0\0\0\0�=100\n��\0\0@8�4\0\0\0\0\0\0\0\0\0\0\0\0▒\0\0\0\0\0\0\0SET_MODE: CWR 500=100\nRPRT 0\0\0\0\0\0\0P=100\n��6\0\0\0\0Q\0\0\0\0\0\0\0�=100\n��\0\0�=100\n��\0\0RPRT\0ode1\0\0\0\0\0\0\0�\��6\0\0\0\0\�=100\n��\0\0��6\0\0\0\0\0\0\0\0\0\0\0P\0\0\0\0\0\0\00\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\05\0\0\0\0\0\0\0\0\0\0\0\0\0�\�=100\nQ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0P\0\0\0\0\0\0\0\�\0\0\0\0\0\0\0f-7\0\0\0\0��\�K��\�\0\0\0\0\0\0\0\0�\0\0\0\0\0\0\028.000|28.500|40.=60\n26 q\0\0\0\0\0\0\0�=100\n��\0\0�\��6\0\0\0\0Z=52\nDX de DL9GTB-#: 10109.6 RA3GAA         CW    11 dB=100\n\n[RBNFilter]\nSrcCont=AS\nSrcCall=J\nIgnHour=1\nIgnHourValue=48\nIgnDate=0\nIgnDateValue=\nIgnTimeValue=\nAllowAllCall=1\nAllowOnlyCall=0\nAllowOnlyCallValue=\nAllowOnlyCallReg=0\n

hm, go remake db, then restart....

Mon, 2024-12-30 17:27

oh1kh

hm weird New QSO list header

Are you sure your hard drive is ok?

Perhaps you need to remove whole MariaDB check that all related files are gone and then reinstall it.
Then start Cqrlog from zero and do ADIF import.

--
Saku
OH1KH

Wed, 2025-01-01 02:54

(Reply to #5) #6

JQ1UCG

Hi Saku HNY2025!

My HDD seems to be ok validated by fsck. (using ARM/Ubuntu platform)

I gonna debugging w/ mariadb/CQRLOG logging this winter vacation,
cause while receiving/clicking RBN data window/colomn, it seems to be inserted weird data into New QSO List header...

So HNY 2025!, AO

Bogus SQL data shown in NewQSO Window (Alpha_135_QT6)

New forum topics

Active forum topics

Recent comments

Who's online

Who's new

Search

User login

Who's online

Who's new