[Bug 13443] New: DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 Bug ID: 13443 Summary: DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist Change sponsored?: --- Product: Koha Version: 3.16 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt@gmail.com Reporter: vimal0212@gmail.com QA Contact: testopia@bugs.koha-community.org 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 vimal kumar <vimal0212@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |In Discussion --- Comment #1 from vimal kumar <vimal0212@gmail.com> --- 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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mtj@kohaaloha.com --- Comment #2 from Mason James <mtj@kohaaloha.com> ---
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 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 Mason James <mtj@kohaaloha.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |7372 Referenced Bugs: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7372 [Bug 7372] RoadTypes should be folded into Authorised Values -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 --- Comment #3 from Mason James <mtj@kohaaloha.com> --- 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 -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #4 from David Cook <dcook@prosentient.com.au> --- (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. -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13443 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |INVALID Status|In Discussion |RESOLVED CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #5 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- (In reply to Mason James from comment #3)
this bug might be a WONTFIX
Agreed, I would even say this is not a bug. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org