Hi Today I wrote:

Environment: Debian GNU/Linux 8 with Koha 16.11.04 (package installation)

Our Koha catalogue contains MARC field 385 $a with content e. g. "KG", linked to category "Lesekategorie" containing authorized values for the target audience, e. g. value "KG" (description for staff client and OPAC is: "Kindergarten"). Instead of "KG" the OPAC shows "Kindergarten" as expected.

Now I have recently added a new facet for MARC field 385 $a and the facet does show - only instead of the description ("Kindergarten"), the facet shows the authorized value "KG". How can it be achieved to show the description in the facet?

As I see it is actually possible to show the description because the authorized values for standard category "LOC" are properly showing the descriptions. I tried to find out how this works in file "opac-facets.inc" but without success. Can anyone please give me a hint?

For the record: Jens Weber found the following code in file "/usr/share/koha/lib/C4/Search.pm": # also, if it's a location code, use the name instead of the code if ( $link_value =~ /location/ ) { # TODO Retrieve all authorised values at once, instead of 1 query per entry my $av = Koha::AuthorisedValues->search({ category => 'LOC', authorised_value => $one_facet }); $facet_label_value = $av->count ? $av->next->opac_description : ''; } I copied this section and adapted it as follows: # also, if it's a lesekategorie code, use the name instead of the code if ( $link_value =~ /lesekategorie/ ) { my $av = Koha::AuthorisedValues->search({ category => 'Lesekategorie', authorised_value => $one_facet }); $facet_label_value = $av->count ? $av->next->opac_description : ''; } After a restart of Koha (including Plack) now the created facet actually shows the description ("Kindergarten") instead of the authorized value "KG". Great! Of course this change will have to be reconfigured with every update but I guess it makes no sense to include this in the official Koha code... Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch

What version got installed? Did it say something was missing? What is in your koha_error.log ? Did you restart Apache? Philippe Blouin, Responsable du développement informatique Tél. : (888) 604-2627 philippe.blouin@inLibro.com <mailto:philippe.blouin@inLibro.com> inLibro | pour esprit libre | www.inLibro.com <http://www.inLibro.com> On 04/08/2017 03:21 AM, Rejeesh K.Nair wrote:

Hi All,

When I execute "sudo cpan CGI" command the site shows following server error.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at [no address given] to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

​Do you have any idea to retain the site into previous stage?​

Thanks & Regards,

Rejeesh K.Nair m: +91 (0) ​9495316906 e: rejeeshknair@gmail.com <mailto:rejeeshknair@gmail.com> <https://www.facebook.com/rejeeshnairk> <https://twitter.com/rejeeshknair> <http://in.linkedin.com/in/rejeeshknair> <https://www.instagram.com/rejeeshknair/>

Hi,

Our KOHA Version : 16.05.04.000 Ubuntu Version : 14.04

Below link suggests that Ubuntu 14.04 is no longer supported KOHA. https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages We have upgraded Ubuntu and CGI version. Again we got some error, so we are planning to reinstall KOHA. ​ read also:https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_...

Bye Zeno Tajoli

Hi All, I am very glad to inform you that, we have successfully integrated KOHA with MariaDB in our new server. In new server we couldn't find any 'Undefined subroutine CGI' error. We can login into MariaDB through putty with DB username and password.But when we try to login into phpmyadmin it shows following error '#1698 - Access denied for user 'root'@'localhost''. Can any one help on this issue? Also do you have any idea to integrate adminer.php(Mysql interaction tool like phpmyadmin) in KOHA. Thanks & Regards, Rejeesh K.Nair m: +91 (0) ​9495316906 e: rejeeshknair@gmail.com <https://www.facebook.com/rejeeshnairk> <https://twitter.com/rejeeshknair> <http://in.linkedin.com/in/rejeeshknair> <https://www.instagram.com/rejeeshknair/> On Tue, Apr 11, 2017 at 3:40 PM, Rejeesh K.Nair <rejeeshknair@gmail.com> wrote:

Hi Zeno Tajoli,

Thanks for your suggestion. We will integrate MariaDB for our new KOHA.

Thanks & Regards,

Rejeesh K.Nair m: +91 (0) ​9495316906 <094953%2016906> e: rejeeshknair@gmail.com <https://www.facebook.com/rejeeshnairk> <https://twitter.com/rejeeshknair> <http://in.linkedin.com/in/rejeeshknair> <https://www.instagram.com/rejeeshknair/>

On Tue, Apr 11, 2017 at 12:26 PM, Zeno Tajoli <z.tajoli@cineca.it> wrote:

...

Hi,

...

Our KOHA Version : 16.05.04.000 Ubuntu Version : 14.04

Below link suggests that Ubuntu 14.04 is no longer supported KOHA. https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages We have upgraded Ubuntu and CGI version. Again we got some error, so we are planning to reinstall KOHA. ​ read also:https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_ packages#Ubuntu_16.04_and_MySQL_5.7

Bye Zeno Tajoli