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