http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15086
Bug ID: 15086
Summary: Creators layout and template sql has warnings
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: minor
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: gmcha...@gmail.com
Reporter: mtomp...@hotmail.com
QA Contact: testo...@bugs.koha-community.org
When doing a hacked install:
use ... {koha database name}
truncate creator_layouts;
truncate creator_templates;
truncate printers_profiles;
source installer/data/mysql/... {name of a sample_labels type file}
Warnings are generated, which may not be visible in the UI.
TEST PLAN
---------
(1) Run this BEFORE applying:
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/de-DE/optional/sample_creator_data.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/es-ES/optional/sample_creator_data.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/fr-FR/2-Optionel/sample_labels.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/it-IT/necessari/sample_creator_data.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/nb-NO/2-Valgfritt/sample_creator_data.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/ru-RU/optional/print_labels.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/uk-UA/optional/print_labels.sql
truncate creator_layouts;
truncate creator_templates;
truncate printers_profile;
source installer/data/mysql/en/optional/sample_creator_data.sql
--Notice the warnings
show warnings;
-- Most of them are the:
-/*!40000 ALTER TABLE `creator_layouts` DISABLE KEYS */;
-/*!40000 ALTER TABLE `creator_layouts` ENABLE KEYS */;
In the Russian, the layout_name was truncated, because the layout_name was only
20. An atomic update sql and kohastructure.sql update were provided to widen it
to 25.
(2) Apply the patch
(3) Run the database update
(4) Redo step (1)
-- There should be no warnings or errors
NOTE: fr-FR, ru-RU, and uk-UA were slightly different in structure, so the
structure was made the same as the other files.
--
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
