Re: [Koha] Problem with the Koha Upgradation

2022-03-14 Thread 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

Re: [Koha] Problem with the Koha Upgradation

2022-03-14 Thread Pattabhi RK
Hi Shiva Kumara, As replied by other members already, it is not easy to upgrade the old Koha DB from 3.23 to current version 21.11 koha. The main problem is that old DB and new DB have different columns for some of the main tables. We need to properly study and do. The updatedatabase.pl will not

Re: [Koha] Problem with the Koha Upgradation

2022-03-14 Thread Shiva Kumara
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

Re: [Koha] Problem with the Koha Upgradation

2022-03-08 Thread Mark Alexander
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

Re: [Koha] Problem with the Koha Upgradation

2022-03-07 Thread Katrin Fischer
Hi, you are trying to update from a real old version of Koha, so it's not so easy to provide help. What you could do when running into an error is taking a look at the next update statement after 3.23.00.040 in updatedatabase.pl. You will have to check, why it fails on your database and then fig

[Koha] Problem with the Koha Upgradation

2022-03-06 Thread Shiva Kumara
Hi All, We have a koha backup of 3.23 version. We had installed Ubuntu 20.04.04 LTS and the Koha 21.11 version successfully. We tried to restore the old koha database to a new version of koha. When we run the command "*sudo koha-upgrade-schema library*" for upgrading, we are getting the following e