Hi Petr,
Just a heads up at this stage until I check that I have not done something wrong but CQRLog won't complete the startup after upgrading from 1.9.1 to 2.0.0 and simply shuts down the opened windows so far. A debug dump at level 0 and level 1 is added below.
73, Graeme ZL2APV
gvj@E1505 ~ $ cqrlog
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****
160421 16:06:13 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 2957 ...
rig_open: error = Invalid configuration
TApplication.HandleException TControl.InvalidatePreferredSize loop detected toolMain:TToolBar Bounds=l=0,t=0,r=819,b=26
Stack trace:
$082B27A0
$082B273E
$082A8C45
$082A865E
$082B22BD
$0829CB0F
$0829C32E
$0829BEF6
$082A2B7D
$082ACD21
$082ACD55
$082ACAD2
$0829D8A4
$082B2A70
$082A5CEA
$082AF3C1
$080B3E19
TWinControl.UpdateShowing.ChangeShowing failed for frmMain:TfrmMain, Showing reset to False
TApplication.HandleException: there was another exception during showing the first exception
Stack trace:
$082B27A0
$082B273E
$082A8C45
$082A865E
$082B22BD
$0829CB0F
$0829C32E
$0829BEF6
$082A2B7D
$082ACD21
$082ACD55
$082ACAD2
$0829D8A4
$082A7CCC
$082A7C90
$082A7C90
$082CB09A
Closing ini file ...
gvj@E1505 ~ $ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 91088 LoTW users
Loaded 96657 eQSL users
Loaded 46037 SCP calls
*
User home directory: /home/gvj/
Program home directory: /home/gvj/.config/cqrlog/
Data directory: /home/gvj/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.5
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/gvj/.config/cqrlog/database/mysql.cnf --datadir=/home/gvj/.config/cqrlog/database/ --socket=/home/gvj/.config/cqrlog/database/sock --port=64000
Trying to connect to database
160421 16:07:12 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 2993 ...
TMySQL55Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:2
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
SELECT * FROM cqrlog_config
select * from db_version
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 2 -r /dev/null -t 4532
RunRigCtld: TRUE
RigDevice: /dev/null
RigCtldPort:4532
RigCtldHost:127.0.0.1
RigPoll: 512
RigSendCWR: FALSE
RigId: 2
Starting RigCtld ...
/usr/bin/rigctld -m 2 -r /dev/null -t 4532
rig_open: error = Invalid configuration
rigctld failed to start!
1
2
3
4
5
6
Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1
rotctld started!
Connected to localhost:4533
select id,freq,mode,bandwidth from freqmem order by id
CW init
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0
LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main
select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo
select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND ((qsl_r = 'Q') OR (lotw_qslr = 'L') OR (eqsl_qsl_rcvd='E'))) as foo
TApplication.HandleException TControl.InvalidatePreferredSize loop detected toolMain:TToolBar Bounds=l=0,t=0,r=819,b=26
Stack trace:
$082B27A0
$082B273E
$082A8C45
$082A865E
$082B22BD
$0829CB0F
$0829C32E
$0829BEF6
$082A2B7D
$082ACD21
$082ACD55
$082ACAD2
$0829D8A4
$082B2A70
$082A5CEA
$082AF3C1
$080B3E19
TWinControl.UpdateShowing.ChangeShowing failed for frmMain:TfrmMain, Showing reset to False
TApplication.HandleException: there was another exception during showing the first exception
Stack trace:
$082B27A0
$082B273E
$082A8C45
$082A865E
$082B22BD
$0829CB0F
$0829C32E
$0829BEF6
$082A2B7D
$082ACD21
$082ACD55
$082ACAD2
$0829D8A4
$082A7CCC
$082A7C90
$082A7C90
$082CB09A
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/gvj/.config/cqrlog/database/E1505.pid
Command:
kill 2993
Closing ini file ...
gvj@E1505 ~ $
Hi Graeme,
I'm sorry, I've never seen this before. Maybe it's related to saved position of windows. Please start CQRLOG and in Database connection window click to Utils -> Configuration -> Export and save it to a file. Use gedit or your favourite text editor to open the file. Find [Main] section. You should see something like:
[Main]
Height=822
Width=1167
Top=73
Left=931
Max=0
Toolbar=1
Buttons=1
Details=1
Delete the data. Save the file and use Utils -> Configuration -> Import to load the config file back.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks for looking at this Petr and of course it is my luck to get an unusual problem. Here is some more clues for you. I managed to get CQRLog started by quickly selecting another database during startup (I needed to be quick enough to make a teenage gamer jealous) and the program then ran but crashed when I selected the main database (database #1) so I went through the process again and from the second database I deleted all the data using the utils in the main #1 database. I then selected it and was in the process of importing my backup when it crashed. Here is the debug trace below ...
cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.5
**********************************
Loaded 93257 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/gvj/
Program home directory: /home/gvj/.config/cqrlog/
Data directory: /home/gvj/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.5
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/gvj/.config/cqrlog/database/mysql.cnf --datadir=/home/gvj/.config/cqrlog/database/ --socket=/home/gvj/.config/cqrlog/database/sock --port=64000
Trying to connect to database
160421 20:14:45 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 4002 ...
TMySQL55Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL55Connection : Server connect failed.
Trying:2
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog003
use cqrlog003
use cqrlog003
use cqrlog003
use cqrlog003
SELECT * FROM cqrlog_config
select * from db_version
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1
1
2
3
4
5
6
Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1
rotctld started!
Connected to localhost:4533
select id,freq,mode,bandwidth from freqmem order by id
CW init
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0
LoadForm: frmMain
SELECT COUNT(*) FROM cqrlog_main
select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,134,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo
select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND (qsl_r = 'Q')) as foo
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
select count(*) from cqrlog003.cqrlog_config
Saving ini file to database
select count(*) from cqrlog003.cqrlog_config
Saving ini file to database
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
SELECT * FROM cqrlog_config
select * from db_version
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1
1
2
3
4
5
6
1
2
3
4
5
6
Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1
rotctld started!
Connected to localhost:4533
select id,freq,mode,bandwidth from freqmem order by id
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
LoadForm: frmNewQSO
TApplication.HandleException Access violation
Stack trace:
$B68CF92A
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
Deleting config file: 3cqrlog.cfg
Deleting config file: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/gvj/.config/cqrlog/database/E1505.pid
Command:
kill 4002
Closing ini file ...
I'm sorry Graeme, I have no idea what could be wrong. Could you send me whole ~/.config/cqrlog directory, please?
You haven't to be fast to click to another log. Open ~/.config/cqrlog/cqrlog_login.cfg and change AutoOpen=1 to AutoOpen=0.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Thanks for looking at this Petr. I have found that it will crash if I try to import an adif file from my home directory as soon as I scroll down the directory but if I try to download the same adif from the ~/.config/cqrlog directory (that is the default path) it all works OK for me - very strange. The cqrlog directory has been sent direct
Good luck with the debugging.
73, Graeme ZL2APV
gvj@E1505 ~ $ uname -a
Linux E1505 3.16.0-38-generic #52~14.04.1-Ubuntu SMP Fri May 8 09:44:48 UTC 2015 i686 i686 i686 GNU/Linux
Hi Petr,
Sorry but still problems. The out.txt file is attached. I started CQRLog and chose file/import/adif and chose my home directory then scrolled up and down the chooser window and it locked. Force close of the chooser window shut down CQRLog. Don't be in a hurry on my account as my main copy of CQRLog on my radio computer is running OK>
73, Graeme ZL2APV
Hello Petr,
Here is another clue to the mystery crashes I have on my main log. When I refresh the "qso list" window I get the following error message ...
qCQRLOG : Field not found : "id_cqrlog_main".
Press OK to ignore and risk data corruption.
Press Cancel to kill the program.
I have made a new log with exactly the same preferences and imported the main log data. This new log seems to work perfectly and allows refreshing and importing etc. with no errors.
73, Graeme zl2apv
My Log is all sorted out now. The short answer lay in the instructions from Petr ...
Please start CQRLOG and in Database connection window click to Utils -> Configuration -> Export and save it to a file. Use gedit or your favourite text editor to open the file. Find [Main] section. You should see something like:
[Main]
Height=822
Width=1167
Top=73
Left=931
Max=0
Toolbar=1
Buttons=1
Details=1
Delete the data. Save the file and use Utils -> Configuration -> Import to load the config file back.
The long answer is that I thought you needed to have the log opened to import the config file and of course I could not open the log as part of the fault so I built another log and configured it identically then used it to overwrite the config data. As I progressed I came to understand better how the config worked and discovered how Petr had set the files up where I could do it all from the database connection window. You really are a clever fellow Petr and I wish I had twigged to this earlier. Anyway the bug which was not really a bug is gone.
73 de Graeme ZL2APV
Hey,
here is what I get when I try to start cqrlog.
73 from Guenter
File:
hey petr,
I now have deleted cqrlog and then I installed again.
It satrts now without problems,but how can I import the old entrys in the new log???
I have a backup of the old dates.
73 from Guenter