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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
