Dear Friends, I just tried to upgrade Koha 3.14 (old stable) to 3.16. I installed Koha from Ubuntu packages. I executed following three commands to upgrade Koha, sudo apt-get update sudo apt-get upgrade sudo apt-get install koha-common I got following error message at the end in terminal, DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7987. DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7987. dpkg: error processing koha-common (--configure): subprocess installed post-installation script returned error exit status 255 E: Sub-process /usr/bin/dpkg returned an error code (1) Up gradation process in web interface does not proceed and it repeat it again and again. How can I overcome this problem.
I have solved the problem. Please follow the steps, Open a terminal sudo su leafpad /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl Search > Jump To > 7985 Find the line $dbh->{RaiseError} = 0; Change the value 1 to 0. Save file. Go back to koha and refresh the page.
> Find the line > $dbh->{RaiseError} = 0; > > Change the value 1 to 0. this doesn't fix the error, it just hides the error ie: the error will still exist after the change
i think the problem here, is that this specific Koha database is missing its 'roadtype' table if that table exists, this error should not occur i think the proper solution to this problem is to add the 'roadtype' table to this problem database, then attempt another upgrade this bug might be a WONTFIX
(In reply to vimal kumar from comment #0) > DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl > line 7987. > DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl > line 7987. > I've seen this before... usually when trying to use older Koha code on a newer Koha database. If the Koha database really is a 3.14 database, it should have a table called "roadtype". I'm guessing if you're seeing this error... that someone has made manual changes to this database... or the upgrade failed between "$dbh->commit;" and "SetVersion($DBversion);" but I doubt that.
(In reply to Mason James from comment #3) > this bug might be a WONTFIX Agreed, I would even say this is not a bug.