Database upgrade crash message

3 posts / 0 new
Last post
KD8AZO
Database upgrade crash message

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.

ok2cqr
ok2cqr's picture
Re: 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

KD8AZO
Petr, you're a genius! It

Petr, you're a genius! It worked. Thank you very much.

Dave