Corrupt database problem

4 posts / 0 new
Last post
G8FXM
G8FXM's picture
Corrupt database problem

I'm getting the followig error when I start up CQRLog:
Invalid integer ""
Press OK to ignore and risk data corruption
Press cancel to kill the program
 
Of course I pressed "OK" :-(
But I still get the same whenever I start CQRLOG. I have a number of logbooks, this error only occurs on my primary (#1) log.
The followig is what I see in terminal when starting CQRLog.
 
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****
 
TApplication.HandleException "" is an invalid integer
  Stack trace:
  $08097FB1
  $08129FD5
  $080F7360
  $08170407
  $082C0398
  $082E645F
  $082E6BB6
  $08171311
  $0816FCFE
  $082C0398
  $082E645F
  $082E6BB6
  $08171155
  $083556A5
  $0835560F
  $08349A34
  $B6FECBE1
 
(cqrlog:4313): GLib-CRITICAL **: Source ID 11 was not found when attempting to remove it
(cqrlog:4313): GLib-CRITICAL **: Source ID 10 was not found when attempting to remove it
(cqrlog:4313): GLib-CRITICAL **: Source ID 43 was not found when attempting to remove it
(cqrlog:4313): GLib-CRITICAL **: Source ID 42 was not found when attempting to remove it
(cqrlog:4313): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it
(cqrlog:4313): GLib-CRITICAL **: Source ID 47 was not found when attempting to remove it
Closing ini file ...
dave@G8FXM-Shack ~ $ clear
dave@G8FXM-Shack ~ $ cqrlog
**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****
 
TApplication.HandleException "" is an invalid integer
  Stack trace:
  $08097FB1
  $08129FD5
  $080F7360
  $08170407
  $082C0398
  $082E645F
  $082E6BB6
  $08171311
  $0816FCFE
  $082C0398
  $082E645F
  $082E6BB6
  $08171155
  $083556A5
  $0835560F
  $08349A34
  $B6FC4BE1
 
Anyone have any idea on how I fix this?
 

ok2cqr
ok2cqr's picture
Re: Corrupt database problem

Hi Dave,
 
could you run cqrlog with --debug=1 parameter, please? There should be more info.
 
73 Petr

G8FXM
G8FXM's picture
Here you go:

Here you go:
 
cqrlog --debug=1
 
**** DEBUG LEVEL 1 ****
 
Loading libssl: /usr/lib/i386-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/i386-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/i386-linux-gnu/libmysqlclient.so.18
Loaded 75756 LoTW users
Loaded 0 eQSL users
Loaded 44996 SCP calls
*
User home directory:    /home/dave/
Program home directory: /home/dave/.config/cqrlog/
Data directory:         /home/dave/.config/cqrlog/database/
Memebers directory:     /home/dave/.config/cqrlog/members/
ZIP code directory:     /usr/share/cqrlog/zipcodes/
Binary dir:             /usr/bin/
Share dir:              /usr/share/cqrlog/
TConnection to MySQL:   5.5
*
select * from tables where table_schema = 'cqrlog_common'
 
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
 
use cqrlog004
 
use cqrlog004
 
use cqrlog004
 
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:
  $08097FB1
  $08129FD5
  $080F7360
  $08170407
  $082C0398
  $082E645F
  $082E6BB6
  $08171311
  $0816FCFE
  $082C0398
  $082E645F
  $082E6BB6
  $08171155
  $083556A5
  $0835560F
  $08349A34
  $B6FA0BE1
 

73'd De Dave, G8FXM O/S Linux Mint 18.1 KDE Plasma 64 bit  g8fxm@uksmg.org

G8FXM
G8FXM's picture
This has now happened to a

This has now happened to a second log, seems to occur if you accidentally open CQRLog when CQRLog is already open?

73'd De Dave, G8FXM O/S Linux Mint 18.1 KDE Plasma 64 bit  g8fxm@uksmg.org