[Koha] Problem with the Koha Upgradation

[Katrin Fischer]

Hi Shiva,

be careful, commenting out is not always the correct solution. In this
case it tries to create the new table for circulation rules that you
will need for Koha to function properly later. You'll have to look into
the error "Foreign key constraint is incorrectly formed". If you don't
know much about databases this might be difficult to resolve without
some outside help.

Katrin

On 14.03.22 08:22, Shiva Kumara wrote:
> Thank you very much Katrin and Mark Alexander, your suggestions
> through some light on the issues. I commented on the lines of what
> 'Mark Alexander,' suggested, it was upgraded to the 18.06.00.035
> version. and showing the following errors.
>
> Upgrade to 18.06.00.031 done (Bug 20819: Add patron_consent)
> Upgrade to 18.06.00.032 done (Bug 5458: length of items.ccode
> disagrees with authorised_values.authorised_value)
> Upgrade to 18.06.00.033 done (Bug 12747 - Add
> AdditionalFieldsInZ3950ResultSearch system preference)
> Upgrade to 18.06.00.034 done (Bug 17602 - Integrate support for
> OneClickdigital/Recorded Books API)
> Upgrade to 18.06.00.035 done (Bug 21403 - Add Indian Amazon Affiliate
> option to AmazonLocale setting)
> {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Can't create table
> `koha_library`.`circulation_rules` (errno: 150 "Foreign key constraint
> is incorrectly formed")  at /usr/share/perl5/DBIx/Class/Schema.pm line
> 1118.
> DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x55aa5fe82ca0),
> "DBI Exception: DBD::mysql::db do failed: Can't create table `"...)
> called at /usr/share/perl5/DBIx/Class/Storage.pm line 113
> DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x55aa651555f0),
> "DBI Exception: DBD::mysql::db do failed: Can't create table `"...)
> called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1501
> DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Can't
> create table `koha_library`.`"..., DBI::db=HASH(0x55aa6561e4b0),
> undef) called at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> <http://updatedatabase.pl> line 16489
>
> if I again commented the line 16489 "*unless
> (TableExists('circulation_rules')){*" in updatedatabase.pl
> <http://updatedatabase.pl>. The error will be different as follows.
>
> Unmatched right curly bracket at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> <http://updatedatabase.pl> line 16527, at end of line
> syntax error at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> <http://updatedatabase.pl> line 16527, near "}"
> Execution of
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> <http://updatedatabase.pl> aborted due to compilation errors.
>
> I am stuck here, I do not have knowledge of databases and programs.
> Kindly suggest me a solutions
> Thank you,
>
> --
> ***With Regards***
> Shivakumara RM
> Digital Library Analyst
> Institute for Social and Economic Change
> Dr. VKRV Rao Road, Nagarabhavi,
> Bangalore - 560 072
>
>
>
>
>
>
>
> On Wed, 9 Mar 2022 at 06:05, Mark Alexander <marka at pobox.com> wrote:
>
>     Excerpts from Shiva Kumara's message of 2022-03-07 12:57:51 +0530:
>     > {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate
>     column name
>     > 'letternumber'  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
>
>     I ran into this problem recently when I upgraded Koha 3.16 to the
>     latest stable Koha.
>     I fixed this by commenting out the following statement in
>     updatedatabase.pl <http://updatedatabase.pl> and restarting
>     koha-upgrade-schema:
>
>         $dbh->do("ALTER TABLE overduerules_transport_types ADD COLUMN
>     letternumber INT(1) NOT NULL DEFAULT 1 AFTER id");
>
>     You will probably run into another error:
>
>     {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Can't DROP
>     INDEX `isbn`; check that it exists  at
>     /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
>
>     I fixed this by commenting out these two lines in
>     updatedatabase.pl <http://updatedatabase.pl>:
>
>             $dbh->do( "ALTER TABLE biblioitems DROP INDEX isbn" );
>             $dbh->do( "ALTER TABLE biblioitems DROP INDEX issn" );
>
>     --
>     One possible reason why things aren't going according to plan
>     is that there never was a plan. --Ashleigh Brilliant
>     _______________________________________________
>
>     Koha mailing list http://koha-community.org
>     Koha at lists.katipo.co.nz
>     Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
>
>
>