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 <[email protected]> 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
