[Koha-bugs] [Bug 15086] New: Creators layout and template sql has warnings

[bugzilla-daemon at bugs.koha-community.org]

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: gmcharlt at gmail.com
          Reporter: mtompset at hotmail.com
        QA Contact: testopia at 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.