[Koha] Internal Server Error after upgrading to Koha 20.05

[Jonathan Druart]

Hello Fadhili,

Have you been through the update database process? Did you notice an
error when you upgraded?
You have a missing table. I would suggest to use a backup of your
database, restart memcached then koha-common and hit the intranet
page.
You should then see the upgrade page.

If none of the above worked (or if you don't have backup), try to
create the missing DB columns manually:
> ALTER TABLE borrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL DEFAULT 1 AFTER anonymized
> ALTER TABLE deletedborrowers ADD COLUMN autorenew_checkouts TINYINT(1) NOT NULL DEFAULT 1 AFTER anonymized

Regards,
Jonathan

Le lun. 8 juin 2020 à 11:26, Fadhili Ngalawa <fngalawa at gmail.com> a écrit :
>
> 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
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha