[Koha] Upgrade Schema Issue

[Mason James]

hi Taimoor,

what koha version are you upgrading from/to?


what does the following command say?

$ sudo koha-mysql library -e  ' select value from systempreferences where variable = "version" '
+------------+
| value      |
+------------+
| 21.1117000 |  <<<<<<<<<
+------------+



On 12/04/23 3:18 pm, Taimoor Memon wrote:
> Hello everyone,
> I'm facing an issue in the upgradation of Koha, terminal is executing the
> following error:
> 
> 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.
>