Bug 8847 - Cataloguing doesn't work after installing ru-RU translation
Summary: Cataloguing doesn't work after installing ru-RU translation
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: translate.koha-community.org (show other bugs)
Version: 3.8
Hardware: PC Linux
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-30 10:48 UTC by Dmitry
Modified: 2015-06-04 23:23 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
No cataloguing tool in staff client (125.17 KB, image/jpeg)
2012-09-30 10:48 UTC, Dmitry
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dmitry 2012-09-30 10:48:30 UTC
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.
Comment 1 Owen Leonard 2014-07-16 16:43:01 UTC
I'm going to assume this was a local or transient problem since there have been no comments since the original report.