[Koha-bugs] [Bug 5377] Database fields too small for multiple ISBN and ISSN
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Feb 20 04:02:48 CET 2014
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5377
Chris Cormack <chris at bigballofwax.co.nz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #25469|0 |1
is obsolete| |
--- Comment #11 from Chris Cormack <chris at bigballofwax.co.nz> ---
Created attachment 25470
-->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=25470&action=edit
Bug 5377 - Database fields too small for multiple ISBN and ISSN
Test Plan:
1) Apply this patch
2) Create a record with 5 ISBNs and 5 ISSNs
3) Create a new report from the following SQL, or execute it from the
mysql console:
SELECT isbn, issn FROM biblioitems ORDER BY biblionumber DESC LIMIT 1
4) Note that all your ISBNs and ISSNs are listed, separated by the pipe
character ( | )
Signed-off-by: Chris Cormack <chris at bigballofwax.co.nz>
This might be slow to run on big databases, because of the 2 index
rebuilds, however it changes no functionality just increases the field
size which is safe enough (we store multiple now already)
--
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list