gitea
/
Koha-clms
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Koha-clms/misc/maintenance
History
Jonathan Druart 2907d4bf90 Bug 18058: Allow borrower_message_preferences to be truncated 
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 dd88c8f710)
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
(cherry picked from commit e2f860386d)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
 		2017-04-21 11:26:56 +02:00
..
MARC21_utf8_flag_fix.pl Bug 14383: misc: Fix some typos in comments and documentation 2015-06-22 17:34:45 -03:00
UNIMARC_fix_collectiontitle.pl 3040 : seriestitle mistaken as collection title 2009-04-06 09:53:16 -05:00
UNIMARC_sync_date_created_with_marc_biblio.pl Bug 9192: let UNIMARC_sync_date_created_with_marc_biblio.pl create fields if needed 2013-10-23 14:20:14 +00:00
borrowers-force-messaging-defaults Bug 18058: Allow borrower_message_preferences to be truncated 2017-04-21 11:26:56 +02:00
check_sysprefs.sh Bug 8353 follow-up adding a tiny sh in misc/maintenance 2012-07-13 14:42:55 +02:00
cmp_sysprefs.pl Bug 9978: Replace license header with the correct license (GPLv3+) 2015-04-20 09:59:38 -03:00
fix_accountlines_date.pl Bug 14998: Restore previous behavior 2015-11-11 11:07:27 -03:00
fix_accountlines_rmdupfines_bug8253.pl Bug 14870: (followup) Remove superfluous C4::Dates from fix_accountlines_rmdupfines_bug8253.pl 2015-11-19 13:05:06 -03:00
fix_mysql_constraints.pl Bug 9978: Replace license header with the correct license (GPLv3+) 2015-04-20 09:59:38 -03:00
make_zebra_dom_cfg_from_record_abs Bug 9978: (followup) Replace license header with the correct license (GPLv3+) 2015-04-20 09:59:43 -03:00
process_record_through_filter.pl Bug 7417: Include see from references in bibliographic searches 2012-09-13 14:19:28 +02:00
remove_items_from_biblioitems.pl Bug 9978: Replace license header with the correct license (GPLv3+) 2015-04-20 09:59:38 -03:00
sanitize_records.pl Bug 8218: qa followup 2014-11-11 15:39:05 -03:00
touch_all_biblios.pl Bug 9978: Replace license header with the correct license (GPLv3+) 2015-04-20 09:59:38 -03:00
touch_all_items.pl Bug 9978: Replace license header with the correct license (GPLv3+) 2015-04-20 09:59:38 -03:00