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

[Giuseppe Angilella]

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
***@lists.katipo.co.nz
https://lis

[Katrin Fischer]

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

Post by Giuseppe Angilella
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
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katipo.co.nz/ma