[Koha] DBMS auto increment fix

[Pedro Amorim]

You're welcome!

I hope this helps others in the future. This situation comes up quite often
in the list.

Have a good one,

Pedro Amorim

On Nov 16, 2017 18:04, "Scott Owen" <sowen at edzone.net> wrote:

> 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
>>>>>
>>>>
>>>>
>>>
>>
>