Re: [Koha] Software error: ~~Duplicate entry '320' for key 'PRIMARY' at~~~
Hey, you might have already checked this but just to be sure: The problem you were having with circulation also applies to holds, borrowers, records and items I think. If this problem is related, you might want to check ID 320 on old_reserves table and if its there, the same solution from before should work. On Nov 16, 2017 19:05, "Scott Owen" <sowen@edzone.net> wrote: Another error....is this one also related to the bug 18003 ? seems very similar.
From one of my staff...
________________________________________________ I put a book that is checked out on hold. When it is returned, the system tells me who is waiting. I confirm the hold When I check the book out to the patron, I get this message: Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '320' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121 ____________________________________________________ Any fix for this one ?? -S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Select * from old_reserves where reserve_id = (320) seems to find the specific one......any way to find all the records in question (like on the "about page" ) ? -S On Thu, Nov 16, 2017 at 3:25 PM, Pedro Amorim <pjamorim91@gmail.com> wrote:
Hey, you might have already checked this but just to be sure: The problem you were having with circulation also applies to holds, borrowers, records and items I think. If this problem is related, you might want to check ID 320 on old_reserves table and if its there, the same solution from before should work.
On Nov 16, 2017 19:05, "Scott Owen" <sowen@edzone.net> wrote:
Another error....is this one also related to the bug 18003 ? seems very similar.
From one of my staff...
________________________________________________
I put a book that is checked out on hold. When it is returned, the system tells me who is waiting. I confirm the hold
When I check the book out to the patron, I get this message:
Software error:
DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '320' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121
____________________________________________________
Any fix for this one ??
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Yes the "about page" lists all duplicate IDs for all data affected. On Nov 16, 2017 19:47, "Scott Owen" <sowen@edzone.net> wrote:
Select * from old_reserves where reserve_id = (320)
seems to find the specific one......any way to find all the records in question (like on the "about page" ) ?
-S
On Thu, Nov 16, 2017 at 3:25 PM, Pedro Amorim <pjamorim91@gmail.com> wrote:
Hey, you might have already checked this but just to be sure: The problem you were having with circulation also applies to holds, borrowers, records and items I think. If this problem is related, you might want to check ID 320 on old_reserves table and if its there, the same solution from before should work.
On Nov 16, 2017 19:05, "Scott Owen" <sowen@edzone.net> wrote:
Another error....is this one also related to the bug 18003 ? seems very similar.
From one of my staff...
________________________________________________
I put a book that is checked out on hold. When it is returned, the system tells me who is waiting. I confirm the hold
When I check the book out to the patron, I get this message:
Software error:
DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '320' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121
____________________________________________________
Any fix for this one ??
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Thank you again, errors fixed and cleaned up... me = :-) On Thu, Nov 16, 2017 at 4:08 PM, Pedro Amorim <pjamorim91@gmail.com> wrote:
Yes the "about page" lists all duplicate IDs for all data affected.
On Nov 16, 2017 19:47, "Scott Owen" <sowen@edzone.net> wrote:
Select * from old_reserves where reserve_id = (320)
seems to find the specific one......any way to find all the records in question (like on the "about page" ) ?
-S
On Thu, Nov 16, 2017 at 3:25 PM, Pedro Amorim <pjamorim91@gmail.com> wrote:
Hey, you might have already checked this but just to be sure: The problem you were having with circulation also applies to holds, borrowers, records and items I think. If this problem is related, you might want to check ID 320 on old_reserves table and if its there, the same solution from before should work.
On Nov 16, 2017 19:05, "Scott Owen" <sowen@edzone.net> wrote:
Another error....is this one also related to the bug 18003 ? seems very similar.
From one of my staff...
________________________________________________
I put a book that is checked out on hold. When it is returned, the system tells me who is waiting. I confirm the hold
When I check the book out to the patron, I get this message:
Software error:
DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '320' for key 'PRIMARY' at /usr/share/koha/lib/Koha/Object.pm line 121
____________________________________________________
Any fix for this one ??
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Pedro Amorim -
Scott Owen