Bug 19976

Summary: data restoration in newly installed koha 17.11.X
Product: Koha Reporter: Mohammad Rasheed <rasheed>
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: CLOSED INVALID QA Contact: Testopia <testopia>
Severity: critical    
Priority: P5 - low CC: gmcharlt, jonathan.druart
Version: 17.11   
Hardware: PC   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

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....