When I try and start CQRLOG it goes okay until I try and import an ADIF file. I get the selection window and then about 10 seconds later I get a window pop up with a message "Access violation Press OK to risk data corruption or press CANCEL to kill the program" clicking on either choice gets no response and the program becomes non-responsive even to the point of not responding to clicking on the close icon on the window or the close option on the File Menu. After some time (about a minute or so) the program finally closes.
This happened after a period of several months during which CQRLOG worked fine. I suspect that there's some incompatibility with a newer mysql version.
I've tried deleting and reinstalling CQRLOG. I get a complaint after re-install about cqrlog_common database. Using mysql cqrlog_common doesn't show as an existing database.
Advice please
dave
k2lyv
Hi Dave,
could you send me the adif file to my email, please? Maybe there is a bug in ADIF import somewhere.
My email is petr@ok2cqr.com. Thank you!
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
I get this occurrence whenever I try to use the "copy to" drop down menu option between folders in my Home folder. Using "copy" and "paste" does not cause it, but works fine. Jim
Petr
Sorry for the delay, but I ran CQRLOG from a terminal window and copied the output a file. All I did was to 1)open CQRLOG, 2)Show QSO list 3)Click on Import ADIF. At this point the selection window comes up and while I was trying to select the ADIF file I got the "access violation" message. No ADIF file was selected, the crash happened before I could select one.
Hope this helps.
Output follows:
drdave@dualboot:~$ 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.0.0
Loaded 67432 LoTW users
Loaded 77216 eQSL users
*
User home directory: /home/drdave/
Program home directory: /home/drdave/.config/cqrlog/
Data directory: /home/drdave/.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/
TConnection to MySQL: 5.5
*
/usr/sbin/mysqld --defaults-file=/home/drdave/.config/cqrlog/database/my.cnf --default-storage-engine=MyISAM --datadir=/home/drdave/.config/cqrlog/database/ --socket=/home/drdave/.config/cqrlog/database/sock --skip-grant-tables --port=64000 --key_buffer_size=32M --key_buffer_size=4096K
131202 8:37:35 [Note] Plugin 'FEDERATED' is disabled.
131202 8:37:35 InnoDB: The InnoDB memory heap is disabled
131202 8:37:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131202 8:37:35 InnoDB: Compressed tables use zlib 1.2.7
131202 8:37:35 InnoDB: Using Linux native AIO
131202 8:37:35 InnoDB: Initializing buffer pool, size = 128.0M
131202 8:37:35 InnoDB: Completed initialization of buffer pool
131202 8:37:35 InnoDB: highest supported file format is Barracuda.
131202 8:37:35 InnoDB: Waiting for the background threads to start
131202 8:37:36 InnoDB: 5.5.34 started; log sequence number 1595675
131202 8:37:36 [Note] Server hostname (bind-address): '0.0.0.0'; port: 64000
131202 8:37:36 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131202 8:37:36 [Note] Server socket created on IP: '0.0.0.0'.
131202 8:37:36 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
131202 8:37:36 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
131202 8:37:36 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
131202 8:37:36 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
131202 8:37:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.34-0ubuntu0.13.04.1' socket: '/home/drdave/.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
In create
All objects created
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:
RunRigCtld: FALSE
RigDevice:
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 1
rigctld started!
Result0:N
Result1:Y
Result2:Y
Connected to localhost:4532
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
2013-12-02 13:38:47
select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0
LoadForm: frmMain
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):786|1077|189|423
TApplication.HandleException Access violation
Stack trace:
$B69576D7
TApplication.HandleException: there was another exception during showing the first exception
Stack trace:
$B709E276
$B70A7233
Killed