The middle of last Dec., I found that my CQRlog did not export , or etc to adif.(Also Ubuntu 18.04.3)
I decide to install Ubuntu 18.04.3 into an another SSD.
On the new SSD, I installed CQRlog 126.96.36.199 deb.
Now in the QSOlist, I have lost "Comment to QSO" column.
And when I search by DXCC, I input e.x. 5B, the error occurred.
TMySQL57Connection: Error executing query: Unknown column 'dxcc_ref' in 'where clause'.
Then I tried according to https://www.cqrlog.com/node/2340
$ mysql -S ~/.config/cqrlog/database/sock
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.1.43-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use cqrlog001;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
MariaDB [cqrlog001]> alter table freqmem add info varchar(25) null;
ERROR 1060 (42S21): Duplicate column name 'info'
How must I coorect "Duplicate column name 'info'" ?
Former SSD has in /home/NAME/.config/cqrlog/database/mysql.err:
2019-12-30T02:08:59.668280Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2019-12-30T02:08:59.668321Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist