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 <mishravk79@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.druart@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@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/