[Koha] Internal Server Error after upgrading to Koha 20.05

[Fadhili Ngalawa]

Hello everyone,

After some troubleshooting, I found out the error "*Internal Server Error*"
is triggered when plack is enabled.
After the disabling of plack, I managed to view the staff login page with
an error message below;

*DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.autorenew_checkouts' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 95*

Then I went to check the plack errors using the command (tail -f
/var/log/koha/<instancename>/plack-error.log) and found these below;

DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.autorenew_checkouts' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 95

DBD::mysql::st execute failed: Unknown column 'me.autorenew_checkouts' in
'field list' [for Statement "SELECT `me`.`borrowernumber`,
`me`.`cardnumber`, `me`.`surname`, `me`.`firstname`, `me`.`title`,
`me`.`othernames`, `me`.`initials`, `me`.`streetnumber`, `me`.`streettype`,
`me`.`address`, `me`.`address2`, `me`.`city`, `me`.`state`, `me`.`zipcode`,
`me`.`country`, `me`.`email`, `me`.`phone`, `me`.`mobile`, `me`.`fax`,
`me`.`emailpro`, `me`.`phonepro`, `me`.`B_streetnumber`,
`me`.`B_streettype`, `me`.`B_address`, `me`.`B_address2`, `me`.`B_city`,
`me`.`B_state`, `me`.`B_zipcode`, `me`.`B_country`, `me`.`B_email`,
`me`.`B_phone`, `me`.`dateofbirth`, `me`.`branchcode`, `me`.`categorycode`,
`me`.`dateenrolled`, `me`.`dateexpiry`, `me`.`date_renewed`,
`me`.`gonenoaddress`, `me`.`lost`, `me`.`debarred`, `me`.`debarredcomment`,
`me`.`contactname`, `me`.`contactfirstname`, `me`.`contacttitle`,
`me`.`borrowernotes`, `me`.`relationship`, `me`.`sex`, `me`.`password`,
`me`.`flags`, `me`.`userid`, `me`.`opacnote`, `me`.`contactnote`,
`me`.`sort1`, `me`.`sort2`, `me`.`altcontactfirstname`,
`me`.`altcontactsurname`, `me`.`altcontactaddress1`,
`me`.`altcontactaddress2`, `me`.`altcontactaddress3`,
`me`.`altcontactstate`, `me`.`altcontactzipcode`, `me`.`altcontactcountry`,
`me`.`altcontactphone`, `me`.`smsalertnumber`, `me`.`sms_provider_id`,
`me`.`privacy`, `me`.`privacy_guarantor_fines`,
`me`.`privacy_guarantor_checkouts`, `me`.`checkprevcheckout`,
`me`.`updated_on`, `me`.`lastseen`, `me`.`lang`, `me`.`login_attempts`,
`me`.`overdrive_auth_token`, `me`.`anonymized`, `me`.`autorenew_checkouts`
FROM `borrowers` `me` WHERE ( `me`.`userid` = ? )" with ParamValues: 0='']
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.

DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.autorenew_checkouts' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 95

DBD::mysql::st execute failed: Unknown column 'me.autorenew_checkouts' in
'field list' [for Statement "SELECT `me`.`borrowernumber`,
`me`.`cardnumber`, `me`.`surname`, `me`.`firstname`, `me`.`title`,
`me`.`othernames`, `me`.`initials`, `me`.`streetnumber`, `me`.`streettype`,
`me`.`address`, `me`.`address2`, `me`.`city`, `me`.`state`, `me`.`zipcode`,
`me`.`country`, `me`.`email`, `me`.`phone`, `me`.`mobile`, `me`.`fax`,
`me`.`emailpro`, `me`.`phonepro`, `me`.`B_streetnumber`,
`me`.`B_streettype`, `me`.`B_address`, `me`.`B_address2`, `me`.`B_city`,
`me`.`B_state`, `me`.`B_zipcode`, `me`.`B_country`, `me`.`B_email`,
`me`.`B_phone`, `me`.`dateofbirth`, `me`.`branchcode`, `me`.`categorycode`,
`me`.`dateenrolled`, `me`.`dateexpiry`, `me`.`date_renewed`,
`me`.`gonenoaddress`, `me`.`lost`, `me`.`debarred`, `me`.`debarredcomment`,
`me`.`contactname`, `me`.`contactfirstname`, `me`.`contacttitle`,
`me`.`borrowernotes`, `me`.`relationship`, `me`.`sex`, `me`.`password`,
`me`.`flags`, `me`.`userid`, `me`.`opacnote`, `me`.`contactnote`,
`me`.`sort1`, `me`.`sort2`, `me`.`altcontactfirstname`,
`me`.`altcontactsurname`, `me`.`altcontactaddress1`,
`me`.`altcontactaddress2`, `me`.`altcontactaddress3`,
`me`.`altcontactstate`, `me`.`altcontactzipcode`, `me`.`altcontactcountry`,
`me`.`altcontactphone`, `me`.`smsalertnumber`, `me`.`sms_provider_id`,
`me`.`privacy`, `me`.`privacy_guarantor_fines`,
`me`.`privacy_guarantor_checkouts`, `me`.`checkprevcheckout`,
`me`.`updated_on`, `me`.`lastseen`, `me`.`lang`, `me`.`login_attempts`,
`me`.`overdrive_auth_token`, `me`.`anonymized`, `me`.`autorenew_checkouts`
FROM `borrowers` `me` WHERE ( `me`.`userid` = ? )" with ParamValues: 0='']
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.

DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.autorenew_checkouts' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 95

DBD::mysql::st execute failed: Unknown column 'me.autorenew_checkouts' in
'field list' [for Statement "SELECT `me`.`borrowernumber`,
`me`.`cardnumber`, `me`.`surname`, `me`.`firstname`, `me`.`title`,
`me`.`othernames`, `me`.`initials`, `me`.`streetnumber`, `me`.`streettype`,
`me`.`address`, `me`.`address2`, `me`.`city`, `me`.`state`, `me`.`zipcode`,
`me`.`country`, `me`.`email`, `me`.`phone`, `me`.`mobile`, `me`.`fax`,
`me`.`emailpro`, `me`.`phonepro`, `me`.`B_streetnumber`,
`me`.`B_streettype`, `me`.`B_address`, `me`.`B_address2`, `me`.`B_city`,
`me`.`B_state`, `me`.`B_zipcode`, `me`.`B_country`, `me`.`B_email`,
`me`.`B_phone`, `me`.`dateofbirth`, `me`.`branchcode`, `me`.`categorycode`,
`me`.`dateenrolled`, `me`.`dateexpiry`, `me`.`date_renewed`,
`me`.`gonenoaddress`, `me`.`lost`, `me`.`debarred`, `me`.`debarredcomment`,
`me`.`contactname`, `me`.`contactfirstname`, `me`.`contacttitle`,
`me`.`borrowernotes`, `me`.`relationship`, `me`.`sex`, `me`.`password`,
`me`.`flags`, `me`.`userid`, `me`.`opacnote`, `me`.`contactnote`,
`me`.`sort1`, `me`.`sort2`, `me`.`altcontactfirstname`,
`me`.`altcontactsurname`, `me`.`altcontactaddress1`,
`me`.`altcontactaddress2`, `me`.`altcontactaddress3`,
`me`.`altcontactstate`, `me`.`altcontactzipcode`, `me`.`altcontactcountry`,
`me`.`altcontactphone`, `me`.`smsalertnumber`, `me`.`sms_provider_id`,
`me`.`privacy`, `me`.`privacy_guarantor_fines`,
`me`.`privacy_guarantor_checkouts`, `me`.`checkprevcheckout`,
`me`.`updated_on`, `me`.`lastseen`, `me`.`lang`, `me`.`login_attempts`,
`me`.`overdrive_auth_token`, `me`.`anonymized`, `me`.`autorenew_checkouts`
FROM `borrowers` `me` WHERE ( `me`.`userid` = ? )" with ParamValues: 0='']
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.

DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.autorenew_checkouts' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 95

DBD::mysql::st execute failed: Unknown column 'me.autorenew_checkouts' in
'field list' [for Statement "SELECT `me`.`borrowernumber`,
`me`.`cardnumber`, `me`.`surname`, `me`.`firstname`, `me`.`title`,
`me`.`othernames`, `me`.`initials`, `me`.`streetnumber`, `me`.`streettype`,
`me`.`address`, `me`.`address2`, `me`.`city`, `me`.`state`, `me`.`zipcode`,
`me`.`country`, `me`.`email`, `me`.`phone`, `me`.`mobile`, `me`.`fax`,
`me`.`emailpro`, `me`.`phonepro`, `me`.`B_streetnumber`,
`me`.`B_streettype`, `me`.`B_address`, `me`.`B_address2`, `me`.`B_city`,
`me`.`B_state`, `me`.`B_zipcode`, `me`.`B_country`, `me`.`B_email`,
`me`.`B_phone`, `me`.`dateofbirth`, `me`.`branchcode`, `me`.`categorycode`,
`me`.`dateenrolled`, `me`.`dateexpiry`, `me`.`date_renewed`,
`me`.`gonenoaddress`, `me`.`lost`, `me`.`debarred`, `me`.`debarredcomment`,
`me`.`contactname`, `me`.`contactfirstname`, `me`.`contacttitle`,
`me`.`borrowernotes`, `me`.`relationship`, `me`.`sex`, `me`.`password`,
`me`.`flags`, `me`.`userid`, `me`.`opacnote`, `me`.`contactnote`,
`me`.`sort1`, `me`.`sort2`, `me`.`altcontactfirstname`,
`me`.`altcontactsurname`, `me`.`altcontactaddress1`,
`me`.`altcontactaddress2`, `me`.`altcontactaddress3`,
`me`.`altcontactstate`, `me`.`altcontactzipcode`, `me`.`altcontactcountry`,
`me`.`altcontactphone`, `me`.`smsalertnumber`, `me`.`sms_provider_id`,
`me`.`privacy`, `me`.`privacy_guarantor_fines`,
`me`.`privacy_guarantor_checkouts`, `me`.`checkprevcheckout`,
`me`.`updated_on`, `me`.`lastseen`, `me`.`lang`, `me`.`login_attempts`,
`me`.`overdrive_auth_token`, `me`.`anonymized`, `me`.`autorenew_checkouts`
FROM `borrowers` `me` WHERE ( `me`.`userid` = ? )" with ParamValues: 0='']
at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
'me.autorenew_checkouts' in 'field list' at
/usr/share/koha/lib/Koha/Objects.pm line 95

I hope that someone experienced or ever faced something like this before
can assist.

Regards,

Fadhili