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