[Koha] Koha 22.11 Upgrade - Bug 31162 - Add primary key to erm_eholdings_packages_agreements

[Craig Butosi]

Hi there,

Just updated to Koha 22.11 (ubuntu 18.04.06) and received an error after
database schema upgrade:

Bug 31162 - Add primary key to erm_eholdings_packages_agreements

Upgrade to 22.06.00.084  [10:30:33]: Bug 31162 - Add primary key to
erm_eholdings_packages_agreements

ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an
error in your SQL syntax; check the manual that corresponds to your MariaDB
server version for the right syntax to use near 'CONSTRAINT
erm_eholdings_packages_agreements_uniq,
                ADD PRIMARY K' at line 3 at
/usr/share/koha/lib/C4/Installer.pm line 739

I don't quite understand this error. Could someone advise?

Many thanks,

Craig Butosi, MA, MLIS, B Mus (Hons)
Library: library.craigbutosi.ca