- Koha - lists.katipo.co.nz

Fwd: Request for assistance on PHP hosted on my KOHA webserver.
by Chris Cormack 26 Apr '17

26 Apr '17

Forwarding by request, please reply to the list ---------- Forwarded message ---------- From: Boulier, Jack <jboulier(a)mticollege.edu> Date: 26 April 2017 at 08:06 Subject: Request for assistance on PHP hosted on my KOHA webserver. To: "chris(a)bigballofwax.co.nz" <chris(a)bigballofwax.co.nz> *From:* Boulier, Jack *Sent:* Monday, April 24, 2017 3:07 PM *To:* 'koha-request(a)lists.katipo.co.nz' <koha-request(a)lists.katipo.co.nz> *Subject:* Using PHP on the KOHA Server. I would like to use PHP (LAMP), on my KOHA server. I am unable to locate the storage location of the files. I thought it should be /var/www/html. But I cannot get the application to go to the localhost. It may also be that I have not loaded the LAMP solution correctly. *Koha version: * 16.11.06.000 *OS version ('uname -a'): * Linux ubuntu 3.16.0-33-generic #44~14.04.1-Ubuntu SMP Fri Mar 13 10:33:29 UTC 2015 x86_64 *Perl interpreter: * /usr/bin/perl *Perl version: * 5.018002 *Perl @INC: * /usr/share/koha/lib /etc/perl /usr/local/lib/perl/5.18.2 /usr/local/share/perl/5.18.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.18 /usr/share/perl/5.18 /usr/local/lib/site_perl . *MySQL version: * mysql Ver 15.1 Distrib 10.1.22-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 *Apache version: * Server version: Apache/2.4.7 (Ubuntu) *Memcached: * Servers: undefined | Namespace: koha | Status: unknown | Config read from: Nowhere Note that the right place to define the memcached config is in your $KOHA_CONF file. Currently you do not have a valid memcached configuration defined. | Effective caching method: Cache::Memory *Zebra version: * Zebra 2.0.44 (C) 1994-2010, Index Data ApS 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: 419ad759807269fdfa379799a051ed3a551c6541 Using ICU As you will notice I am using mariadb as my database, but it should not have any affect regarding my question. I was experiencing many problems with mysql server. But mariadb resolved all the issues. I am attempting to place links on my KOHA home page for patrons. I have successful accomplished in the past, but I was using another local server as the host, which is no longer an option, and not trying to use the localhost as the provider of the web pages. I am placing the links on the home page on the left and right sides. My other links to off-site locations works fine. If need I can provide a screen shot of the home page. This is the code that I have placed in OPAC NAV <div> <p style=text-align="center"><font color="red", size="5">Important MTI Websites</font></p> ß Work fine. </div> <a href= "http://elearning.mticollege.edu">elearning MTI College</a> <br /> <a href="https://www.microsoft.com/learning/en-us/default.aspx">Microsoft Cert. Registration</a> <br /> <a href="http://www.mticollege.edu">MTI College</a> <br /> <a href="http://localhost/Research/index.php">Research Paper Guidelines</a> ß- Code giving me problems. <hr /> Any help would be greatly appreciated. Jack Boulier Learning Resource Center Director MTI College 5221 Madison Ave. Sacramento, CA 95841 (916)339-4370 (916)339-0305 FAX

3 2

What's on in koha-devel #12
by Jonathan Druart 25 Apr '17

25 Apr '17

Hello librarians and developers, My last email got a lot of interest and people do not stop contacting me to help us, it's fantastic! Heh, no, just kidding. But I am still willing to help you! Whenever you are ready, just let me/us know! The next release is on its way. We are in the final stretch, I will summarize in this email what needs to be done in the next month. = Release dates = Kyle published the different dates of the Koha 17.05 release: May 5 - Feature Slush May 12 - Feature Freeze, String Freeze, 1st Draft of Release Notes May 19 - Release Beta, 2nd Draft of Release Notes May 26 - Final Release May 27 - Champagne! What does it mean? * Feature slush - enhancements that have not been marked as Passed QA at this time will not be considered for the release * Feature freeze - no new enhancements will be pushed to master, only bug fixes! * String freeze - only bug fixes without string changes will be pushed to master If you want one of our awesome features waiting for testing to be present in this new release, you should warm the sandboxes up for the next 10 days! = New stuffs pushed (or almost) = == Hea v2 == The production server (https://hea.koha-community.org) has been updated last week. The Koha side code (bug 18066) has been pushed to master and should be backported into the next stable releases (16.11.07, 16.05.13 and 3.22.21). What's new? * Ability to share the information at library level instead of installation level. If you have more than one library defined in your Koha installation, you will be able to share the URL, country and geolocation of each library * Configuration page in the administration module to define what you want to share with the community (Home › Administration › Usage statistics - admin/usage_statistics.pl) * On the hea website your Koha installation will be linked to one public page where you will see all the public information we collect * The database of the website has been cleaned to remove the duplicate and test entries The screenshots I have done during the development: Koha side: New page to configure the info to share: https://pageshot.net/opGCLAZFt0s1HVzp/pro.kohadev.vm (with libraries info) https://pageshot.net/SKTFZgr40EKg6fge/pro.kohadev.vm (without libraries info) Hea side: New layout for the homepage: https://pageshot.net/GGKbBZlZwxpXuCoi/localhost View "see all libraries" (existing one): https://pageshot.net/2XplbZXFFr9rLNJS/localhost View "see libraries by country": https://pageshot.net/G5czRcqh47WFIfRD/localhost View "see libraries on a map": https://pageshot.net/Xa4qW3Vc4MclrEhO/localhost View "public view for a library" (to show libraries what is public): https://pageshot.net/7whCONhkPuJUUxDP/localhost I invite you all to take a look at the configuration page and share with us the information you want to be public. You can find the "Terms and Conditions" on github https://github.com/joubu/hea-app/blob/v2/Terms_and_Conditions.md (Todo: link it from the hea website and Koha!) == Onboarding tools == The onboarding tool (bug 17855) is not pushed yet to master but is Passed QA and should be part of the next release. It adds new steps at the end of the installation process, to create different kinds of data and ease the first contact. You will be able to create a first library, patron category, item type, circulation rule and a patron with superlibrarian permission. Note that another patch (bug 17942) will arrive soon to refresh the style of the web installer interface. = Patches waiting for love = == Automatically convert SQL reports (urgent) == Since we have bug 17196 (Move marcxml out of the biblioitems table) pushed into the next release, we absolutely need bug 17898 (Add a way to automatically convert SQL reports) too. It is waiting for testing and is really easy to test and QA. This patch will help librarians to update SQL reports after the move of the marcxml field out of the biblioitems table. == Permissions for lists (urgent) == The aim of bug 18228 is to make the permissions for list easier to use and understand. However as it will remove complexity, it may remove a feature you are using. If you are using complex permission system to manage the lists you should take a look at this bug from comment 19. As Marcel already asked on the mailing list twice, this is the LAST CALL. I am going to QA it before the feature slush if nobody disagrees. == Facet configurable for Elastic == If you want to get a new Elastic search enhancement in the next release, take a look at bug 18235. It adds a new configuration area to configure facets. = Technical discussions = I would like to rework our background jobs. They do not work under Plack and it is a pity (see bug 15032). If anybody already did that in the past or has a clear idea on how to implement a job queue using TheSchwartz, gearman or others, please let me know. Unfortunately I do not have much time at the moment to explore the different options and play with them. = Tools for devs = I have added a new commit to the apply_on_cascade branch of my git-bz github repo: https://github.com/joubu/git-bz/commit/7afcfdb8a55384e79405ae44a697c36fa5f5… It modifies the behaviour of `git bz attach -e` when there are several patches to attach. The edit will be effective on the first attachment only. Indeed most of the time I just want to change the status and obsolete the patches and not to edit the commit messages. Just revert it if you do not want this behaviour. If you want to help testing bugs before the release, take a look at this search: https://frama.link/Koha_Needs_Signoff_bugs It shows all the opened bugs with a patch attached. They are bugs and new enhancement, are sorted by severity. Pick them from the top :) The next general IRC meeting is on May 3rd, 20 UTC. https://wiki.koha-community.org/wiki/General_IRC_meeting_03_May_2017 The next dev IRC meeting is tomorrow, April 26th at 13UTC https://wiki.koha-community.org/wiki/Development_IRC_meeting_26_April_2017 Hope to see your there! Cheers, Jonathan

