Deleting duplicates

6 posts / 0 new
Last post
VK4JAZ
Deleting duplicates

Hi, How do I go about deleting duplicate records from my log? I have uploaded a log from another logging program and there are now many duplicates in my CQRLog. Can't see an easy way in the manual.
Regards and Happy New Year.

Grant VK4JAZ

la4vga
re:deleting duplicates

Hello Grant.
Open the SQL-console (by first opening QSO-list CTRL-O, menu-filter,sql-console)

Enter the query:
select callsign,qsodate,time_on,band,mode,count(*) Number_of_records from cqrlog_main group by qsodate,time_on,callsign,band,mode having count(*)> 1
and execute it.

This will show You the records where the callsign,qso-date/time/band/mode are the same (dupes).
You can then sort Your log, or filter each callsign, and manually delete the lines needed.

It is possible to make a script delete dupes, but I will let the author do it his way in a later version.

73 de Børge/LA4VGA

g0etp
v1.7.4 error message when trying to remove duplicates

ERROR::Error execting 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`))
 
I have not managed to try a newer version owing to there not being one for my distribution (Mint 13). Will I have to build a binary? The downloadable binary for 1.9.0 has failed dependencies on Mint 13.
 
Many thanks
Tim G0ETP.
 

kf4cq
same problem here

any help on dupes ????
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`))

Frank
KF4CQ

oh7jha
Same problem here

Same notice as KF4CQ. 1.9.0 CQRLog in use.

ok2cqr
ok2cqr's picture
Re: Deleting duplicates

Hi,
 
please open QSO list window, go to Online logs menu and click to Mark QSO as uploaded to all logs. That should help. It's a bug, there shouldn't be this error message.
 
73 Petr