[Bug 5642] New: Item field serial enumeration (enumchron) should be longer
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 Summary: Item field serial enumeration (enumchron) should be longer Change sponsored?: --- Product: Koha Version: HEAD Platform: All OS/Version: All Status: ASSIGNED Severity: minor Priority: PATCH-Sent Component: Cataloging AssignedTo: m.de.rooy@rijksmuseum.nl ReportedBy: m.de.rooy@rijksmuseum.nl QAContact: koha-bugs@lists.koha-community.org CC: ian.walls@bywatersolutions.com Estimated Hours: 0.0 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. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 --- Comment #1 from M. de Rooy <m.de.rooy@rijksmuseum.nl> 2011-01-20 10:53:32 UTC --- Created attachment 3007 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3007 Patch -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch Status|--- |Needs Signoff -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 --- Comment #2 from M. de Rooy <m.de.rooy@rijksmuseum.nl> 2011-01-20 14:29:25 UTC --- Revised original patch thanks to Ian Walls: update kohatructure.sql. Copied the change in deleteditems as well. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 M. de Rooy <m.de.rooy@rijksmuseum.nl> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #3007|0 |1 is obsolete| | -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 --- Comment #3 from M. de Rooy <m.de.rooy@rijksmuseum.nl> 2011-01-20 14:29:58 UTC --- Created attachment 3010 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=3010 Revised patch -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 --- Comment #4 from MJ Ray (software.coop) <mjr@ttllp.co.uk> 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.h... Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013679.h... Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013681.h... Bug 5642: Item field serial enumeration (enumchron) should be longer http://lists.koha-community.org/pipermail/koha-patches/2011-January/013682.h... -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |nengard@gmail.com Patch Status|Needs Signoff |Signed Off -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 Chris Cormack <chris@bigballofwax.co.nz> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chris@bigballofwax.co.nz Patch Status|Signed Off |Patch Pushed --- Comment #5 from MJ Ray (software.coop) <mjr@ttllp.co.uk> 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.... --- Comment #6 from Chris Cormack <chris@bigballofwax.co.nz> 2011-03-05 07:22:14 UTC --- Pushed, please test and mark resolved -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 --- Comment #7 from M. de Rooy <m.de.rooy@rijksmuseum.nl> 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 ;) -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5642 Nicole C. Engard <nengard@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA Contact for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org