[Koha] new authorized value for damaged: tinyint vs int

Katrin Fischer katrin.fischer.83 at web.de
Tue Jul 31 03:35:32 NZST 2018


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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha



More information about the Koha mailing list