Bug 8847

Created attachment 12612 [details]
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.