http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8847 Priority: P5 - low Change sponsored?: --- Bug ID: 8847 Assignee: gmcharlt@gmail.com Summary: Cataloguing doesn't work after installing ru-RU translation Severity: normal Classification: Unclassified OS: Linux Reporter: mopo@front.ru Hardware: PC Status: NEW Version: rel_3_8 Component: Database Product: Koha Created attachment 12612 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=12612&action=edit No cataloguing tool in staff client After installing new Koha 3.8.5 several days ago and installing its translation in russian (ru-RU) several errors are received on the last step of web-installation when I create a koha instance. They look like this: library_item_types.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`branch_item_rules`, CONSTRAINT `branch_item_rules_ibfk_1` FOREIGN KEY (`itemtype`) REFERENCES `koha_test`.`itemtypes` (`itemtype`)) patron_atributes.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`borrower_attributes`, CONSTRAINT `borrower_attributes_ibfk_2` FOREIGN KEY (`code`) REFERENCES `koha_test`.`borrower_attribute_types` (`code`)) patron_categories.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`borrowers`, CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `koha_test`.`categories` (`categorycode`)) print_labels.sql ERROR 1146 (42S02) at line 2: Table 'koha_test.labels_templates' doesn't exist sample_news.sql sample_notices.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`message_transports`, CONSTRAINT `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`, `branchcode`) REFERENCES `koha_test`.`letter` (`module`, `code`, `branchco) sample_user_suggestions.sql unimarc_authorities_CO_general.sql unimarc_authorities_NP_general.sql unimarc_authorities_SAUTTIT_general.sql unimarc_authorities_SAUT_general.sql unimarc_authorities_SCO_general.sql unimarc_authorities_SNC_general.sql unimarc_authorities_SNG_general.sql unimarc_authorities_STU_general.sql unimarc_authorities_TU_general.sql unimarc_default_matching_rules.sql z39-50servers_collection.sql class_sources.sql message_transport_types.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`message_queue`, CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `koha_test`.`message_transport_types` (`message_transport_type`)) permissions_and_user_flags.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`permissions`, CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`) REFERENCES `koha_test`.`userflags` (`bit`)) sample_notices.sql sample_notices_message_attributes.sql ERROR 1701 (42000) at line 1: Cannot truncate a table referenced in a foreign key constraint (`koha_test`.`message_transports`, CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `koha_test`.`message_attributes` (`message_attribute_id`)) sample_notices_message_transports.sql ERROR 1452 (23000) at line 3: Cannot add or update a child row: a foreign key constraint fails (`koha_test`.`message_transports`, CONSTRAINT `message_transports_ibfk_1` FOREIGN KEY (`message_attribute_id`) REFERENCES `message_attributes` (`message_attribute_id`) ON DELETE CASCADE ON UPDA) stopwords.sql subtag_registry.sql system_preferences_full_optimal_for_install_only.sql system_preferences_optimal_values_insert_only.sql unimarc_authorities_DEFAULT_general.sql unimarc_bibliographic_DEFAULT_general.sql unimarc_bibliographic_DEFAULT_local_995.sql But if I chose english as the language of installation all works fine and no errors appear. After this when I log in staff client I realize that there is no "Cataloguing" button and there is nothing on the "Tools" page. I had a previous installation of Koha on other machine, I dumped the database from there and tried to create a new instance using that dump. There was a message about new version of the database, but no errors occured. The instance has been created and the cataloguing tool works as it should work. -- You are receiving this mail because: You are watching all bug changes.