2.3.0 ""invalid interger

7 posts / 0 new
Last post
TF1MT
2.3.0 ""invalid interger

Hello

I suddenly get this error when I try to start the program. I have it set up in two computers, connected to remote database in my server. Only use one computer at a time, and stop the program before I start it in the other computer. This just now comes up with error when I try to start on both computers.

"" is an invalid integer.

Press OK to ignore and risk data corruption.
Press Abort to kill the program.

This is the debug data:

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/magnus/
Program home directory: /home/magnus/.config/cqrlog/
Data directory: /home/magnus/.config/cqrlog/database/
Memebers directory: /home/magnus/.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
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
$00007F5D77093AB3
SELECT COUNT(*) FROM cqrlog_main

select * from profiles order by nr

SELECT * FROM view_cqrlog_main_by_qsodate

Command line: tar -cvzf TF1MT_2018-07-15_23-05-05.tar.gz TF1MT_2018-07-15_23-05-05.adi
TF1MT_2018-07-15_23-05-05.adi
Closing rigs...
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):659|807|139|503
Command line: killall xplanet
select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
select count(*) from cqrlog001.cqrlog_config

Saving ini file to database
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: 1cqrlog.cfg
Deleting config file: cqrlog.cfg
Closing dData
Closing ini file ...

Best Regards
Magnus
73 de TF1MT

oh1kh
Hi !

Hi !

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
TApplication.HandleException "" is an invalid integer

This looks like same problem with new dxccdata import that has many messages recently.
The fault report is just a bit different.

Do you have DB backups from time before accepting last dxccdata update at program start?

--
Saku
OH1KH

TF1MT
Found out how to fix this

I got new Ambigous.tbl file from the newest version tarball. Put it in to ~.config/cqrlog/ctyfiles, then did from crqlog, qso-list window import dxcc the file and now it works again.

oh1kh
2.3.0 ""invalid interger

--
Saku
OH1KH

TF1MT
2.3.0 ""invalid interger

Yes I read it but found not out.

I opened the database and the table dcxx_ref is empty!I do not have new backup from this database.

TF1MT
no dxcc data

And the table dxcc_id has only one row in it

oh1kh
Hi!

Hi!
If dxcc_id is empty (or nearly) do new update. It is now working ok and safe to use.

Delete files:

CallResolution.tbl
Country.tab
AreaOK1RR.tbl
cqrlog-cty.tar.gz

from ~/.config/cqrlog/ctyfiles/ directory, then restart CQRLOG and confirm auto upgrade.

--
Saku
OH1KH