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.
Created attachment 3007 [details] [review] Patch
Revised original patch thanks to Ian Walls: update kohatructure.sql. Copied the change in deleteditems as well.
Created attachment 3010 [details] [review] Revised patch
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
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
Pushed, please test and mark resolved
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 ;)