It is always exciting to get a new update on open source software as it provides new features, improved functionality, and bug fixes. But, if done without understanding the changelogs, this can turn to a nightmare or a conflict with other applications.
It is usually the case when you update Koha and afterward, it begins to send the browser window a database link error. This article describes an easy way out of this confusing situation.
Once you run apt upgrade, it updates all installed packages into your most recent stable version automatically on your koha server. The following commands are given manually in the terminal window.
sudo apt-get update && apt-get upgrade
Now that the installed koha and other specifications such as MySQL and Apache have been updated, koha needs to update the database schema because there are some modifications in the table structure for every iteration and revision of koha and so in order to allow the use of mySQL, our newly upgraded koha code needs to upgrade the database schema.
sudo koha-upgrade-schema library
After that, it’s also advisable to run the Zebra Indexes that will reindex you all your bibliographic and authority data Brom the database.
(In my case, koha instance name is library, adjust accordingly if you differ.)
To do this, use this command
sudo koha-rebuild-zebra -v -f library.
Here again I mentioned my instance name as library
the -v switch runs the command in verbose mode.
the -f switch instructs to run the full index.
That’s it !!
It is the most effective and safely completed way to update your koha installation. Also to get rid of these database connection errors after upgrading.