- Koha - lists.katipo.co.nz

My bad.
by Raphael Meyer 11 Jun '20

11 Jun '20

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 Jonathan, my bad. Should have clicked on this address. Thanks anyway. Br Raphael

1 0

koha-US general meeting reminder: Wednesday, June 10th
by Jason Robb 09 Jun '20

09 Jun '20

Our next koha-US general meeting is *tomorrow, *Wednesday, June 10th. When: 8:30a PT / 11:30a ET / 3:30p UTC (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+June+gene…> ) Where: https://zoom.us/j/648572897 Agenda: https://docs.google.com/document/d/1A8khQ3zPsg51DpsH087MemodJj8jcXQml7JXAax… On the agenda this month: a reminder about how koha-US can support regional Koha groups within the US, a discussion about managing the organization's social media, and more. As always, we'll have plenty of time for open discussion of bugs and issues. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops, and Android and iOS on mobile devices. For help getting started, visit: https://support.zoom.us/hc/en-us/categories/200101697 These meetings are always free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Upgrade to 20.05.00.000 done [10:28:36]: 20.05.00 alpha release
by Hugo Agud Andreu 09 Jun '20

09 Jun '20

Good morning We are starting to play with Koha 20.05 and once we upgrade the database schema, it claims it is an alpha release, but I think It is a General Release We have installed with deb stable Is it a alpha release or it is a textual error? kindest regards Hugo Hugo Agud - Orex Digital www.orex.es<http://www.orex.es> [https://ci5.googleusercontent.com/proxy/C-agH5ES4uFINyKtzS6Vi0eMPO5THtLduFo…]<http://www.orex.es/> [www.orex.es/koha] <http://www.orex.es/koha> [www.orex.es/vufind] <http://www.orex.es/vufind> [https://ci3.googleusercontent.com/proxy/C6hOrdX9x-GTwsYAkhaZuvnN1nu86gksJE_…] [https://ci3.googleusercontent.com/proxy/YZRfjNcbmWALitdE6EGrlrGhllub8TL_6V6…] Director Passeig Comte Vilardaga, 118 3-3 08980 -Sant Feliu de Llobregat - Tel: 933 856 138 hagud(a)orex.es<mailto:hagud@orex.es> · http://www.orex.es/ No imprima este mensaje a no ser que sea necesario. Una tonelada de papel implica la tala de 15 árboles y el consumo de 250.000 litros de agua. Aviso de confidencialidad Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni está autorizado a recibirlo por el remitente), no está autorizado a copiar, reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.

1 0

"Opac Main UserBlock" OPAC
by Victor Barroso Oliveira 08 Jun '20

08 Jun '20

Good evening, Has the "Opac Main UserBlock" feature been removed from version 20.05 KOHA? How can we edit html in OPAC? Thank you

2 1

Error accessing "About Koha" after the upgrade. 20.5
by Victor Barroso Oliveira 08 Jun '20

08 Jun '20

Good Morning, Error accessing "About Koha" after the upgrade. 19.11.06 to 20.5 Software error: Can't locate object method "structured_requirements_for_module" via package "CPAN::Meta::Requirements" at /usr/share/koha/lib/C4/Installer/PerlModules.pm line 66. Can someone help me? Thank you

4 4

Internal Server Error after upgrading to Koha 20.05
by Fadhili Ngalawa 08 Jun '20

08 Jun '20

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

2 3

Error staging MARC records
by Mark Alexander 08 Jun '20

08 Jun '20

I recently upgraded our Koha from 19.05 to 19.11.06, and upgraded the underlying OS from Debian 8 to Debian 9. I'm now getting an error when I try to stage MARC records for import. The upload seems to work correctly, and I see the uploaded file in /tmp/koha_rpl_upload/, but Koha says the file doesn't exist when I press the "Stage for import" button. Here are the last two lines in intranet-error.log; I've inserted carriage returns for readability and anonymized the library name: [Fri Jun 05 06:07:49.132250 2020] [cgi:error] [pid 2025] [client 104.219.99.61:42282] AH01215: [Fri Jun 5 06:07:49 2020] stage-marc-import.pl: Use of uninitialized value in subroutine entry at /usr/share/koha/lib/Koha/Plugins/Base.pm line 182.: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: https://koha.OURLIBRARY.com:82/cgi-bin/koha/tools/manage-marc-import.pl [Fri Jun 05 06:08:06.283046 2020] [cgi:error] [pid 2062] [client 104.219.99.61:42286] AH01215: [Fri Jun 5 06:08:06 2020] stage-marc-import.pl: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl: cannot open input file /tmp/koha_rpl_upload/1371f85fdaf426b84bd9a782ce82bccf_set31.marc: No such file or directory: /usr/share/koha/intranet/cgi-bin/tools/stage-marc-import.pl, referer: https://koha.OURLIBRARY.com:82/cgi-bin/koha/tools/stage-marc-import.pl When I log in with ssh, I can see the file mentioned in the error message: % ls -laF /tmp/koha_rpl_upload/1371f85fdaf426b84bd9a782ce82bccf_set31.marc -rw-r--r-- 1 rpl-koha rpl-koha 3953 Jun 5 06:07 /tmp/koha_rpl_upload/1371f85fdaf426b84bd9a782ce82bccf_set31.marc I see that Elaine Bradtke reported this same error back on Aug 19, but said that the problem was due to a configuration issue that she did not describe. I'd like to know what sort of configuration issues could cause this error. Just in case, I've disabled all plugins, and the problem persists. For completeness, here is what the About page says: Koha version: 19.11.06.000 OS version ('uname -a'): Linux koha 5.6.1-x86_64-linode134 #1 SMP PREEMPT Wed Apr 1 22:25:48 UTC 2020 x86_64 Perl interpreter: /usr/bin/perl Perl version: 5.024001 Perl @INC: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.24.1 /usr/local/share/perl/5.24.1 /usr/lib/x86_64-linux-gnu/perl5/5.24 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.24 /usr/share/perl/5.24 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base /var/lib/koha/rpl/plugins /var/lib/koha/rpl/plugins MySQL version: mysql Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 Apache version: Server version: Apache/2.4.25 (Debian) PSGI: Plack (deployment) Memcached: Servers: 127.0.0.1:11211 | Namespace: koha_rpl | Status: running. | Config read from: koha-conf.xml Zebra version: Zebra 2.0.59 (C) 1994-2014, Index Data Zebra is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. SHA1 ID: c00bfddbf0f3608340d61298acc61dafb167f9b2 Using ICU Date and time: 06/05/2020 06:10 Time zone: Used: America/New_York | Config: Undefined | Environment (TZ): Undefined

