Have changed to ver 1.7.0. At the same time changed computer. Collected database from old computer which was not on version 1.7.0, but the previous one.
Seems I have some issues with some tables as on start on the new computer I get:
Database upgrade crashed with this error: : Error executing query: Table 'log_changes' already exists
Selecting OK, then CQRLOG starts fine with all log data in place, but the above start error is persistent on all startups.
How can I get rid of the error?
73 de Olaf - LA3RK
PS: CQRLOG is still the best log program for Linux
Mon, 2014-01-20 12:37
#1
Database upgrade crashed
Hi Olaf,
this is very strange. What version did you use on old computer? Please send me the .cqrlog directory or you can try to fix it yourself. Please backup the data first!
Look at this article: http://www.n0nb.us/blog/2011/08/accessing-the-mysql-server-spawned-by-cq...
Start the CQRLOG and let open only database selection window. To the console enter this command:
mysql -S /home/USER/.config/cqrlog/database/sock
where USER is your user name. MySQL command line appears, enter this:
use cqrlog001;
where cqrlog001 is first log in the list, you have to use right number of your log. Next command:
drop table log_changes;
This should drop existing table. Now enter quit; and hit enter. MySQL console will be closed. Close the CQRLOG and run it again. It should work.
Hope this helps.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr
Thanks for suggestions. In fact I had to start cqrlog as you suggested, then open mysql in terminal and drop 2 tables;
- log_changes
- upload_status
After dropping these 2 and then killing cqrlog problem was solved. If I just closed cqrlog normally one of the above files reappeared.
Now cqrlog version 1.7.0 starts normally.
Last version on the other computer was the prev version before 1.7.0.
Lesson learnt; move between computers and not taking care of versions is a bad idea.
73 de Olaf - LA3RK
Olaf Devik LA3RK