Problem"" is an invalid integer.

9 posts / 0 new
Last post
DG0ERS
Problem"" is an invalid integer.

Hi there,
I m a newbie in linux and therefor also in CQRLOG.
I installed it an run it for the first time.
the error message tells me .... "" is an invalid integer.

this is the debug log

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib64/libssl.so.1.0.0
/usr/lib64/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib64/libmysqlclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/dg0ers/
Program home directory: /home/dg0ers/.config/cqrlog/
Data directory: /home/dg0ers/.config/cqrlog/database/
Memebers directory: /home/dg0ers/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/dg0ers/.config/cqrlog/database/mysql.cnf --datadir=/home/dg0ers/.config/cqrlog/database/ --socket=/home/dg0ers/.config/cqrlog/database/sock --port=64000
2019-09-01 17:20:38 0 [Note] /usr/sbin/mysqld (mysqld 10.4.7-MariaDB) starting as process 2400 ...
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:
$000000000047033C
$000000000053654A
$00000000006CA63A
$00000000006CAE83
$00000000006CA526
$0000000000431FAF
$0000000000658D8D
$000000000082DB32
$000000000083FB91

anyone an idea and little help for me??
tnx de Enrico

oh1kh
Problem"" is an invalid integer.

Hi Enrico!

It looks like your DXCC information is not valid.
If you have not used cqrlog before delete hidden folder ~/.config/cqrlog

WARNING! this folder has your logs, so be sure you have not used cqrlog before. I.E. no qsos in log.

Then uninstall and install (reinstall) cqrlog again and start it and see does it work now.

--
Saku
OH1KH

DG0ERS
sorry its not function

I have delete the folder ~/.config/cqrlog and then uninstall and install cqrlog again. them will create cqrlog a logfile and i get this error message (pic1)

File: 

73 de Enrico

DG0ERS
start message

first start

File: 

73 de Enrico

DG0ERS
"" is an invalid integer.

error message "" is an invalid integer.

File: 

73 de Enrico

oh1kh
Problem"" is an invalid integer.

Hi Enrico !

Can you open command console and give this comand:

ls -l /usr/lib64/libmysqlclient.so

And copy result to next message.

With Mariadb that command should give something like:
/usr/lib64/libmysqlclient.so -> libmariadb.so.3

I just wonder could you have MariaDB and Mysql (or mysqlclient) installed together?
Dump says "(mysqld 10.4.7-MariaDB) starting " and "MySQL version assigned: 5.6". I think it should say 5.7 there.

In your picture 20190907161109.png there is a database creation error and that is the reason log001 does not open, I think.

--
Saku
OH1KH

DG0ERS
Hi Saku,

Hi Saku,
mny tnx for answer. mariasql is running. I thin also the problem is not cqrlog, i meen its a problem with the config of mariadb

"Can you open command console and give this comand:

ls -l /usr/lib64/libmysqlclient.so

And copy result to next message."

[dg0ers@dg0ers ~]$ ls -l /usr/lib64/libmysqlclient.so
lrwxrwxrwx 1 root root 15 31. Jul 07:50 /usr/lib64/libmysqlclient.so -> libmariadb.so.3

and this is the status message of mariadb

mysql Ver 15.1 Distrib 10.4.7-MariaDB, for Linux (x86_64) using readline 5.1

Connection id: 28
Current database:
Current user: dg0ers@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.4.7-MariaDB Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /run/mysqld/mysqld.sock
Uptime: 3 hours 25 min 40 sec

Threads: 7 Questions: 106 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 10 Queries per second avg: 0.008
--------------

73 de Enrico

oh1kh
Problem"" is an invalid integer.

Hi !
Looks like it is same problem as in this thread: https://www.cqrlog.com/node/2272
Some kind of solution can be found from this thread https://www.cqrlog.com/node/2269

As you do not have any qsos in log you can delete ~/.config/cqrlog before trying again with suggestions from that thread.
You have to delete folder as long as you are getting 20190907161109.png like error in first start of cqrlog to be sure that log001 is properly created.
After first start goes ok you can also open log001.

--
Saku
OH1KH

DG0ERS
ok, thanks, I'll look at the

ok, thanks, I'll look at the two threads and test the function. I will get back to you later

73 de Enrico