2 2

Re: [Koha] Software error:DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.library_groups' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 130
by Alvaro Cornejo 07 Jun '20

07 Jun '20

Hi Francis Take a look onto this: http://kohageek.blogspot.com/2015/08/move-old-koha-database-to-new.html I used it a couple of monthns before to migrate from 17 to 19 version. Also, try to always cc koha list so others can benefit from mail exchange and also others can add ideas to your issue. Regards Alvaro |----------------------------------------------------------------------------------------| Stay safe / Cuídate/ Reste sécurisé *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et à mesure. *q *Recycle always / Recicla siempre / Recyclez toujours P Print only if absolutely necessary / Imprime solo si es necesario / Imprimez seulement si nécessaire Le ven. 5 juin 2020 à 21:33, Ashok Francis <ashokfrancis.tgs(a)gmail.com> a écrit : > Thanks for your reply Alvaro. Actually my hardisk crashed last two month > before. I have taken a sql backup. When I tried to restore my old backup to > new koha version. I got this error. I don't have idea of how to check the > log details? Can you guide me? > Thanks once again for your help > Ashok. > > On Sat, 6 Jun 2020, 1:19 am Alvaro Cornejo, <cornejo.alvaro(a)gmail.com> > wrote: > >> Hi Francis >> >> Do you have the log of the koha-upgrade-shema or the one from the >> upgrade? There might be a tip on the cause of the error. >> >> Regards, >> >> Alvaro >> >> |----------------------------------------------------------------------------------------| >> Stay safe / Cuídate/ Reste sécurisé >> *7* Switch off as you go / Apaga lo que no usas / Débranchez au fur et >> à mesure. >> *q *Recycle always / Recicla siempre / Recyclez toujours >> P Print only if absolutely necessary / Imprime solo si es necesario / >> Imprimez seulement si nécessaire >> >> >> Le ven. 5 juin 2020 à 13:13, Ashok Francis <ashokfrancis.tgs(a)gmail.com> >> a écrit : >> >>> Dear Professionals, >>> >>> I am new to koha. I was using koha17.05 on ubuntu mysql version 5.5.14. >>> When I tried to update koha from 17.05 to 19.05, I got the following >>> error >>> message. I have updated koha-upgrade-schema library also. But same error >>> is appearing on the opac. >>> Software error: >>> >>> DBIx::Class::Storage::DBI::_dbh_execute(): Table >>> 'koha_library.library_groups' doesn't exist at >>> /usr/share/koha/lib/Koha/Objects.pm line 130 >>> >>> For help, please send mail to the webmaster ([no address given]), giving >>> this error message and the time and date of the error. >>> I am in need of your help. I really appreciate your reply. >>> Thanks, >>> Ashok >>> _______________________________________________ >>> >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >>> >>

2 1

OPACXSLTResultsDisplay problem
by yeung yc 06 Jun '20

06 Jun '20

Dear all, I have a problem about changing the searching result page layout. I would like to include all the marc framework information. However, I failed to change from default to xslt stylesheet url. The searching result has no material info at all. I also tried to export the stylesheet and changed the name, then put it back to the opac xslt directory. It doesnt work as well. I wonder is there something I have missed after changing the code/file? Thanks guys. Any help would be appreciated.

2 1

How do Koha package updates work?
by Dawson Weber 06 Jun '20

06 Jun '20

Hello All, I have a Koha library for a personal collection and created the database in March 2019 starting with, I believe, 18.5. I am not much of a tech person but I was able to set up my library on Debian with Digital Ocean and did the installation with packages. Since then, it has updated to 18.11.03. I was curious if someone could direct me to information about how the updates work and the timing of them in relation to new releases and/or if I need to be facilitating the updates manually. Any information that could be shared would be appreciated. Thank you for your help! best regards, Dawson Weber Los Angeles

2 1