Ubuntu 18.xxxLTS with cqrlog error on download from LOTW

1 post / 0 new
KC3SWL
KC3SWL's picture
Ubuntu 18.xxxLTS with cqrlog error on download from LOTW

Hi
I was able to use CQRLog with the new Ubuntu install for awhile and then on the last attempted download from LOTW I got this message
TMySQL57Connection : Error executing query: Data too long for column 'loc' at row 1.
I read through some of the forums and I yanked out CQRlog through synaptic which also uninstalled all the mysql programs and reinstalled. Yet I get the very same message.
I also have other Linux distros on a separate drive and that worked just fine.
Just so you know I'm not a coder so some things I may be going uhhhhhhhhhhhh at.
Any ideas would be appreciated
Chris

cqrlog
[DEBUG] Name com.canonical.AppMenu.Registrar does not exist on the session bus

**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

Closing ini file ...
chris@chris-System-Product-Name:~$ cqrlog debug-1

**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.13
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 129403 LoTW users
Loaded 122415 eQSL users
Loaded 36903 SCP calls
*

User home directory: /home/chris/
Program home directory: /home/chris/.config/cqrlog/
Data directory: /home/chris/.config/cqrlog/database/
Memebers directory: /home/chris/.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
[DEBUG] Name com.canonical.AppMenu.Registrar does not exist on the session bus

/usr/sbin/mysqld --defaults-file=/home/chris/.config/cqrlog/database/mysql.cnf --datadir=/home/chris/.config/cqrlog/database/ --socket=/home/chris/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'

SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr