[Koha-bugs] [Bug 10965] Sample itemtypes can't load on new install

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10965

--- Comment #1 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
Created attachment 21551
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21551&action=edit
Bug 10965 - Sample itemtypes can't load on new install

Bug 10513 added two columns to table itemtypes,
but sample_itemtypes can't be loaded because
it relies on old structure.

This patch rewrites sample_itemtypes.sql, stating
explicitly columns, removing backticks and consolidates
all in one insertion.

To test:
1) On master with current DB structure, delete item types

2) try loading sample_itemtyes.sql
It fails with "ERROR 1136 (21S01) at line 1: Column count doesn't match value
count at row 1"

3) apply patch

4) try again, this time it will load and itemtypes created

-- 
You are receiving this mail because:
You are watching all bug changes.