[Koha-bugs] [Bug 31716] Enlarge the size of the authorised_value column in authorised_values

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31716

David Nind <david at davidnind.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |david at davidnind.com

--- Comment #3 from David Nind <david at davidnind.com> ---
I can now update an authorized value code using the database, but I can't add
or edit using the staff interface as the form entry's maximum length is 80:
<input type="text" id="authorised_value" name="authorised_value" value=""
maxlength="80" class="focus" />.

When you do try to edit an entry, you get this message on the edit form "Please
enter no more than 80 characters."

To update a value in the database:

1. koha-mysql kohadev

2. After applying the patch (I also ran dbic - not sure whether that is
required) you can see that the change to the database structure has been
enabled: show columns from authorised_values;

3. SQL to update an entry - where XXXX = the id of an existing entry: update
authorised_values set authorised_value="This is a really really long authorized
value although I am not sure why you would want such a code" where id = XXXX;

-- 
You are receiving this mail because:
You are watching all bug changes.