Hello All. I recently installed Linux Mint KDE and when I installed CQRLOG and started it I get the messsage "Database upgrade crashed with this error: Error executing query: Duplicate column name 'upddeleted'". I click OK on that screen and CQRLog loads to the main New QSO screen then I get a popup that says "List index (11) out of bounds. Presss OK to ignore and risk data corruptioon....." Is this a problem with the myqsl database, or the one that replaced it (Maria something) and how do I fix it? Thanks in advance.
Petr, I read your message to Olaf LA3RK, went in and edited the sock file and put in "use cqrlog001;", which got rid of the "List index (11) out of bounds." error. I also tried, in terminal, the 'myqsl -S' and 'drop table log_changes' commands but terminal didn't recognize them. Any suggestions? Than you.
Mon, 2014-08-11 15:19
#1
Database upgrade crash message
Hi,
There is small howto. Open CQRLOG.
Please open the terminal and enter this command:
mysql -S /home/ok2cqr/.config/cqrlog/database/sock where ok2cqr is my user name.
Mysql console appears. Now enter these commands:
use cqrlog001; where cqrlog001 means you are using database nr 1,
update db_version set nr=9;
quit;
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr, you're a genius! It worked. Thank you very much.
Dave