Hi Petr,

The program freezes when I try to do a manual log export. I just tried the export function and here is the terminal output up to the poing of the program freeze:
*********************************************************************
tony@tony-pc:~$ cqrlog
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 52170 LoTW users
Loaded 62283 eQSL users
*
User home directory: /home/tony/
Program home directory: /home/tony/.config/cqrlog/
Data directory: /home/tony/.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/
*
/usr/sbin/mysqld --defaults-file=/home/tony/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/tony/.config/cqrlog/database/ --socket=/home/tony/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K
120629 16:42:27 [Note] Plugin 'FEDERATED' is disabled.
120629 16:42:27 InnoDB: The InnoDB memory heap is disabled
120629 16:42:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120629 16:42:27 InnoDB: Compressed tables use zlib 1.2.3.4
120629 16:42:27 InnoDB: Initializing buffer pool, size = 128.0M
120629 16:42:28 InnoDB: Completed initialization of buffer pool
120629 16:42:28 InnoDB: highest supported file format is Barracuda.
120629 16:42:28 InnoDB: Waiting for the background threads to start
120629 16:42:29 InnoDB: 1.1.8 started; log sequence number 1595675
120629 16:42:29 [Note] Server hostname (bind-address): '(null)'; port: 64000
120629 16:42:29 [Note] - '(null)' resolves to '0.0.0.0';
120629 16:42:29 [Note] - '(null)' resolves to '::';
120629 16:42:29 [Note] Server socket created on IP: '0.0.0.0'.
120629 16:42:29 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
120629 16:42:29 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
120629 16:42:29 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
120629 16:42:29 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
120629 16:42:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.24-0ubuntu0.12.04.1' socket: '/home/tony/.config/cqrlog/database/sock' port: 64000 (Ubuntu)
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

SELECT * FROM cqrlog_config

select * from db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

huu1
huu2
In create
All objects created
huu3
huu4

Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m %m -r %r -t %t -s 9600
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB1
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 750
RigSendCWR: FALSE
RigId: 228

Starting RigCtld ...
/usr/bin/rigctld -m 228 -r /dev/ttyUSB1 -t 4532 -s 9600
rig_open: error = IO error
rigctld started!
Result0:N
Result1:Y
Result2:Y
Connected to localhost:4532
Loading window size a position (height|width|top|left):651|793|24|2
Section:frmQSODetails
Loading window size a position (frmQSODetails) (height|width|top|left):210|353|24|797
CW init
SunDelta:-3.999700000000000000E+00
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

2012-06-29 20:42:33
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0

LoadForm: frmMain
Loading: Section: frmMain_dbgrdMain Ident: id_cqrlog_main Width: 0
Loading: Section: frmMain_dbgrdMain Ident: qsodate Width: 110
Loading: Section: frmMain_dbgrdMain Ident: time_on Width: 77
Loading: Section: frmMain_dbgrdMain Ident: time_off Width: 0
Loading: Section: frmMain_dbgrdMain Ident: callsign Width: 220
Loading: Section: frmMain_dbgrdMain Ident: freq Width: 110
Loading: Section: frmMain_dbgrdMain Ident: mode Width: 88
Loading: Section: frmMain_dbgrdMain Ident: rst_s Width: 220
Loading: Section: frmMain_dbgrdMain Ident: rst_r Width: 220
Loading: Section: frmMain_dbgrdMain Ident: name Width: 440
Loading: Section: frmMain_dbgrdMain Ident: qth Width: 660
Loading: Section: frmMain_dbgrdMain Ident: qsl_s Width: 55
Loading: Section: frmMain_dbgrdMain Ident: qsl_r Width: 55
Loading: Section: frmMain_dbgrdMain Ident: qsl_via Width: 0
Loading: Section: frmMain_dbgrdMain Ident: iota Width: 0
Loading: Section: frmMain_dbgrdMain Ident: pwr Width: 0
Loading: Section: frmMain_dbgrdMain Ident: itu Width: 0
Loading: Section: frmMain_dbgrdMain Ident: waz Width: 0
Loading: Section: frmMain_dbgrdMain Ident: loc Width: 0
Loading: Section: frmMain_dbgrdMain Ident: my_loc Width: 0
Loading: Section: frmMain_dbgrdMain Ident: county Width: 0
Loading: Section: frmMain_dbgrdMain Ident: award Width: 0
Loading: Section: frmMain_dbgrdMain Ident: remarks Width: 0
Loading: Section: frmMain_dbgrdMain Ident: band Width: 0
Loading: Section: frmMain_dbgrdMain Ident: dxcc_ref Width: 0
Loading: Section: frmMain_dbgrdMain Ident: qso_dxcc Width: 0
Loading: Section: frmMain_dbgrdMain Ident: profile Width: 0
Loading: Section: frmMain_dbgrdMain Ident: idcall Width: 0
Loading: Section: frmMain_dbgrdMain Ident: state Width: 0
Loading: Section: frmMain_dbgrdMain Ident: lotw_qslsdate Width: 0
Loading: Section: frmMain_dbgrdMain Ident: lotw_qslrdate Width: 0
Loading: Section: frmMain_dbgrdMain Ident: lotw_qsls Width: 0
Loading: Section: frmMain_dbgrdMain Ident: lotw_qslr Width: 0
Loading: Section: frmMain_dbgrdMain Ident: cont Width: 0
Loading: Section: frmMain_dbgrdMain Ident: qsls_date Width: 0
Loading: Section: frmMain_dbgrdMain Ident: qslr_date Width: 0
Loading: Section: frmMain_dbgrdMain Ident: club_nr1 Width: 0
Loading: Section: frmMain_dbgrdMain Ident: club_nr2 Width: 0
Loading: Section: frmMain_dbgrdMain Ident: club_nr3 Width: 0
Loading: Section: frmMain_dbgrdMain Ident: club_nr4 Width: 0
Loading: Section: frmMain_dbgrdMain Ident: club_nr5 Width: 0
Loading: Section: frmMain_dbgrdMain Ident: eqsl_qsl_sent Width: 0
Loading: Section: frmMain_dbgrdMain Ident: eqsl_qslsdate Width: 0
Loading: Section: frmMain_dbgrdMain Ident: eqsl_qsl_rcvd Width: 0
Loading: Section: frmMain_dbgrdMain Ident: eqsl_qslrdate Width: 0
Loading: Section: frmMain_dbgrdMain Ident: qslr Width: 0
Loading: Section: frmMain_dbgrdMain Ident: country Width: 0
Column:QSODATE:TRUE
Column:TIME_ON:TRUE
Column:TIME_OFF:FALSE
Column:CALLSIGN:TRUE
Column:MODE:TRUE
Column:FREQ:TRUE
Column:RST_S:TRUE
Column:RST_R:TRUE
Column:NAME:TRUE
Column:QTH:TRUE
Column:QSL_S:TRUE
Column:QSL_R:TRUE
Column:QSL_VIA:FALSE
Column:LOC:FALSE
Column:MY_LOC:FALSE
Column:IOTA:FALSE
Column:AWARD:FALSE
Column:COUNTY:FALSE
Column:PWR:FALSE
Column:DXCC_REF:FALSE
Column:REMARKS:FALSE
Column:WAZ:FALSE
Column:ITU:FALSE
Column:STATE:FALSE
Column:LOTW_QSLSDATE:FALSE
Column:LOTW_QSLRDATE:FALSE
Column:LOTW_QSLS:FALSE
Column:LOTW_QSLR:FALSE
Column:CONT:FALSE
Column:QSLS_DATE:FALSE
Column:QSLR_DATE:FALSE
Column:EQSL_QSL_SENT:FALSE
Column:EQSL_QSLSDATE:FALSE
Column:EQSL_QSL_RCVD:FALSE
Column:EQSL_QSLRDATE:FALSE
Column:QSLR:FALSE
Column:COUNTRY:FALSE
SELECT COUNT(*) FROM cqrlog_main

select count(*) from (select distinct adif from cqrlog_main where adif <> 0 and (adif not in (2,8,19,23,25,26,28,30,39,42,44,55,57,58,59,67,68,81,85,93,101,102,113,115,119,127,128,139,151,154,155,164,178,183,184,186,193,193,194,196,198,200,208,210,218,220,226,228,229,231,243,244,255,258,261,264,267,268,271,307,488,493))) as foo

select count(*) from (select distinct dxcc_id.dxcc_ref from dxcc_id left join cqrlog_main on dxcc_id.adif = cqrlog_main.adif WHERE cqrlog_main.adif<>0 and (dxcc_ref NOT LIKE '%*') AND (qsl_r = 'Q')) as foo

Loading window size a position (height|width|top|left):587|854|27|65

(cqrlog:4054): Gtk-CRITICAL **: IA__gtk_tree_model_get: assertion `GTK_IS_TREE_MODEL (tree_model)' failed
TApplication.HandleException Access violation
Stack trace:
$B6D02576
*********************************************************************
After it freezes, I have to reboot the computer since the program will not respond at all.

73,
Tony (N2ATB)