[Koha] Internal Server Error after upgrading to Koha 20.05

[Fadhili Ngalawa]

Thank you so much Jonathan Druart for your quick response.
I added the columns manually and finally managed to access the staff login
page.

Thank you so much for this quick response that works.

Regards,

Fadhili

On Mon, 8 Jun 2020 at 12:34, Jonathan Druart <
jonathan.druart at bugs.koha-community.org> wrote:

> 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
>