Bug 5642 - Item field serial enumeration (enumchron) should be longer
Summary: Item field serial enumeration (enumchron) should be longer
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Cataloging (show other bugs)
Version: Main
Hardware: All All
: PATCH-Sent (DO NOT USE) minor (vote)
Assignee: Marcel de Rooy
QA Contact: Bugs List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-20 10:47 UTC by Marcel de Rooy
Modified: 2012-10-25 23:03 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Patch (1.44 KB, patch)
2011-01-20 10:53 UTC, Marcel de Rooy
Details | Diff | Splinter Review
Revised patch (2.57 KB, patch)
2011-01-20 14:29 UTC, Marcel de Rooy
Details | Diff | Splinter Review

Note You need to log in before you can comment on or make changes to this bug.
Description Marcel de Rooy 2011-01-20 10:47:23 UTC
Field enumchron in items table is now varchar(80).
We have records that need a much longer field, even up to 400 or 500 chars.
I suggest to change its type to TEXT (variable length with max 64K; tinytext goes up to 255 chars and is just too short).
Mediumtext or longtext are not needed; as a side note these types are used in the items table for e.g. booksellerid and more_subfields_xml..

Patch sent.
Comment 1 Marcel de Rooy 2011-01-20 10:53:32 UTC Comment hidden (obsolete)
Comment 2 Marcel de Rooy 2011-01-20 14:29:25 UTC
Revised original patch thanks to Ian Walls: update kohatructure.sql. Copied the change in deleteditems as well.
Comment 3 Marcel de Rooy 2011-01-20 14:29:58 UTC
Created attachment 3010 [details] [review]
Revised patch
Comment 4 MJ Ray (software.coop) 2011-02-02 08:52:06 UTC
This bug is mentioned in:
Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013678.html
Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013679.html
Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013681.html
Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013682.html
Comment 5 MJ Ray (software.coop) 2011-03-03 08:37:14 UTC
This bug is mentioned in:
Bug 5642: Item field serial	enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-February/013956.html
Comment 6 Chris Cormack 2011-03-05 07:22:14 UTC
Pushed, please test and mark resolved
Comment 7 Marcel de Rooy 2011-03-07 09:25:14 UTC
Works for me. I ran a new install too and the fields have been created correctly.
Nicole, could you close it if OK (thanks for signoff, btw)? If I would do that, Chris will not be happy ;)