| Summary: | DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist | ||
|---|---|---|---|
| Product: | Koha | Reporter: | vimal kumar <vimalibre> |
| Component: | Installation and upgrade (command-line installer) | Assignee: | Galen Charlton <gmcharlt> |
| Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
| Severity: | enhancement | ||
| Priority: | P5 - low | CC: | dcook, jonathan.druart, mtj |
| Version: | 3.16 | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
| Bug Depends on: | 7372 | ||
| Bug Blocks: | |||
|
Description
vimal kumar
2014-12-11 17:18:39 UTC
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. |