[Koha] Error while creating new label batch

2018-11-26 Thread dnj 
When trying to create a new label batch and filling it with items (either by
barcode or itemnumbers) I'm getting the following error:
WARNING: An error was encountered: Item(s) not added to batch 3. Please have
your system administrator check the error log for details. 

This happens when I'm pasting 1 or more barcodes in the textfield for adding
items. It also happpens if I past 1 or more itemnummbers in that text field.
It's a bit unexpected because I was able to create 1 label batch 1 month
ago, but if I try to use the same procedure now I get the error.

When I check the logs in intranet-error.log I find the following errors
saying there was a problem with inserting the items in the batch in the
database.

[Mon Nov 26 15:42:01.661987 2018] [cgi:error] [pid 10354] [client
192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018]
label-edit-batch.pl: DBD::mysql::st execute failed: Cannot add or update a
child row: a foreign key constraint fails
(`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3`
FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE
CASCADE) [for Statement "INSERT INTO creator_batches (batch_id, item_number,
branch_code, creator) VALUES (?,?,?,?);" with ParamValues: 0='3', 1='230',
2="SH", 3='Labels'] at /usr/share/koha/lib/C4/Creators/Batch.pm line 69.:
/usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer:
http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batch.pl
[Mon Nov 26 15:42:01.662619 2018] [cgi:error] [pid 10354] [client
192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018]
label-edit-batch.pl: Database returned the following error on attempted
INSERT: Cannot add or update a child row: a foreign key constraint fails
(`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3`
FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE
CASCADE) at /usr/share/koha/lib/C4/Creators/Batch.pm line 71.:
/usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer:
http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batch.pl
[Mon Nov 26 15:42:01.664480 2018] [cgi:error] [pid 10354] [client
192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018]
label-edit-batch.pl: DBD::mysql::st execute failed: Cannot add or update a
child row: a foreign key constraint fails
(`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3`
FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE
CASCADE) [for Statement "INSERT INTO creator_batches (batch_id, item_number,
branch_code, creator) VALUES (?,?,?,?);" with ParamValues: 0=3, 1='235',
2="SH", 3='Labels'] at /usr/share/koha/lib/C4/Creators/Batch.pm line 69.:
/usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer:
http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batch.pl
[Mon Nov 26 15:42:01.665053 2018] [cgi:error] [pid 10354] [client
192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018]
label-edit-batch.pl: Database returned the following error on attempted
INSERT: Cannot add or update a child row: a foreign key constraint fails
(`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3`
FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE
CASCADE) at /usr/share/koha/lib/C4/Creators/Batch.pm line 71.:
/usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer:
http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batch.pl
[Mon Nov 26 15:42:01.667071 2018] [cgi:error] [pid 10354] [client
192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018]
label-edit-batch.pl: DBD::mysql::st execute failed: Cannot add or update a
child row: a foreign key constraint fails
(`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3`
FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE
CASCADE) [for Statement "INSERT INTO creator_batches (batch_id, item_number,
branch_code, creator) VALUES (?,?,?,?);" with ParamValues: 0=3, 1='231',
2="SH", 3='Labels'] at /usr/share/koha/lib/C4/Creators/Batch.pm line 69.:
/usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer:
http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batch.pl
[Mon Nov 26 15:42:01.667630 2018] [cgi:error] [pid 10354] [client
192.168.12.12:51964] AH01215: [Mon Nov 26 15:42:01 2018]
label-edit-batch.pl: Database returned the following error on attempted
INSERT: Cannot add or update a child row: a foreign key constraint fails
(`koha_bibliotheek`.`creator_batches`, CONSTRAINT `creator_batches_ibfk_3`
FOREIGN KEY (`item_number`) REFERENCES `itemsOUD` (`itemnumber`) ON DELETE
CASCADE) at /usr/share/koha/lib/C4/Creators/Batch.pm line 71.:
/usr/share/koha/intranet/cgi-bin/labels/label-edit-batch.pl, referer:
http://bibliotheek-admin.sinthendrik.be/cgi-bin/koha/labels/label-edit-batch.pl

Any idea what is going wrong and/or how to solve this?

Thanks in advance!

Jan.





--

Re: [Koha] [Koha-devel] Koha 18.05.06 release

2018-11-26 Thread Tomas Cohen Arazi 
Great job Martin. Thanks!

El lun., 26 de nov. de 2018 13:20, Renvoize, Martin <
martin.renvo...@ptfs-europe.com> escribió:

> The Koha community is proud to announce the release of Koha 18.05.06.
>
> This is my final release as the 18.05.x maintainer, but I will be
> returning next cycle as the next stable (18.11) maintainer. The 18.05.x
> series will live on in the capable hands of Lucas Gass and Jesse Maseto.
>
> This is a maintenance release containing 67 bugfixes
>
> The full release notes are available at
> https://koha-community.org/koha-18-05-06-release/
>
> Debian packages will be updated within a few days
>
> Many thanks to everyone involved,
>
> *Martin Renvoize*
>
> 
>
> Development Team Manager
>
>
>
>
>
> *Phone:* +44 (0) 1483 378728
>
> *Mobile:* +44 (0) 7725 985 636
>
> *Email:* martin.renvo...@ptfs-europe.com
>
> *Fax:* +44 (0) 800 756 6384
>
>
> www.ptfs-europe.com
>
>
>
>
>
>
>
> Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30
>
> The information contained in this email message may be privileged,
> confidential and protected from disclosure. If you are not the intended
> recipient, any dissemination, distribution or copying is strictly
> prohibited. If you think that you have received this email message in
> error, please email the sender at i...@ptfs-europe.com
>
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] keep on page when patrons login

2018-11-26 Thread Eric Phetteplace 
I'd love to see a more general bug as well. This sort of behavior occurs
with all sorts of actions that require authentication (placing a hold,
requesting a purchase, requesting an article, adding to a list). Currently,
we use a work-around in OpacUserJS to store the current page when someone
starts to sign in then redirect them once they land on the user profile
page.

Best,

ERIC PHETTEPLACE

Systems Librarian


libraries.cca.edu | vault.cca.edu | 510.594.3660

5212 Broadway, Oakland, CA 94618

 8th St., San Francisco, CA 94107

Preferred Pronoun(s): he/him

:(){ :|: & };:


On Mon, Nov 26, 2018 at 6:53 AM Myka Kennedy Stephens <
mksteph...@lancasterseminary.edu> wrote:

> Hugo - have you submitted this as a bug yet? If so, would you mind sharing
> the bug #?
>
> We'd like to see an enhancement to the Koha login redirects that is more
> universal for different types of logins, especially Oauth2. Our students
> and faculty use Oauth2 to login to Koha and the Oauth2 login always
> redirects to the patron account page. This has prevented us from being able
> to deploy Oauth2 for logging in to self-checkout, and it creates extra
> clicks and back-tracking for our users when they are trying to authenticate
> into an electronic resource via Koha and didn't log in to Koha first.
>
> This might need to be a separate bug since it relates to Oauth2, but
> perhaps whatever enhancement is made to the Koha login redirects could make
> it easier to then apply an enhancement to Oauth2 and other types of logins
> used by Koha.
>
> Just a thought.
> Myka
>
> On Thu, Nov 22, 2018 at 8:40 AM Tomas Cohen Arazi 
> wrote:
>
> > You are right :-D
> >
> > El jue., 22 nov. 2018 a las 5:19, Hugo Agud () escribió:
> >
> > > Good morning to all
> > >
> > > Before open a bug on bugzilla, we have a behaviour at koha that
> although
> > it
> > > is logical it can't be desirable.
> > >
> > > When a un logged patron do a search on koha and get results, if he wish
> > to
> > > create a list, it is mandatory to log in, but when it does it goes to
> > > account page and looses the search he has done.
> > >
> > > On other systems I have seen a conf that admin can decide what happens
> > when
> > > a user login if he stays or goes to myaccount page, but I think thre is
> > no
> > > syspref on admin for that, right?
> > >
> > > Am I  right?
> > >
> > > thanks you in advance
> > >
> > > --
> > >
> > > *Hugo Agud - Orex Digital *
> > >
> > > *www.orex.es *
> > >
> > >
> > > [image: www.orex.es/koha] <
> > > http://www.orex.es/koha>
> > >[image: www.orex.es/vufind] 
> > >
> > >
> > > Director
> > >
> > > Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 -
> > Barcelona
> > > - Tel: 933 856 138   ha...@orex.es · http://www.orex.es/
> > >
> > >
> > >
> > > No imprima este mensaje a no ser que sea necesario. Una tonelada de
> papel
> > > implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
> > >
> > >
> > >
> > > Aviso de confidencialidad
> > > Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
> > > RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
> > > está autorizado a recibirlo por el remitente), no está autorizado a
> > copiar,
> > > reenviar o divulgar el mensaje o su contenido. Si ha recibido este
> > mensaje
> > > por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
> > > sistema.
> > > ___
> > > 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 (http://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
> >
>
>
> --
> Deaconess Myka Kennedy Stephens, MDiv, MSLIS
> Seminary Librarian and Assistant Professor of Theological Bibliography
> Lancaster Theological Seminary
> 555 West James Street
> Lancaster, PA 17603
> 717-290-8704
> mksteph...@lancasterseminary.edu
> https://library.lancasterseminary.edu
> ___
> 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

[Koha] Koha 18.05.06 release

2018-11-26 Thread Renvoize, Martin 
The Koha community is proud to announce the release of Koha 18.05.06.

This is my final release as the 18.05.x maintainer, but I will be returning
next cycle as the next stable (18.11) maintainer. The 18.05.x series will
live on in the capable hands of Lucas Gass and Jesse Maseto.

This is a maintenance release containing 67 bugfixes

The full release notes are available at
https://koha-community.org/koha-18-05-06-release/

Debian packages will be updated within a few days

Many thanks to everyone involved,

*Martin Renvoize*



Development Team Manager





*Phone:* +44 (0) 1483 378728

*Mobile:* +44 (0) 7725 985 636

*Email:* martin.renvo...@ptfs-europe.com

*Fax:* +44 (0) 800 756 6384


www.ptfs-europe.com







Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30

The information contained in this email message may be privileged,
confidential and protected from disclosure. If you are not the intended
recipient, any dissemination, distribution or copying is strictly
prohibited. If you think that you have received this email message in
error, please email the sender at i...@ptfs-europe.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha 17.11.12 release

2018-11-26 Thread Fridolin SOMERS 

The Koha community is proud to announce the release of Koha 17.11.12.

This is a maintenance release.

The full release notes are available at 
https://koha-community.org/koha-17-11-12-release/


Debian packages will be upgraded in a few days.

Regards,

--
Fridolin SOMERS 
BibLibre, France - software and system maintainer
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] keep on page when patrons login

