May 2018 - Koha-devel - lists.koha-community.org

Norwegian help needed for fuller testing
by Mark Tompsett 08 May '18

08 May '18

Greetings, I was looking around the swarm of bugs that came in recently and found bug 20719. One of the template files I needed to modify, as far as I can tell, was nl-search. Could someone who understands the Norwegian system preferences please check my patch? Thank you, Mark Tompsett

2 1

Signoff
by Marcel de Rooy 07 May '18

07 May '18

Hi all, Would be nice to see two small bug fixes still get further this week: Bug 11943 Prevent double accepts in Koha::Virtualshelfshare https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11943 Bug 20695 Upload does not show all results when uploading multiple files https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20695 They need a signoff yet. Thx, Marcel

1 0

Re: [Koha-devel] Koha on Ubuntu 18.04 LTS (Bionic Beaver)
by Giuseppe Angilella 07 May '18

07 May '18

Dear Mark, many thanks: your suggestions did help, in the sense that it looked to think apt-get that the missing packages had been installed, which allowed me to overcome the "unmet dependencies" error. However, after having Koha installed and configured, I couldn't open the browser interface, because of "software errors". After inspection, it turned out that the missing MARC/perl packages had been manually installed in non-standard directories. E.g. dpkg-deb -c libmarc-xml-perl_0.4-1_all.deb drwxr-xr-x root/root 0 2018-05-05 15:56 ./ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/perl5/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/perl5/lib/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/perl5/lib/perl5/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/perl5/lib/perl5/MARC/ -rw-r--r-- root/root 33884 2000-04-24 03:36 ./home/<username>/perl5/lib/perl5/MARC/XML.pm drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/perl5/man/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./home/<username>/perl5/man/man3/ -rw-r--r-- root/root 15519 2018-05-05 15:56 ./home/<username>/perl5/man/man3/MARC::XML.3pm drwxr-xr-x root/root 0 2018-05-05 15:56 ./usr/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./usr/share/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./usr/share/doc/ drwxr-xr-x root/root 0 2018-05-05 15:56 ./usr/share/doc/libmarc-xml-perl/ -rw-r--r-- root/root 807 2000-01-25 19:26 ./usr/share/doc/libmarc-xml-perl/README -rw-r--r-- root/root 141 2018-05-05 15:56 ./usr/share/doc/libmarc-xml-perl/changelog.Debian.gz -rw-r--r-- root/root 1791 2018-05-05 15:56 ./usr/share/doc/libmarc-xml-perl/copyright drwxr-xr-x root/root 0 2018-05-05 15:56 ./usr/share/doc/libmarc-xml-perl/examples/ -rw-r--r-- root/root 807 2000-01-25 19:26 ./usr/share/doc/libmarc-xml-perl/examples/README -rw-r--r-- root/root 501 1999-11-22 01:43 ./usr/share/doc/libmarc-xml-perl/examples/marc2xml.pl -rw-r--r-- root/root 4077 2000-01-25 20:56 ./usr/share/doc/libmarc-xml-perl/examples/pacific.pl -rw-r--r-- root/root 17854 2000-01-18 16:06 ./usr/share/doc/libmarc-xml-perl/examples/pacific0.dat.gz -rw-r--r-- root/root 1923 2000-01-25 21:53 ./usr/share/doc/libmarc-xml-perl/examples/read_pfa.pl -rw-r--r-- root/root 511 1999-11-23 22:45 ./usr/share/doc/libmarc-xml-perl/examples/simple.pl -rw-r--r-- root/root 509 1999-11-22 01:47 ./usr/share/doc/libmarc-xml-perl/examples/xml2marc.pl where <username> is my own home directory. I even tried to execute your commands as sudo su, but this didn't help. I then looked on http://packages.ubuntu.com for the location where each package would place its files in Ubuntu 16.04, say https://packages.ubuntu.com/xenial/all/libmarc-xml-perl/filelist and started moving files to the correct location one by one. This enabled me to overcome some initial errors, but produced new (similar) ones. Of course this is not the clean way to proceed ... Is there a configuration parameter that I am missing, in order to instruct cpan2deb (or dpkg) to install the relevant files in the appropriate/standard directories? Many thanks and best regards, Giuseppe. > Date: Tue, 1 May 2018 12:29:32 +0000 > From: Mark Tompsett <mtompset(a)hotmail.com> > To: "koha-devel(a)lists.koha-community.org" > <koha-devel(a)lists.koha-community.org> > Subject: Re: [Koha-devel] Koha on Ubuntu 18.04 LTS (Bionic Beaver) > Message-ID: > <DM2PR11MB0059C56D9ED3145B375B541BC6810(a)DM2PR11MB0059.namprd11.prod.outlook.com> > > Content-Type: text/plain; charset="iso-8859-1" > > Greetings, > > When this happens, I prefer to package, however haphazardly, them. > > cd ~ > mkdir dhmake > sudo apt-get install dh-make-perl > cd dhmake > cpan2deb Marc::Charset > yes > sudo > -- should be noted some people don't like that answer. *shrug* I just go > with it. > sudo dpkg -i libmarc-charset-perl_<tab><enter> > -- it should auto-complete the entire deb name > sudo apt-get install libmarc-perl > -- I figured out this is a prerequisite for libmarc-xml-perl > cpan2deb Marc::XML > sudo dpkg -i libmarc-xml-perl_<tab><enter> > > In this case, these are easy. And I do it this way, so that if either make > it into default repos as newer versions, they will get upgraded with sudo > apt-get update; sudo apt-get upgrade > > GPML, > Mark Tompsett > > > -----Original Message----- > From: Giuseppe Angilella > Sent: Tuesday, May 01, 2018 8:11 AM > To: koha-devel(a)lists.koha-community.org > Subject: [Koha-devel] Koha on Ubuntu 18.04 LTS (Bionic Beaver) > > Hi, > > I am trying to migrate my Koha installation from an Ubuntu 16.04 LTS > "Xenial" [virtual] machine to a new machine, running Ubuntu 18.04 LTS > "Bionic Beaver". > > Immediately after issuing the installation command: > > sudo apt-get install koha-common > > I get the error: > > Some packages could not be installed. This may mean that you have > requested an impossible situation or if you are using the unstable > distribution that some required packages have not yet been created > or been moved out of Incoming. > The following information may help to resolve the situation: > > The following packages have unmet dependencies: > koha-common : Depends: libmarc-charset-perl but it is not installable > Depends: libmarc-xml-perl but it is not installable > > Indeed, these two dependencies are not [yet] implemented for Ubuntu 18.04, > as of https://packages.ubuntu.com . > > Any suggestion? > > Many thanks. > > Giuseppe. > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.koha-community.org > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel > website : http://www.koha-community.org/ > git : http://git.koha-community.org/ > bugs : http://bugs.koha-community.org/

