[Koha] How do I change an item's type?

[Hector Gonzalez]

Thank you, it seems this is a mixture of all that.  We have both 
items.itype, and biblioitems.itemtype set, but with different values, 
one is VM, whichdoes not exist, and the other is PELIC, which is 
"movie", so it seems the modification is happening, but is not 
readable.  I'll make a backup, and change the nonexisten item types with 
SQL and see ifthis helps.

The test system is in english, but the install was made in spanish, and 
the framework is in spanish, that's why I see that form translated.  I 
removed the language, but the translations are part of the database now.

Thanks for your help.


On 05/22/2018 03:13 PM, Jonathan Druart wrote:
> Sorry, my previous answer was completely off topic.
>
> You should try with the English interface (not translated).
> If it works, it means there is a translation issue, if it still does 
> not work it is certainly a data problem, double check the value  in 
> your database (items.itype or biblioitems.itemtype, depending on the 
> pref).
> I have tested on 17.05.11 with the sample data and it seems ok.
>
> On Tue, 22 May 2018 at 16:55 Hector Gonzalez <cacho at genac.org 
> <mailto:cacho at genac.org>> wrote:
>
>     No, what I'm trying to do is to change the type of an existing
>     item, that was catalogued as a book, and it should be a movie now.
>
>     I search for the item, click on edit, change "y - tipo de item
>     Koha"  (I have the interface set to english, but this form is
>     shown in spanish)  it also does not show the original value, it is
>     blank.  I change it to "Movie", and click save.
>
>     The item type remains unchanged.
>
>
>     On 05/22/2018 01:53 PM, Jonathan Druart wrote:
>>     On /admin/itemtypes.pl?op=add_form&itemtype=BK
>>     <http://itemtypes.pl?op=add_form&itemtype=BK>
>>     I changed the description from "Book" to "Movie" and it is saved
>>     correctly.
>>     Is it what you are trying to do?
>>
>>     On Tue, 22 May 2018 at 15:47 Hector Gonzalez <cacho at genac.org
>>     <mailto:cacho at genac.org>> wrote:
>>
>>         Sorry, I did not copy to the list:
>>
>>         Yes there are some lines in the logs, but I don't know what
>>         to make of
>>         them, these are the messages when I click save:
>>
>>         ==> plack-error.log <==
>>         DBIx::Class::Storage::DBI::select_single(): Query returned
>>         more than one
>>         row.  SQL that returns multiple rows is DEPRECATED for ->find
>>         and
>>         ->single at /usr/share/koha/lib/Koha/Objects.pm line 92
>>
>>         ==> plack.log <==
>>         192.168.10.54 - - [22/May/2018:13:33:56 -0500] "POST
>>         /intranet/cataloguing/additem.pl <http://additem.pl>
>>         HTTP/1.1" 200 78332
>>         "https://library-intra.example.com/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=36948&itemnumber=51602&searchid="
>>
>>         "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML,
>>         like Gecko)
>>         Chrome/65.0.3325.183 Safari/537.36 Vivaldi/1.96.1147.36"
>>
>>         ==> intranet-access.log <==
>>         192.168.10.54 - - [22/May/2018:13:33:55 -0500] "POST
>>         /cgi-bin/koha/cataloguing/additem.pl <http://additem.pl>
>>         HTTP/1.1" 200 11789
>>
>>         And I messed the version, is 17.05.11  But I also tested this
>>         with
>>         17.11.05 (a full copy of the catalog), and it shows nearly
>>         the same, the
>>         intranet-access.log is missing there.
>>
>>         thanks.
>>
>>         On 05/22/2018 09:34 AM, Jonathan Druart wrote:
>>         > Do you see something in the logs?
>>         >
>>         > On Mon, 21 May 2018 at 20:03 Hector Gonzalez
>>         <cacho at genac.org <mailto:cacho at genac.org>
>>         > <mailto:cacho at genac.org <mailto:cacho at genac.org>>> wrote:
>>         >
>>         >     Hi, I'm trying to change an items type, from "Book" to
>>         "Movie",
>>         >     but Koha
>>         >     won't do it.
>>         >
>>         >     This is with koha 17.11.05, running on debian stretch
>>         with mariadb,
>>         >     plack and memcached.  It doesn't show any error
>>         messages, it just
>>         >     ignores the action.
>>         >
>>         >     Is this a known bug?
>>         >
>>         >     --
>>         >     Héctor González
>>         > cacho at genac.org <mailto:cacho at genac.org>
>>         <mailto:cacho at genac.org <mailto:cacho at genac.org>>
>>         >
>>         >  _______________________________________________
>>         >     Koha mailing list http://koha-community.org
>>         > Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>>         <mailto:Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>>
>>         > https://lists.katipo.co.nz/mailman/listinfo/koha
>>         >
>>
>>         -- 
>>         Héctor González
>>         cacho at genac.org <mailto:cacho at genac.org>
>>
>>         _______________________________________________
>>         Koha mailing list http://koha-community.org
>>         Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>>         https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>     -- 
>     Héctor González
>     cacho at genac.org <mailto:cacho at genac.org>
>

-- 
Héctor González
cacho at genac.org