Bug 10969

Summary: Fix sample itemtypes for translated installers
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: Installation and upgrade (web-based installer)Assignee: Katrin Fischer <katrin.fischer>
Status: CLOSED FIXED QA Contact: Paul Poulain <paul.poulain>
Severity: blocker    
Priority: P5 - low CC: bgkriegel, gmcharlt, mathsabypro, paul.poulain, tomascohen
Version: master   
Hardware: All   
OS: All   
See Also: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10965
Change sponsored?: --- Patch complexity: Small patch
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on: 10513    
Bug Blocks:    
Attachments: Bug 10969: Fix sample itemtypes for translated installers
[SIGNED-OFF] Bug 10969: Fix sample itemtypes for translated installers
Bug 10969: Fix sample itemtypes for translated installers

Description Katrin Fischer 2013-09-29 16:48:45 UTC
Because of a change in the itemtypes table structure some of the sample files can no longer be loaded correctly. 
Patch applies change from 10965 to the translated itemtype sample files.

To test:
- Install the specific language and run the web installer.
Or:
- Truncate or delete all from the itemtypes table in your database.
- Try to run the complete SQL in the itemtypes sample files.
- Verify the table is filled correctly.
Comment 1 Katrin Fischer 2013-09-29 16:50:14 UTC Comment hidden (obsolete)
Comment 2 Bernardo Gonzalez Kriegel 2013-09-29 19:00:54 UTC Comment hidden (obsolete)
Comment 3 Galen Charlton 2013-10-02 14:37:10 UTC
Marking as release blocker.
Comment 4 Mathieu Saby 2013-10-02 15:51:49 UTC
And what about french db? is it needed too?

Mathieu
Comment 5 Katrin Fischer 2013-10-02 16:04:54 UTC
I checked all languages and French was using a differnt SQL statement.
Comment 6 Mathieu Saby 2013-10-02 18:23:05 UTC
thank you
Comment 7 Paul Poulain 2013-10-20 18:21:41 UTC
PAtch fixing some weird MySQL, nothing specific to say about it, no possible side-effect for existing setup.

passed QA
Comment 8 Paul Poulain 2013-10-20 18:25:07 UTC
Created attachment 22090 [details] [review]
Bug 10969: Fix sample itemtypes for translated installers

To test:
- Install the specific language and run the web installer.
Or:
- Truncate or delete all from the itemtypes table in your database.
- Try to run the complete SQL in the itemtypes sample files.

Verify the table is filled correctly.

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Works for all languages. No koha-qa errors.

Tested removing itemtypes, then loading new file,
and checking on staff.

For de, es, nb, and pl no problems. For ru I disable foreign
keys constraint before TRUNCATE and reenable it afterwards.

Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
Comment 9 Galen Charlton 2013-10-20 18:51:46 UTC
Pushed to master.  Thanks, Katrin!