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