[Koha] Request for help

[Larisa Snabi]

On Thu 4 Oct, 2018, 1:19 PM Larisa Snabi, <larisasnabi at gmail.com> wrote:

> Dear Nancy,
>
> We are using the following:
> OS - Ubuntu 16.04 LTS,
> Old Koha Version - 3.x
> The steps we followed were -
> 1. Installed Ubuntu
> 2. Installed Koha common which when checked was version 18.05
> *3. Restoration of old Koha database to new one*
> Remove existing database in new installation
>
> *sudo su*
> *mysql -uroot -p *
>
> [Enter the MySQL Root password]
>
> *drop database koha_library;*
> *create database koha_library;*
> *quit;*
>
> Copy your database backup from your pen drive to home folder.
> Extract the backup file, the extension will be .sql
> Then restore the old backup to new installation.
>
> Database Restoration command,
>
> *mysql -uroot -p koha_library < koha_library.sql     *[
>
>
> *4. Upgrade Database Schema*
>
>
> *sudo sukoha-upgrade-schema library*
>
> On reaching step 4 the db does not get updated and we get the following
> error line
>
>
>
> *DBD : :mysql: :db do failed: Table 'koha_cpgslibrary.systempreferences'
> does not exist [for statement "Select " FROM systempreferences WHERE 1=0" ]
> at usr/share/koha/lib/koha/Database.pm line 110. *
> Thank you and Regards
> Larisa
>
>