https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19492 Bug ID: 19492 Summary: Field 'lowestPriority' doesn't have a default value (MariaDB) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Hold requests Assignee: koha-bugs@lists.koha-community.org Reporter: magnus@libriotech.no QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Running Koha with MariaDB on Ubuntu 16.04, I get an "internal server error" when I try to add a hold. The Plack log says: DBD::mysql::st execute failed: Field 'lowestPriority' doesn't have a default value [for Statement "INSERT INTO `reserves` ( `biblionumber`, `borrowernumber`, `branchcode`, `expirationdate`, `found`, `itemnumber`, `itemtype`, `priority`, `reservedate`, `reservenotes`, `waitingdate`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="16303", 1='1', 2="LIB", 3=undef, 4=undef, 5=undef, 6=undef, 7="1", 8='2017-10-19', 9="", 10=undef] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. DBIx::Class::Storage::DBI::_dbh_execute(): Field 'lowestPriority' doesn't have a default value at /home/kohaadmin/kohaclone/Koha/Object.pm line 121 And reserves.lowestPriority does indeed not have a default value (from installer/data/mysql/kohastructure.sql): `lowestPriority` tinyint(1) NOT NULL, Adding a default value of 0 makes the "internal server error" go away: ALTER TABLE reserves ALTER COLUMN lowestPriority SET DEFAULT 0; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.