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

Katrin Fischer <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #21567|0                           |1
        is obsolete|                            |

--- Comment #5 from Katrin Fischer <[email protected]> ---
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 <[email protected]>
Signed-off-by: Katrin Fischer <[email protected]>
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to