You Sir, ARE AWESOME !!!!!
thank you so much. -S On Thu, Nov 16, 2017 at 1:05 PM, Pedro Amorim <pjamori...@gmail.com> wrote: > 1) Copy the ID's from About Koha -> System Information > > 2) *Select * from old_issues where issue_id IN (<paste ID's here>) * Confirm > the listed rows are the ones you want to delete; > > 3) *Delete from old_issues where issue_id IN (<paste ID's here>);* > > 4) Check in items and be happy. > > This should work. > > Have a good one, > > Pedro Amorim > > On 16 November 2017 at 17:02, Scott Owen <so...@edzone.net> wrote: > >> thank you so much for the fast response. >> >> Is there a report / SQL query to find the duplicate ids that exist on >> both issues and old_issues tables ? >> >> >> >> On Thu, Nov 16, 2017 at 12:54 PM, Pedro Amorim <pjamori...@gmail.com> >> wrote: >> >>> Scott, >>> >>> The documented fix only prevents the problem from happening in the >>> future for new IDs, it will not fix the IDs already compromised. >>> This is the conversation I had with Marcel a couple weeks ago regarding >>> this issue: >>> http://koha.1045719.n5.nabble.com/Salvaging-data-before-usin >>> g-DBMS-auto-increment-fix-td5951803.html >>> >>> I ended up manually deleting said IDs from the old_issues table. >>> >>> Have a good one, >>> >>> Pedro Amorim >>> >>> On 16 November 2017 at 16:50, Scott Owen <so...@edzone.net> wrote: >>> >>>> Hi all, >>>> >>>> I have the following errors when my staff try and check in items: >>>> >>>> "The item has not been checked in due to a configuration issue in your >>>> system. You must ask an administrator to take a look at the about page >>>> and >>>> search for the "data problems" section" >>>> >>>> I have followed the solution as described >>>> >>>> https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix >>>> #The_solution >>>> >>>> and I continue to get the error, and staff are unable to check in items. >>>> >>>> Is there a fix / workaround that my staff can do ?? >>>> >>>> -S >>>> _______________________________________________ >>>> 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
