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@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