since the version 1.9.1
The function se above give as return follows
--------------------------------------------
ERROR: : Error executing query: Cannot truncate a table referenced in a foreign key constraint (`cqrlog003`.`log_changes`, CONSTRAINT `log_changes_ibfk_1` FOREIGN KEY (`id_cqrlog_main`) REFERENCES `cqrlog003`.`cqrlog_main` (`id_cqrlog_main`))
--------------------------------------------
du you have a idea why???.. in the version 1.9.0 this all run
ufb...
73 de Hans
Hi Hans,
it seems you are using uploading to one or more online logs. Please go to Online logs menu and choose Mark all QSO as uploaded on every online log you are using. It will help.
This problems returned the database because Remove duper function is trying to remove records from cqrlog table that are also in log_changes table.
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Hi I can confirm this error in mysqld 5.5.47 . Apparently TRUNCATE is no longer allowed on tables with foreign key refereces in mysqld >= 5.5 (See https://dev.mysql.com/doc/refman/5.1/en/truncate-table.html)
Seems the fix is to DELETE instead.