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