e2f860386d
borrower_message_preferences cannot be truncated because of the foreign.
DBMS fails with
"Cannot truncate a table referenced in a foreign key constraint"
To avoid that we should remove the FK check and truncate the other table
as well.
I am wondering if we really need a truncate here
DELETE FROM borrower_message_preferences;
should do the job, but leave it as it because of the param name.
Test plan
perl misc/maintenance/borrowers-force-messaging-defaults --doit --truncate
Should no longer raise the error message
Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit
|
||
|---|---|---|
| .. | ||
| UNIMARC_fix_collectiontitle.pl | ||
| UNIMARC_sync_date_created_with_marc_biblio.pl | ||
| borrowers-force-messaging-defaults | ||
| check_sysprefs.sh | ||
| cmp_sysprefs.pl | ||
| fix_accountlines_date.pl | ||
| fix_accountlines_rmdupfines_bug8253.pl | ||
| fix_mysql_constraints.pl | ||
| make_zebra_dom_cfg_from_record_abs | ||
| process_record_through_filter.pl | ||
| remove_items_from_biblioitems.pl | ||
| sanitize_records.pl | ||
| touch_all_biblios.pl | ||
| touch_all_items.pl | ||