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

Re: [Koha] Koha coverflow - no image available

2018-05-22 Thread camilabezerra 
Thank you for your reply, Andreas.
I tried the fix and it didn't work.

Any other suggestions?



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Elastic search

2018-05-22 Thread Nicolas Legrand 
No, not a chance. It's like having a tap not connected to the water supply
network.

2018-05-22 14:17 GMT+02:00 Arshad Iqbal :

> I mean to say without installation of elastic search just enable it in
> system preference and data searching started.
> On May 22, 2018 4:59 PM, "Tomas Cohen Arazi"  wrote:
>
> > What do you mean 'without elastic search configuration'?
> >
> > El mar., 22 de may. de 2018 7:52 a. m., Arshad Iqbal <
> > arshadsan...@gmail.com> escribió:
> >
> >> Hello to all
> >>
> >> Is it possible in current stable version of Koha (17.11.05) to search
> any
> >> bibliograhic data through elastic search without elastic search
> >> configuration?
> >> ___
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> > --
> > Tomás Cohen Arazi
> > Theke Solutions (https://theke.io )
> > ✆ +54 9351 3513384
> > GPG: B2F3C15F
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 

*Nicolas Legrand*
Administration technique et développements du système de gestion de la
bibliothèque

[image: Logo BULAC]

Bibliothèque universitaire
des langues et civilisations

65 rue des Grands Moulins
F-75013 PARIS
T +33 1 81 69 *18 22*
www.bulac.fr
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Elastic search

2018-05-22 Thread Arshad Iqbal 
I mean to say without installation of elastic search just enable it in
system preference and data searching started.
On May 22, 2018 4:59 PM, "Tomas Cohen Arazi"  wrote:

> What do you mean 'without elastic search configuration'?
>
> El mar., 22 de may. de 2018 7:52 a. m., Arshad Iqbal <
> arshadsan...@gmail.com> escribió:
>
>> Hello to all
>>
>> Is it possible in current stable version of Koha (17.11.05) to search any
>> bibliograhic data through elastic search without elastic search
>> configuration?
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> --
> Tomás Cohen Arazi
> Theke Solutions (https://theke.io )
> ✆ +54 9351 3513384
> GPG: B2F3C15F
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Elastic search

2018-05-22 Thread Tomas Cohen Arazi 
What do you mean 'without elastic search configuration'?

El mar., 22 de may. de 2018 7:52 a. m., Arshad Iqbal 
escribió:

> Hello to all
>
> Is it possible in current stable version of Koha (17.11.05) to search any
> bibliograhic data through elastic search without elastic search
> configuration?
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Elastic search

2018-05-22 Thread Arshad Iqbal 
Hello to all

Is it possible in current stable version of Koha (17.11.05) to search any
bibliograhic data through elastic search without elastic search
configuration?
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Proxy Error after MariaDB upgrade to 10.2.14

2018-05-22 Thread JanM 
Hello everyone,

i just ran into a Problem with my Koha System. After upgrading the MariaDB
from 10.0 to 10.2.14 I have no access to the Server. I can not provide the
Version of Koha, but for Apache:

###

Server version: Apache/2.4.18 (Ubuntu)
Server built:   2018-04-18T14:53:04

? apache2.service - LSB: Apache2 web server
   Loaded: loaded (/etc/init.d/apache2; bad; vendor preset: enabled)
  Drop-In: /lib/systemd/system/apache2.service.d
   +-apache2-systemd.conf
   Active: active (running) since Fri 2018-05-11 00:05:38 CEST; 5 days ago
 Docs: man:systemd-sysv-generator(8)
  Process: 62250 ExecReload=/etc/init.d/apache2 reload (code=exited,
status=0/SU
   CGroup: /system.slice/apache2.service
   +-47224 /usr/sbin/apache2 -k start
   +-48517 /usr/sbin/apache2 -k start
   +-48520 /usr/sbin/apache2 -k start
   +-61991 /usr/sbin/apache2 -k start
   +-61996 /usr/sbin/apache2 -k start
   +-62305 /usr/sbin/apache2 -k start
   +-62307 /usr/sbin/apache2 -k start
   +-62310 /usr/sbin/apache2 -k start
   +-62312 /usr/sbin/apache2 -k start
   +-62313 /usr/sbin/apache2 -k start

May 16 09:00:18 www2 systemd[1]: Reloading LSB: Apache2 web server.
May 16 09:00:18 www2 apache2[62250]:  * Reloading Apache httpd web server
apache
May 16 09:00:19 www2 apache2[62250]:  *
May 16 09:00:19 www2 systemd[1]: Reloaded LSB: Apache2 web server.

###

Memcached und Plack is active.

user@www2:~$ sudo koha-plack --start library
 * Error: Plack already running for library 
[fail]

###

If I try to access the Website it takes about 10 Minutes until this
error-page appears:

Proxy Error

The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /index.html.

Reason: Error reading from remote server

Apache/2.4.18 (Ubuntu) Server at www2.testothek.uni-hamburg.de Port 443

Maybe someone can help me out here.

Thanks
Jan 



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Generating Check-out Items from action_log

2018-05-22 Thread Mr Mutsikiwa Admire 

Hi
My old_issue table is empty as I have deleted it while trying to solve 
the problem of DBMS auto increment. I am wondering if it is possible to 
get a list of Checked out books from the action_log table. I am 
interested in the bibliographic information title, author and the time 
the book was checked out. Any pointers would be greatly appreciated.


--

Kind Regards,

Admire Mutsikiwa (Mr)
ICT Manager
Libraries
University of Zimbabwe
Tel:+263-4-303276
Mob:+263782476883

“It is easy to dodge our responsibilities, but we cannot dodge the 
consequences of dodging our responsibilities.”  Josiah Charles Stamp


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