[Koha] Upgrade problem from 3.8.9 to 3.20.2

[Jonathan Druart]

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 at 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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha