[Koha] Internal Server Error after upgrading to Koha 20.05

[Jonathan Druart]

By any chances do you still have the log of the upgrade process?
Can you check if you have the column 'anonymized' in the 'borrowers' table?

Le lun. 8 juin 2020 à 11:52, Fadhili Ngalawa <fngalawa at gmail.com> a écrit :
>
> 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