[Koha-bugs] [Bug 10965] Sample itemtypes can't load on new install
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sun Sep 29 18:27:57 CEST 2013
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10965
Katrin Fischer <katrin.fischer at bsz-bw.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #21567|0 |1
is obsolete| |
--- Comment #5 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
Created attachment 21597
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21597&action=edit
[PASSED QA] 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
Signed-off-by: Chris Cormack <chris at bigballofwax.co.nz>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83 at web.de>
SQL change only.
Tested by running the web installer on an empty database.
All sample data loads without errors.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list