Bug 10965: fix breakage when loading sample itemtypes during install
authorBernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Sat, 28 Sep 2013 19:24:50 +0000 (16:24 -0300)
committerGalen Charlton <gmc@esilibrary.com>
Wed, 2 Oct 2013 14:35:44 +0000 (14:35 +0000)
commit090ba4902cbd04634caa5fd507a2672b0987d795
tree3562b139603ee97e9054f513f7dfab1123597497
parent561107bb5b348eaa14054e3470f39ff9cf080d22
Bug 10965: fix breakage when loading sample itemtypes during 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@bigballofwax.co.nz>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
SQL change only.
Tested by running the web installer on an empty database.
All sample data loads without errors.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
installer/data/mysql/en/optional/sample_itemtypes.sql