[Koha] Koha upgrade and restore issue

vinod mishra mishravk79 at gmail.com
Thu Jan 19 05:22:14 NZDT 2023


Hello
I wish to restore the database from one server to other in same version
(22.05.07.000) but while running the " *sudo koha-upgrade-schema library*"
command it through following error. Almost same error getting while running
" *sudo koha-rebuild-zebra -v -f library* " command. Please suggest the
possible issue.

root at koha-OptiPlex-9010:/home/koha# sudo koha-upgrade-schema library
Upgrading database schema for library
DBD::mysql::st execute failed: Table 'koha_library.systempreferences'
doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::st execute failed: Table 'koha_library.systempreferences'
doesn't exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Use of uninitialized value in numeric lt (<) at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 78.
DBD::mysql::db do failed: Table 'koha_library.bookshelf' doesn't exist at
/usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.shelfcontents' doesn't exist
at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
DBD::mysql::db do failed: Table 'koha_library.virtualshelfcontents' doesn't
exist at /usr/share/koha/lib/Koha/Database.pm line 152.
Undefined subroutine &main::DropAllForeignKeys called at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 86.
root at koha-OptiPlex-9010:/home/koha#

With Regards,

Vinod Kumar Mishra,
Assistant Librarian,
Biju Patnaik Central Library (BPCL),
NIT Rourkela,
Sundergadh-769008,
Odisha,
India.
Mob:91+9439420860
URL: http://vinod.itshelp.co.in/
ORCID ID: http://orcid.org/0000-0003-4666-7874
Scopus ID: 57223138343

*"Spiritual relationship is far more precious than physical. Physical
relationship divorced from spiritual is body without soul" -- Mahatma
Gandhi*


More information about the Koha mailing list