2 2

Some sites down
by Chris Cormack 03 May '18

03 May '18

Linode rebooted the host machine last night (underlying security fixes) some sites didn't come up. I'll fix this afternoon NZ time Chris -- Sent from my Android device with K-9 Mail. Please excuse my brevity.

1 0

Branch column in statistics table
by Cab Vinton 03 May '18

03 May '18

Hi, All -- According to the schema, the branch column represents the branch "where the transaction occurred". How does Koha treat transfers in the statistics table? My assumption has been that data in statistics.branch represents where an item was ultimately issued to a patron (i.e., rather than the the initial transfer from the holding library). Is this correct? I ask because I ran a couple of reports, one based on the branchtransfers table and one based on the statistics table, that provided unexpected results. Specifically, I would have expected the number of transfers to be much higher than the number of issues at non-home branches. The reports, however, seem to indicate 1,650 transfers to a particular branch versus 2,450 issues where those patrons actually traveled to other branches (statistics.branch). Grateful for any insight the list can provide. (Including the reports below.) All best, Cab Vinton, Director Plaistow Public Library Plaistow, NH SELECT b.categorycode, s.branch as 'checked out at', b.branchcode as 'patron branch', count(s.datetime) as count FROM statistics s LEFT JOIN borrowers b ON (s.borrowernumber = b.borrowernumber) WHERE s.type in ('issue') AND s.datetime BETWEEN '2017-05-01' AND '2018-04-30' GROUP BY b.categorycode, s.branch, b.branchcode SELECT t.frombranch, t.tobranch, COUNT(*) FROM branchtransfers t WHERE t.datesent BETWEEN '2017-05-01' AND '2018-04-30' GROUP BY t.frombranch, t.tobranch

1 0

Proposed change to standard page markup (Bug 20670)
by Owen Leonard 02 May '18

02 May '18

In case people have feelings about markup, I wanted to share Bug 20670, "Bug 20670 - Add markup and standard classes for sidebars and main content areas." https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20670 The conversion of staff client templates to Bootstrap grids is continuing, and I think it would be helpful to have markup which defines the "main content" from the sidebar on two-column layout pages. If anyone has comments or concerns, or would like to kibitz class names, please feel free! -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

4 6

Reminder: General IRC meeting 2 May 2018
by Katrin Fischer 02 May '18

02 May '18

Hi all, our next General IRC meeting is in less than 24 hours Find us here on the web, or using your favorite IRC client: http://webchat.oftc.net/?channels=koha Local time and date for meeting: https://www.timeanddate.com/worldclock/fixedtime.html?msg=Koha+General+IRC+… Or add the calendar here to your Google account: https://koha-community.org/calendar/ Agenda: https://wiki.koha-community.org/wiki/General_IRC_meeting_2_May_2018 Please add anything you wish to discuss! See you there! Katrin

1 0

Koha Community Newsletter: April 2018
by kohanews 02 May '18

02 May '18

Fellow Koha users: The Koha Community Newsletter for April 2018 is here: https://koha-community.org/koha-community-newsletter-april-2018/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. Thanks! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Koha on Ubuntu 18.04 LTS (Bionic Beaver)
by Giuseppe Angilella 01 May '18

01 May '18

Hi, I am trying to migrate my Koha installation from an Ubuntu 16.04 LTS "Xenial" [virtual] machine to a new machine, running Ubuntu 18.04 LTS "Bionic Beaver". Immediately after issuing the installation command: sudo apt-get install koha-common I get the error: Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been created or been moved out of Incoming. The following information may help to resolve the situation: The following packages have unmet dependencies: koha-common : Depends: libmarc-charset-perl but it is not installable Depends: libmarc-xml-perl but it is not installable Indeed, these two dependencies are not [yet] implemented for Ubuntu 18.04, as of https://packages.ubuntu.com . Any suggestion? Many thanks. Giuseppe.

2 1