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.dru...@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 <mishrav...@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@lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@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/>* _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha