[Koha] Upgrade problem from 3.8.9 to 3.20.2

[Jonathan Druart]

Could you have a look at the DB backup you did before the update and
confirm there is a primary key on the reserve table?

2015-09-01 11:42 GMT+01:00 vinod mishra <mishravk79 at gmail.com>:
> Thanks Dear Jonathan,
>
> So may i know what exactly to do step by step to overcome the situation as i
> am trying nut due to my technical limitations i could not able to do.
>
> Thanking You.
>
> On Tue, Sep 1, 2015 at 2:12 PM, Jonathan Druart
> <jonathan.druart at bugs.koha-community.org> wrote:
>>
>> Hi Vinod,
>>
>> As it said in the error, you already had a primary key defined on the
>> table.
>> old_reserves shouldn't have a primary key on old_reserves before
>> 3.09.00.025.
>>
>> Note that there was a bug in this update database entry, have a look
>> at bug 10185. But it exists in 3.20.*
>>
>> Regards,
>> Jonathan
>>
>> 2015-08-29 14:26 GMT+01:00 vinod mishra <mishravk79 at gmail.com>:
>> > Dear All,
>> >
>> > When i am trying to restore the database of Koha 3.8.9 to on 3.20.2 it
>> > gives following error after running* koha-upgrade-schema library*
>> > command.
>> >
>> >
>> > Upgrade to 3.09.00.023 done (Add system preference SearchEngine )
>> > Upgrade to 3.09.00.024 done (Add system preference
>> > IntranetSlipPrinterJS))
>> > DBD::mysql::db do failed: Multiple primary key defined at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5549.
>> > DBD::mysql::db do failed: Column count doesn't match value count at row
>> > 1
>> > at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5550.
>> > DBD::mysql::db do failed: Incorrect table definition; there can be only
>> > one
>> > auto column and it must be defined as a key at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5569.
>> > DBD::mysql::db do failed: Column count doesn't match value count at row
>> > 1
>> > at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5570.
>> > Failed to add reserve_id to reserves tables, please refresh the page to
>> > try
>> > again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
>> > updatedatabase.pl line 5586.
>> >
>> > Any solution please? if its a bug than i will file on bugzilla?
>> >
>> > --
>> >
>> >
>> >
>> >
>> > *With Regards,Vinod Kumar Mishra,Assistant Librarian,Biju Patnaik
>> > Central
>> > Library (BPCL),*
>> >
>> > *NIT Rourkela,*
>> >
>> > *Sundergadh-769008,*
>> >
>> > *Odisha,*
>> >
>> > *India.*
>> >
>> > *Mob:91+9439420860*
>> > *Website: http://mishravk.com/ <http://mishravk.com/>*
>> > _______________________________________________
>> > Koha mailing list  http://koha-community.org
>> > Koha at lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
>
> --
> With Regards,
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library (BPCL),
> NIT Rourkela,
> Sundergadh-769008,
> Odisha,
> India.
> Mob:91+9439420860
> Website: http://mishravk.com/