CQRLOG - open discusion

Backing up by script - Solved

Submitted by a65dr on

I need to set up regular cqrlog backups (preferably automatic).

The backup on exit doesn't work for me. It is not a priority to fix that because I rarely shutdown/reboot/exit-cqrlog.

I would prefer a backup method that allows me to automate a backup, maybe by middle of the night cron job, or similar.

I have tried this suggestion:

paul@paul:~$ (/usr/bin/mysql -B -N -e 'show databases like "cqr%"' | /usr/bin/xargs /bin/echo -n mysqldump --databases) > /tmp/mycqrlogsdump.sql

Which resulted in:

Forums: 

SOLVED - Cannot delete dupes from log

Submitted by a65dr on

Good day all.
After mistakenly importing my main backup adi file (instead of exporting it) I have 37k dupes in my log.
I tried the delete dupes from QSO window file menu but get this error:

----------------------------
ERROR: : Error executing query: Cannot truncate a table referenced in a foreign key constraint (`cqrlog001`.`log_changes`, CONSTRAINT `log_changes_ibfk_1` FOREIGN KEY (`id_cqrlog_main`) REFERENCES `cqrlog001`.`cqrlog_main` (`id_cqrlog_main`))
----------------------------

Forums: 

Add US States to existing records

Submitted by km6cg on

I am using 2.4.0 as packaged by Fedora 31.

I have a few logbook databases that were accumulated before I configured callbook support. These do not have a state filled into the state field. Is there any way to re-tag them now that I have callbook support enabled?

We're probably talking under 100 contacts, but more than 50.

Thanks,
Ed Greenberg
AE2Z

Forums: 

Upload to qrz.com

Submitted by DF2ET on

Hi guys,

I have spent some time and implemented a function to upload QSO data to qrz.com logbook (similar to hamQTH, hrdlog, etc.).
This can basically upload to qrz.com. The thing is it cannot delete/update QSOs because that requires an individual log ID that you get when you upload the QSO data to qrz.com.
I am thinking about storing that ID into CQRlog's database in order to be able to delete(or update aka. delete and re-enter) the QSO from the qrz.com logbook later. What do the developers think about this?

My changes (no doc yet) are here:

Forums: 

Database corrupted, reimport ok but still some mysql.err entries

Submitted by dl1mtg on

Hello CQRLOG,

yesterday I switched from MySQL- to MariaDB-Server.
All was okay. CQRLOG was working.

Later the day I checked "mysql.err" again - some strange messages in there.

I solved this doing reinstall from backup (settings and adif).
Then all was okay again.

Just some messages are still there:

Forums: 

GPIO Pins to PTT

Submitted by KF4DRR on

This may not be the right forum, and if it isn't I apologize, but if I want the PI4 to key the radio via the GPIO pins (say pin 17) when running digital modes what values do I put in here?

this thread
https://github.com/Hamlib/Hamlib/issues/48
suggests that
sudo rigctld -P GPIO -p 17
would achieve what I want from CLI but how to incorporate that into CQRlog's setup?

Forums: 

Pages

Subscribe to RSS - CQRLOG - open discusion