https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18058 Bug ID: 18058 Summary: 'borrowers-force-messaging-defaults --doit --truncate ' gives DBI error Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt@gmail.com Reporter: mtj@kohaaloha.com QA Contact: testopia@bugs.koha-community.org CC: robin@catalyst.net.nz here's the error on a 16.05.09 pkg install # koha-shell -c ' perl /usr/share/koha/bin/maintenance/borrowers-force-messaging-defaults --doit --truncate ' demo DBD::mysql::st execute failed: Cannot truncate a table referenced in a foreign key constraint (`koha_demo`.`borrower_message_transport_preferences`, CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `koha_demo`.`borrower) [for Statement "TRUNCATE borrower_message_preferences"] at /usr/share/koha/bin/maintenance/borrowers-force-messaging-defaults line 52. note: i haven't confirmed this on newer versions, yet -- You are receiving this mail because: You are watching all bug changes.