1 0

Change the opac-detail.tt
by Luis Moises Rojas 25 Apr '17

25 Apr '17

Hi everybody, We need to modify the opac-detail.tt? Why? Take a look: If we made a search(looking, for example, a title) on KOHA (No opac), we have the following results: Title, subtitle and the Metion (fields 245 a,b,c. That is ok. When we do the same using OPAC We have: Title and the SUBTITLE (245 b) does not appears and the 245 c neither Do we have to setting something on the OPAC screen o what? -- *Luis Moisés Rojas P.*

2 1

Koha 3.22.20 security release
by Julian Maurice 24 Apr '17

24 Apr '17

The Koha community is proud to announce the release of Koha 3.22.20. This is a security release and contains several bugfixes. If you are running 3.22.x it is strongly recommended to upgrade. The full release notes are available at https://koha-community.org/koha-3-22-20-security-release/

1 0

Koha upgrade from 3.16 to 16.11
by Hugo Agud 21 Apr '17

21 Apr '17

Dear all We have just upgraded a koha from 3.16 (packages) to 16.11 and we're facing problems in aquisitions migration data. We have identified at least two types of issues... 1. Not all orders are shown in the module (they're al llinked to the records, then all the info is in mysql) for example when we search all orders we find just some of them, not all... 2. In funds, there are differences between the old and the new budgest...there is a 4% difference (I guess some fail with tax calculation) We have just now to dig on it.. but I wish to ask If anybody else has faced a similiar situation and have some tips or clue... if not we will share our experience. Kindest Regards Hugo -- *Hugo Agud - Orex Digital * *www.orex.es <http://www.orex.es>* <http://www.orex.es/> [image: www.orex.es/koha] <http://www.orex.es/koha> [image: www.orex.es/vufind] <http://www.orex.es/vufind> <http://www.orex.es/omeka> Director Calle Sant Joaquin,117, 2º-3ª · 08922 Santa Coloma de Gramanet - Tel: 933 856 138 hagud(a)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.

3 7

Printing of individual double-sided library cards with Koha
by Deselaers, Sybille 20 Apr '17

20 Apr '17

Dear all, We have recently introduced Koha in our library and now we want to print individual double-sided library cards with Koha. We have already created the necessary layouts for the front and back and a template for an individual card. Unfortunately, it seems that it is not possible to print a card in one go on both sides (front and back). So, we have to print the card from one side first with the layout for the front and then with the layout for the back. If anybody knows of a solution or possibility for printing the card in one go on both sides, we would very much appreciate if you could contact us. Best regards Sybille Deselaers Chief librarian Goethe-Institut / Max Mueller Bhavan 3, Kasturba Gandhi Marg New Delhi 110 001 Phone +91-11-23 47 11 49 sybille.deselaers(a)delhi.goethe.org<mailto:sybille.deselaers@delhi.goethe.org> www.goethe.de/newdelhi<http://www.goethe.de/newdelhi> www.goethe.de/india<http://www.goethe.de/india> www.facebook.com/maxmuellerbhavan.newdelhi<http://www.facebook.com/maxmuellerbhavan.newdelhi> Follow us on twitter: @GI_MMB_Delhi

3 4

Re: [Koha] Search page don't always show results when it should
by Jonathan Druart 20 Apr '17

20 Apr '17

