https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16631
--- Comment #188 from Casey Conlin - mattermost @Casey246 <[email protected]> --- (In reply to Jonathan Druart from comment #186) > 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 That link isn't working for me, but that could be because I took too long getting back to this or I don't have permissions. I can't reproduce the issue locally, but it could be that the reports_branches table was being created before the saved_sql table it references. I moved reports_branches to after saved_sql, so hopefully this resolves the issue. If possible, please point me to some info on how I could test this locally or on Jenkins. Thanks! -- 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/
