Bug 24694

Summary: Installing the sample data produces some errors
Product: Koha Reporter: paxed <pasi.kallinen>
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: minor    
Priority: P5 - low CC: gmcharlt
Version: Main   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description paxed 2020-02-20 08:33:25 UTC
Getting the following errors when installing the default sample data:

sample_holidays.sql
[Thu Feb 20 08:26:09 2020] install.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha`.`repeatable_holidays`, CONSTRAINT `repeatable_holidays_ibfk_1` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE)

message_transport_types.sql
[Thu Feb 20 08:26:07 2020] install.pl: DBD::mysql::st execute failed: Duplicate entry 'email' for key 'PRIMARY'

sample_notices_message_attributes.sql
[Thu Feb 20 08:26:10 2020] install.pl: DBD::mysql::st execute failed: Duplicate entry '1' for key 'PRIMARY' 

sample_notices_message_transports.sql
[Thu Feb 20 08:26:10 2020] install.pl: DBD::mysql::st execute failed: Duplicate entry '1-email-0' for key 'PRIMARY'
Comment 1 Katrin Fischer 2020-09-13 10:41:29 UTC

*** This bug has been marked as a duplicate of bug 26447 ***