HI,
I closed the log at 18h, and now, when reopening, I have an error message: "" is a invalid integer.
CQRLog closes. Can not open it!
Help me please !!
Ubuntu 14.04 and CQRLog 1.8.1
Thu, 2014-08-07 22:58
#1
Bug : Invalid integer
Hi,
I think, this messages comes from a database entry or an entry in cqrlog.cfg.
Could you check, if you get this error also with a new database?
Hi,
open the console and start cqrlog with --debug=1 parameter. CQRLOG will write the log to the console, copy it and paste it here, please. Thanks!
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Message error
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib64/libssl.so.8
Loading libcrypto: /usr/lib64/libcrypto.so.8
Loading libmysqlclient: /usr/lib64/libmysqlclient.so.18.0.0
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.500000000000000000E+00
**********************************
Loaded 90904 LoTW users
Loaded 96609 eQSL users
Loaded 46037 SCP calls
*
User home directory: /home/roman/
Program home directory: /home/roman/.config/cqrlog/
Data directory: /home/roman/.config/cqrlog/database/
Memebers directory: /home/roman/Soft/cqrlog-1.9.1/usr/share/cqrlog/members/
ZIP code directory: /home/roman/Soft/cqrlog-1.9.1/usr/share/cqrlog/zipcodes/
Binary dir: /home/roman/Soft/cqrlog-1.9.1/usr/bin/
Share dir: /home/roman/Soft/cqrlog-1.9.1/usr/share/cqrlog/
TConnection to MySQL: 5.5
*
Trying to connect to database
Server connect failed.
Trying:1
Trying to connect to database
Server connect failed.
Trying:2
Trying to connect to database
Server connect failed.
Trying:3
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog002
use cqrlog002
use cqrlog002
use cqrlog002
use cqrlog002
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
TApplication.HandleException "" is an invalid integer
Stack trace:
$0000000000466182
$00000000004F0DF8
$00000000005947E5
$000000000075AD30
$0000000000789D76
$000000000078A666
$0000000000789C79
$000000000042E8C1
$000000000074A741
$0000000000831A95
$0000000000841332
Roman contacted me on Skype and we solved that. It was caused by broken configuration. I sent him fixed config file to import and it worked. Also just fixed CQRLOG to prevent this problem in the future.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Yep. Big tnx!
Need help... suffering same problem. Here is what I get when starting in debug mode:
max@xpc:~$ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.5
**************************
**********************************
MySQL version assigned: 5.500000000000000000E+00
**********************************
Loaded 92970 LoTW users
Loaded 97971 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/max/
Program home directory: /home/max/.config/cqrlog/
Data directory: /home/max/.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
*
Trying to connect to database
160411 12:55:27 [Note] /usr/sbin/mysqld (mysqld 5.5.47-MariaDB-1ubuntu0.14.04.1) starting as process 8269 ...
Server connect failed.
Trying:1
Trying to connect to database
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
TApplication.HandleException "" is an invalid integer
Stack trace:
$0000000000466182
$00000000004F0DF8
$00000000005947E5
$000000000075AD30
$0000000000789D76
$000000000078A666
$0000000000595C16
$0000000000593DAC
$000000000075AD30
$0000000000789D76
$000000000078A666
$0000000000595982
$0000000000806AD3
$00000000007F779F
$00007F6502F20703
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/max/.config/cqrlog/database/xpc.pid
Command:
kill 8269
(cqrlog:8259): GLib-CRITICAL **: Source ID 29 was not found when attempting to remove it
(cqrlog:8259): GLib-CRITICAL **: Source ID 28 was not found when attempting to remove it
(cqrlog:8259): GLib-CRITICAL **: Source ID 62 was not found when attempting to remove it
(cqrlog:8259): GLib-CRITICAL **: Source ID 61 was not found when attempting to remove it
(cqrlog:8259): GLib-CRITICAL **: Source ID 69 was not found when attempting to remove it
(cqrlog:8259): GLib-CRITICAL **: Source ID 68 was not found when attempting to remove it
Closing ini file ...
It's already fixed in beta version.
The problem was with TRX control configuration. Open the CQRLOG, in database connection window click to Utils button and choose Export configuration. Save it somewhere and open with gedit or your favourite text editor. Find [TRX1] section. There will be model=, change it to model=1 and do the same for [TRX2], [ROT1] and [ROT2] sections. Now run cqrlog again click to Utils button and import configuration back.
Or you can try betaversion.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr, thanks for quick help. I tried with the beta and it works.
73... Max. DK1MAX.
The same happen to me, any idea ?
cqrlog --debug=1
Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
/lib/x86_64-linux-gnu/libssl.so.1.0.0
/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.9
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/dimitris/
Program home directory: /home/dimitris/.config/cqrlog/
Data directory: /home/dimitris/.config/cqrlog/database/
Memebers directory: /home/dimitris/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/dimitris/.config/cqrlog/database/mysql.cnf --datadir=/home/dimitris/.config/cqrlog/database/ --socket=/home/dimitris/.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
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
SELECT * FROM cqrlog_config
select * from db_version
[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
TApplication.HandleException "" is an invalid integer
Stack trace:
$00000000004702FC
$000000000053650A
$00000000006CA59A
$00000000006CADE3
$00000000005AE648
$00000000006CA59A
$00000000006CADE3
$00000000005AE3F5
$000000000080E2A9
$000000000073FFE3
$00007FE677D0DAB3
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlog.cfg
Deleting config file: cqrlog.cfg
Closing dData
/home/dimitris/.config/cqrlog/database/dimitris.pid
Command:
kill 6959
Closing ini file ...
I rename .config/cqrlog/database to .config/cqrlog/databaseold, it seems that there are some errors there.
This will reconfigure cqrlog as new install. I set up everything from the beginning and I import QSO. I have a backup.