Hi, Please answer to the list. Does it happen on both staff and OPAC interfaces? Everytime? randomly? with different search results? always the same page? Is the OPAC public? Regards, Jonathan On Fri, 7 Apr 2017 at 10:31 Administrateur <admin(a)ibnogent.org> wrote: > Yes, that's exactly the problem. > > I just changed the language to english and checked the log after a "no > results found" error and all I got is that : > > 03:52:33-07/04 zebrasrv(1) [warn] ir_session (exception) > 03:58:54-07/04 zebrasrv(2) [warn] ir_session (exception) > > [Fri Apr 07 03:52:32.522008 2017] [cgi:error] [pid 11302] [client > 10.36.237.6:60632] AH01215: [Fri Apr 7 03:52:32 2017] opac-search.pl: > Use of uninitialized value in string eq at > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 814., referer: > http://192.168.94.76/ > > [Fri Apr 07 03:50:50.564856 2017] [cgi:error] [pid 11277] [client > 10.36.237.6:60616] AH01215: [Fri Apr 7 03:50:50 2017] preferences.pl: > Use of uninitialized value in hash element at > /usr/share/koha/lib/C4/Languages.pm line 342., referer: > http://192.168.94.76:8008/cgi-bin/koha/admin/preferences.pl?tab=tools > > > Regards. > > Joël M. > Administrateur Réseaux/Système. > Institut Biblique de Nogent-sur-marne. > > Disponible Lundi-Mardi-Jeudi-Vendredi de 14h à 17h. > > On 04/04/17 19:39, Jonathan Druart wrote: > > Hello "admin", > > > > What you describe is very weird: launch a search, click on a page number, > > then "No results found" is displayed, you refresh and you see the > expected > > results? That's it? > > > > I'd try the English interface (not translated) and check Koha logs. > > > > Regards, > > Jonathan > > > > > > On Tue, 4 Apr 2017 at 11:31 Administrateur <admin(a)ibnogent.org> wrote: > > > >> Hi, > >> > >> I'm sending this message again because I still haven't found a solution. > >> > >> This is not related to my browser and rebooting the server doesn't > >> change anything. > >> On 23/03/17 15:27, Administrateur wrote: > >>> Hi, > >>> > >>> First of all I use Koha 16.0503000 on Debian. > >>> > >>> Everything works fine but I have one problem. If I do a search, I can > >>> see the results but sometime (randomly) when I click on a page number, > >>> Koha tells me that he has no results. If I refresh the same page (1 or > 2 > >>> time, depends) then the results are showed. > >>> > >>> How can I fix this ? > >>> > >>> I have two different Koha installations (prod and test) but it's the > >>> same problem. I updated my test server to the latest koha version > >>> available on apt (16.1105000) and then again, same problem. > >>> > >>> Thanks. > >>> > >>> > >> _______________________________________________ > >> Koha mailing list http://koha-community.org > >> Koha(a)lists.katipo.co.nz > >> https://lists.katipo.co.nz/mailman/listinfo/koha > >> > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz > > https://lists.katipo.co.nz/mailman/listinfo/koha > > >

5 6

Search page don't always show results when it should
by Administrateur 20 Apr '17

20 Apr '17

Hi, First of all I use Koha 16.0503000 on Debian. Everything works fine but I have one problem. If I do a search, I can see the results but sometime (randomly) when I click on a page number, Koha tells me that he has no results. If I refresh the same page (1 or 2 time, depends) then the results are showed. How can I fix this ? I have two different Koha installations (prod and test) but it's the same problem. I updated my test server to the latest koha version available on apt (16.1105000) and then again, same problem. Thanks. -- Joël M. Administrateur Réseaux/Système. Institut Biblique de Nogent-sur-marne.

3 6

Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
by Vimal Kumar V. 20 Apr '17

20 Apr '17

Dear Friends, I got following error when restored an old version of Koha to latest version. The error shown after loginto Koha staff client. Here is the error message: Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.opac_info' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 120 For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Please help me to solve this problem. Regards, -- Vimal Kumar V. Librarian School of Indian Legal Thought Mahatma Gandhi University Kottayam, Kerala Web: http://www.vimalkumar.info Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://dspacegeek.blogspot.in http://moovandan.blogspot.in <http://moovandan.blogspot.in> --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

2 1

Placing items on hold
by Daniel Owens 20 Apr '17

20 Apr '17

Our librarian discovered that our patrons are not allowed to place holds on items, even though the feature is enabled. The OPAC gives the following message when trying to place items on hold: Sorry, none of these items can be placed on hold. No available items. Under circulation rules, I have allowed 5 holds under " Holds allowed (count)." In OPAC Preferences, under "RequestOnOpac" I have "allow." Any ideas on where else I need to enable holds? Daniel

4 6