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
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
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.
Did you read this?
https://www.cqrlog.com/comment/4741#comment-4741
--
Saku
OH1KH
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.
And the table dxcc_id has only one row in it
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