Bug 8002 [SIGNED-OFF][REVISED] Can't add patron attribute type in newer installation
authorOwen Leonard <oleonard@myacpl.org>
Tue, 24 Apr 2012 15:20:42 +0000 (11:20 -0400)
committerChris Cormack <chrisc@catalyst.net.nz>
Mon, 7 May 2012 21:34:10 +0000 (09:34 +1200)
commit3a22e06c1b08965d5cb0596eb94c38b6397a502c
treee13e848fa2ca48c5a876098875630beb3f027065
parent60fe518c6299c7ea079e17d1ad6373b72bad1b2d
Bug 8002 [SIGNED-OFF][REVISED] Can't add patron attribute type in newer installation

Correcting patron_attributes_types definition in kohastructure.sql
to allow NULL entries for category_code, matching the definition
specified in updatedatabase.pl. Adds an entry to updatedatabase.pl
to correct existing installations with the incorrect table structure.

After running the updated updatedatabase.pl the category_code
column in borrower_attribute_types should show that it allows
NULL entries. Adding a new patron attribute type with no
patron category specified should work correctly.

To test the update to kohastructure.sql: Back up your Koha
database, drop it, and recreate it. Load the staff interface
and go through the web installer. After recreating the database
enable ExtendedPatronAttributes and try adding a new patron
attribute type with no patron category specified. The operation
should be successful.

signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
a new update for installations affected.

Signed-off-by: Paul Poulain <paul.poulain@biblibre.com>
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl