[Koha] Duplicate entry in old_reserves

[Hugo Agud]

Hi

We have seen this when we have migrated data from another ils, the issue
has an auto-incremental id, but old_issues copy the id from the issues, I
guess that perhaps it is the same with reserves and old_reserves.

then the question is, have you migrated koha from another ILS and you have
migrated historical data on reserves? If yes.. that it should be the answer

2017-01-31 18:16 GMT+01:00 Tim McMahon <tmcmahon at wlpl.org>:

> I got an internal server error while checking out a reserved item to a
> patron.
>
> The plack-error.log showed this error:
>
> DBD::mysql::st execute failed: Duplicate entry '4515' for key 'PRIMARY'
> [for Statement "INSERT INTO `old_reserves` ( `biblionumber`,
> `borrowernumber`, `branchcode`, `cancellationdate`, `expirationdate`,
> `found`, `itemnumber`, `itemtype`, `lowestPriority`, `notificationdate`,
> `priority`, `reminderdate`, `reserve_id`, `reservedate`, `reservenotes`,
> `suspend`, `suspend_until`, `timestamp`, `waitingdate`) VALUES ( ?, ?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues:
> 0='4095', 1='4310', 2='WLPL', 3=undef, 4=undef, 5='F', 6='4177', 7=undef,
> 8='0', 9=undef, 10=0, 11=undef, 12='4515', 13='2017-01-26', 14='', 15='0',
> 16=undef, 17='2017-01-26 14:05:25', 18='2017-01-26'] at
> /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832.
> DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '4515' for key
> 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 120
>
> I checked in the old_reserves table and found that there was already an
> entry with a reserve_id of 4515.
>
> Does anyone know how this would happen?
>
> I'm running Koha 16.11.20.000 on Debian 8 and just updated from packages
> last Wednesday if that's any help.
>
> --
> Tim McMahon
> Technical Services
> West Liberty Public Library
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 

*Hugo Agud - Orex Digital *

*www.orex.es <http://www.orex.es>*


<http://www.orex.es/>    [image: www.orex.es/koha] <http://www.orex.es/koha>
   [image: www.orex.es/vufind] <http://www.orex.es/vufind>
<http://www.orex.es/omeka>


Director

Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933
856 138   hagud at 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.