[Koha] DBMS auto increment fix

[Scott Owen]

You Sir,

ARE AWESOME !!!!!

thank you so much.

-S


On Thu, Nov 16, 2017 at 1:05 PM, Pedro Amorim <pjamorim91 at 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 <sowen at 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 <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-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 <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
>>>>
>>>
>>>
>>
>