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