2018-11-26 Thread Myka Kennedy Stephens 
Hugo - have you submitted this as a bug yet? If so, would you mind sharing
the bug #?

We'd like to see an enhancement to the Koha login redirects that is more
universal for different types of logins, especially Oauth2. Our students
and faculty use Oauth2 to login to Koha and the Oauth2 login always
redirects to the patron account page. This has prevented us from being able
to deploy Oauth2 for logging in to self-checkout, and it creates extra
clicks and back-tracking for our users when they are trying to authenticate
into an electronic resource via Koha and didn't log in to Koha first.

This might need to be a separate bug since it relates to Oauth2, but
perhaps whatever enhancement is made to the Koha login redirects could make
it easier to then apply an enhancement to Oauth2 and other types of logins
used by Koha.

Just a thought.
Myka

On Thu, Nov 22, 2018 at 8:40 AM Tomas Cohen Arazi 
wrote:

> You are right :-D
>
> El jue., 22 nov. 2018 a las 5:19, Hugo Agud () escribió:
>
> > Good morning to all
> >
> > Before open a bug on bugzilla, we have a behaviour at koha that although
> it
> > is logical it can't be desirable.
> >
> > When a un logged patron do a search on koha and get results, if he wish
> to
> > create a list, it is mandatory to log in, but when it does it goes to
> > account page and looses the search he has done.
> >
> > On other systems I have seen a conf that admin can decide what happens
> when
> > a user login if he stays or goes to myaccount page, but I think thre is
> no
> > syspref on admin for that, right?
> >
> > Am I  right?
> >
> > thanks you in advance
> >
> > --
> >
> > *Hugo Agud - Orex Digital *
> >
> > *www.orex.es *
> >
> >
> > [image: www.orex.es/koha] <
> > http://www.orex.es/koha>
> >[image: www.orex.es/vufind] 
> >
> >
> > Director
> >
> > Avda Josep Tarradelles, 134 (Centro de Negocios Infanta) 08029 -
> Barcelona
> > - Tel: 933 856 138   ha...@orex.es · http://www.orex.es/
> >
> >
> >
> > No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
> > implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
> >
> >
> >
> > Aviso de confidencialidad
> > Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
> > RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
> > está autorizado a recibirlo por el remitente), no está autorizado a
> copiar,
> > reenviar o divulgar el mensaje o su contenido. Si ha recibido este
> mensaje
> > por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
> > sistema.
> > ___
> > 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 (http://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
>


-- 
Deaconess Myka Kennedy Stephens, MDiv, MSLIS
Seminary Librarian and Assistant Professor of Theological Bibliography
Lancaster Theological Seminary
555 West James Street
Lancaster, PA 17603
717-290-8704
mksteph...@lancasterseminary.edu
https://library.lancasterseminary.edu
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Embedding reviews from Flipgrid

2018-11-26 Thread Charlotte Stock 
We are keen to display video reviews alongside the entry for the reviewed
title, using Flipgrid. Would anyone be willing to share an example of how
they have incorporated Flipgrid in this way, and an outline of the process
involved?

Thanks
Charlotte

-- 
* Charlotte Stock, Digital Librarian *

-- 





*Halcyon London International School*

33 Seymour Place, London W1H 
5AU

+44 (0)20 7258 1169
 



 




 

 

 

 



-- 


+44 (0)20 7258 1169



*Halcyon London International School*

33 Seymour 
Place, London, W1H 5AU, UK



 



 




 
 
  







If you receive this email by mistake, please let us know and/or delete it. 
Please do not forward it. We believe that it is free of viruses, but even 
so we cannot be responsible for any electronic infection that it may have 
acquired.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha