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

2018-05-22 Thread 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 > 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=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 > 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/1.1" 200 78332

"https://library-intra.example.com/cgi-bin/koha/cataloguing/additem.pl?op=edititem=36948=51602=;

"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/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

> >> 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
> ca...@genac.org 
>
>
>  ___
>     Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz 
>
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 
Héctor González

ca...@genac.org 

___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha



-- 
Héctor González

ca...@genac.org 



--
Héctor González
ca...@genac.org

___
Koha mailing list  http://koha-community.org

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

2018-05-22 Thread Jonathan Druart 
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  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=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  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/1.1" 200 78332
>> "
>> https://library-intra.example.com/cgi-bin/koha/cataloguing/additem.pl?op=edititem=36948=51602=;
>>
>> "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/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 > > > 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
>> > ca...@genac.org 
>> >
>> > ___
>> > Koha mailing list http://koha-community.org
>> > Koha@lists.katipo.co.nz 
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>>
>> --
>> Héctor González
>> ca...@genac.org
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
> --
> Héctor Gonzálezca...@genac.org
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

2018-05-22 Thread Hector Gonzalez 
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=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 > 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/1.1" 200
78332

"https://library-intra.example.com/cgi-bin/koha/cataloguing/additem.pl?op=edititem=36948=51602=;

"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/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 
> >> 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
> ca...@genac.org  >
>
>     ___
>     Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz 
>
> https://lists.katipo.co.nz/mailman/listinfo/koha
>

-- 
Héctor González

ca...@genac.org 

___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha



--
Héctor González
ca...@genac.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

2018-05-22 Thread Jonathan Druart 
On /admin/itemtypes.pl?op=add_form=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  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/1.1" 200 78332
> "
> https://library-intra.example.com/cgi-bin/koha/cataloguing/additem.pl?op=edititem=36948=51602=;
>
> "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/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  > > 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
> > ca...@genac.org 
> >
> > ___
> > Koha mailing list http://koha-community.org
> > Koha@lists.katipo.co.nz 
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
> --
> Héctor González
> ca...@genac.org
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

2018-05-22 Thread Hector Gonzalez 

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/1.1" 200 78332 
"https://library-intra.example.com/cgi-bin/koha/cataloguing/additem.pl?op=edititem=36948=51602=; 
"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/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 > 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

ca...@genac.org 

___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha



--
Héctor González
ca...@genac.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

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

2018-05-21 Thread Hector Gonzalez 
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
ca...@genac.org

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha