[Koha] DBMS auto increment fix

[Scott Owen]

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 <pjamorim91 at 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-
> using-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 <sowen at 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 at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>