https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16631 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |additional_work_needed CC| |jonathan.druart@gmail.com --- Comment #186 from Jonathan Druart <jonathan.druart@gmail.com> --- Koha_Main_MariaDB_update is failing, see https://jenkins.koha-community.org/view/main/job/Koha_Main_MariaDB_update/23...
-- 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.