Bug 19976 - data restoration in newly installed koha 17.11.X
Summary: data restoration in newly installed koha 17.11.X
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: 17.11
Hardware: PC Linux
: P5 - low critical (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-01-16 07:02 UTC by Mohammad Rasheed
Modified: 2019-06-27 09:24 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mohammad Rasheed 2018-01-16 07:02:05 UTC
Dear Experts

I have installed koha 17.11.X and try to restore data backup taken from koha 16.05.X with following steps given below:
Database Restoration command,

mysql -uroot -p koha_library < koha_library.sql     [Check name of your source Koha database] 
koha_library - name of database in new installation
koha.sql - name of database in old installation
Enter the MySQL root password.

4. Upgrade Database Schema
Database schema of old Koha should upgrade to new one. Apply following commands in a terminal,

sudo su
koha-upgrade-schema library

5. Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

When I try to go staff interface the installation begins after Web installer › Selecting default settings try to import, installation stuck with the error given below:

Software error:

DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.search_field' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 110

For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error.
Comment 1 Jonathan Druart 2018-01-22 20:28:03 UTC
The table search_field has been created in 3.23.00.050, it's weird you do not have it in your dump from 16.05
From which version exactly are you trying to upgrade?
Comment 2 Mohammad Rasheed 2018-01-23 05:47:44 UTC
(In reply to Jonathan Druart from comment #1)
> The table search_field has been created in 3.23.00.050, it's weird you do
> not have it in your dump from 16.05
> From which version exactly are you trying to upgrade?

Hi Jonathan

Goodday,

Thank you very much for your reply.
Actually I am trying to upgrade from 16.05 to 17.11..

Regards
Comment 3 Jonathan Druart 2018-01-23 12:56:00 UTC
I can imagine a bug if you are coming from 3.22, but if you are coming from 16.05 you should have this table in your database.
Comment 4 Mohammad Rasheed 2018-01-24 05:36:08 UTC
(In reply to Jonathan Druart from comment #3)
> I can imagine a bug if you are coming from 3.22, but if you are coming from
> 16.05 you should have this table in your database.

Hi Jonathan

Thank you very much for your advise. 

The matter has been resolved. You are correct. I find the file and now koha 17.11 successfully working....