Bug : Invalid integer

11 posts / 0 new
Last post
ON6GMT
Bug : Invalid integer

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

DL7BJ
DL7BJ's picture
Hi,

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?
 
 

ok7an
ok7an's picture
Re: Bug : Invalid integer

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

ur3iqj
Message error

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

ok7an
ok7an's picture
Re: Message error

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.

ur3iqj
Yep. Big tnx!

Yep. Big tnx!

DK1MAX
Invalid Integer

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 ...

ok7an
ok7an's picture
Re: Invalid Integer

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

DK1MAX
beta works

Petr, thanks for quick help. I tried with the beta and it works.

73... Max. DK1MAX.

SV2RCK
"" is an invalid integer.

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 ...

SV2RCK
database

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.