https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16631
Jonathan Druart <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |additional_work_needed CC| |[email protected] --- Comment #186 from Jonathan Druart <[email protected]> --- Koha_Main_MariaDB_update is failing, see https://jenkins.koha-community.org/view/main/job/Koha_Main_MariaDB_update/2369/consoleFull > -- Table structure for table `reports_branches` > -- > > DROP TABLE IF EXISTS `reports_branches`; > /*!40101 SET @saved_cs_client = @@character_set_client */; > /*!40101 SET character_set_client = utf8mb4 */; > CREATE TABLE `reports_branches` ( > `report_id` int(11) NOT NULL, > `branchcode` varchar(10) NOT NULL, > KEY `report_id` (`report_id`), > KEY `branchcode` (`branchcode`), > CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES > `saved_sql` (`id`) ON DELETE CASCADE, > CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES > `branches` (`branchcode`) ON DELETE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > > -- 5962,5974d5978 < ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; < /*!40101 SET character_set_client = @saved_cs_client */; < < DROP TABLE IF EXISTS `reports_branches`; < /*!40101 SET @saved_cs_client = @@character_set_client */; < /*!40101 SET character_set_client = utf8mb4 */; < CREATE TABLE `reports_branches` ( < `report_id` int(11) NOT NULL, < `branchcode` varchar(10) NOT NULL, < KEY `report_id` (`report_id`), < KEY `branchcode` (`branchcode`), < CONSTRAINT `reports_branches_ibfk_1` FOREIGN KEY (`report_id`) REFERENCES `saved_sql` (`id`) ON DELETE CASCADE, < CONSTRAINT `reports_branches_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ERROR - DB structures are not identical 'diff /tmp/current_db.sql /tmp/upgraded_db.sql && diff -q /tmp/current_db.sql /tmp/upgraded_db.sql || { echo "ERROR - DB structures are not identical" && exit 1; }' exited with value 1 at /kohadevbox/misc4dev/run_tests.pl line 310. I think it's because the CREATE TABLE reports_branches is not correctly placed in the kohastructure.sql file -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list -- [email protected] To unsubscribe send an email to [email protected] website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
