Re: [Koha] Upgrade problem from 3.8.9 to 3.20.2

2015-09-01 Thread vinod mishra 
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 :
> > 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/ *
> > ___
> > 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

Re: [Koha] Upgrade problem from 3.8.9 to 3.20.2

2015-09-01 Thread 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 :
> 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/ *
> ___
> 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

Re: [Koha] Upgrade problem from 3.8.9 to 3.20.2

2015-09-01 Thread Jonathan Druart 
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 :
> 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
>  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 :
>> > 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/ *
>> > ___
>> > 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