[Koha-bugs] [Bug 18058] New: 'borrowers-force-messaging-defaults --doit --truncate ' gives DBI error

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: mtj at kohaaloha.com
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at 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.