Please add this information:
- Operating system +version
- Old Koha version
- Your DB / software restoring procedure
- Concrete steps to reproduce the error message
El 03/10/18 a les 13:17, Larisa Snabi ha escrit:
> Dear Community,
> I have been trying to restore my old koha db to the latest koha 18.5 but I
> am getting error when invoking the upgrade schema library command.
> The error line is system preferences doesn't exist at database line 110.
> Request for help.
> Thank you
> Koha mailing list http://koha-community.org > [hidden email] > https://lists.katipo.co.nz/mailman/listinfo/koha >
> 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;*
> 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