[Koha] Upgrade problem from 3.8.9 to 3.20.2

[vinod mishra]

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/ <http://mishravk.com/>*