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 < [email protected]> 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 <[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
