Hi Giuseppe, how did you set up your new authorized values for DAMAGED? As you noticed already, items.damaged is a tinyint(1). You need to use numbers as codes for it to work right and be able to store it. Koha uses the authorised_value not the id for referencing. Hope that helps, Katrin On 25.07.2018 07:56, Giuseppe Angilella wrote:
Hi,
I've defined a new authorized value for the DAMAGED category. In my database, this corresponds to id = 256 in the authorised_values table, where id is an int(11).
However, when I try to select that authorized value for a particular item, my choice is not recorded. I noticed that items.damaged is described as tinyint(1). In fact, if I try to update items manually and set 256, this is automatically converted into 127.
How can I solve this problem?
Is it a bug I should report, or rather a database upgrade in my system which did not take place correctly?
Many thanks and best regards,
Giuseppe. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha