- Koha - lists.katipo.co.nz

configuring mysql for default utf8 support in koha
by H.S. 10 Mar '09

10 Mar '09

Hello, Just sharing my experience here. To configure mysql to support utf8 as default, init-connect='SET NAMES utf8' character-set-server=utf8 collation-server=utf8_general_ci character_set_client=utf8 With these, I get these as variables in mysql: mysql> show variables like "char%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.00 sec) Further I added the following lines in /etc/mysql/my.cnf (in the respective stanzas as shown below): [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld_safe] default-character-set=utf8 [mysqld] default-character-set=utf8 and restarted mysql. I then got the following set variables in mysql (as root): mysql> show variables like "char%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.01 sec) So looks like specifying the default char sets helped. If others have insights in to this, please share. I am not experienced in mysql so I do not know all the details about the factors affecting char sets in mysql in various situations. Thanks. -- Please reply to this list only. I read this list on its corresponding newsgroup on gmane.org. Replies sent to my email address are just filtered to a folder in my mailbox and get periodically deleted without ever having been read.

1 0

utf-8 character encodeing problem and serching of zebra indexing search
by Basu Talikoti 09 Mar '09

09 Mar '09

Hello all, We have running Koha 3.00 on centos operating system and we have some problems with indexing searching of of indic languages. It may be the presence of wide characters in records. We search key word marathi http://delhipubliclibrary.in/cgi-bin/koha/opac-search.pl?q=marathi it show 153 records. But we search from advance search for these books http://delhipubliclibrary.in/cgi-bin/koha/opac-search.pl?idx=kw&idx=kw&idx=… it give the following error utf8 "\xC2" does not map to Unicode at /usr/lib/perl5/5.8.8/i386-linux-thread-multi/Encode.pm line 170. The same problems in following search 1. ISBN: 9788189859312 http://delhipubliclibrary.in/cgi-bin/koha/opac-search.pl?q=9788189859312 2. दस प्रतिनिधि <http://delhipubliclibrary.in/cgi-bin/koha/opac-detail.pl?biblionumber=7122> dus pratinidhi Any one can help us to solve the problem With regards delhi public library

2 1

Re: [Koha] I'm confused about where normal view customization occurs
by Doug Dearden 09 Mar '09

09 Mar '09

Thanks Owen, this worked. I am running multiple databases, and when I was building that structure after installing Koha I copied the default koha database as three other databases, then populated those with my catalog info. Looking at the default Koha database, it has bibliosubtitle.subtitle in the marc_subfield_structure - kohafield location for all of the 245$b rows. I am thinking we lost this when we were modifying the frameworks for our use, but am not sure how. If I can duplicate the problem I'll report it. One way that comes to mind is that if we changed the link on the 245$b subfield, then changed it back to nothing. That is a project for another day, I have too many others getting piling up as it is. For now though, all is well. My thanks again to you and Galen. Best, Doug >>> Owen Leonard <oleonard(a)myacpl.org> 3/7/2009 2:35 PM >>> > Any idea why my Koha install would not show the $b field in the title under the Normal > view the way yours and Rachel's does? I noticed she is on a later release than I am. I've tracked down the commit that enables the display of the subtitle and it looks like it's old enough that you should have it. It was in the 3.0 stable release: kohabug 1621 - add subtitle to main results and details pages Including the subtitle in search results and OPAC and staff details templates. The subtitle is expected to be in the MARC subfield that is mapped to the (now nonexistant) column bibliosubtitle.subtitle. > What about the "Koha Link" field under the Advanced Constraints for a subfield. My reading of this > is that this is the link between the Koha DB fields and the MARC fields It sounds from those notes above that the fix depends on the "Koha Link" value for 245$b to be set to "bibliosubtitle.subtitle," a Koha field that, as the notes say, doesn't exist anymore. The trouble is, since it doesn't exist you can't choose it from the interface. Perhaps the only option is to change it in MySQL? "UPDATE marc_subfield_structure SET kohafield = 'bibliosubtitle.subtitle' WHERE tagfield = 245 AND tagsubfield = 'b'" ...and add "AND frameworkcode = 'XXX'" if you only want to change the XXX framework. Maybe Galen could chime in with comments since he was the author of the patch. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

1 0

Rv: Re: DATEFORMAT OF SERIALS
by Homero Almeida 09 Mar '09

09 Mar '09

-- On Fri, Mar 6, 2009 at 10:52 AM, Homero Almeida <homero1958(a)yahoo.com> wrote: > Hi all > When I need to register a new issue of the serial, I have the following > mistake: > > Koha error > > The following fatal error has occurred: > > Usage: Date::Calc::check_date(year, month, day) at > /usr/share/koha/lib/C4/Serials.pm line 1801. > > Apache Server version: Apache/2.2.3 Server built: Sep 6 2008 09:49:10 > Koha 3.00.01.005 > Koha DB 3.0001005 > MySQL mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline > 5.2 > OS Linux fbiee 2.6.18-6-686 #1 SMP Fri Dec 12 16:48:28 UTC 2008 i686 > Perl 5.008008 > Please HELP ME > > thanks > homero > > > - ¡Sé el Bello 51 de People en Español! ¡Es tu oportunidad de Brillar! Sube tus fotos ya. http://www.51bello.com/

1 0

Opac of Chitkara University....
by jksamyal 09 Mar '09

09 Mar '09

Dear Sir, we have successfully implemented Koha: Integrated Library system and OPAC can be accessed through http://library.chitkarauniversity.edu.in/ thanks.. jatinder kumar Incharge Library Chitkara University, Baddi, Himachal Pradesh. India-174103. Mob: +91-98728-42292

3 2

How to Get Rid of Check Sirsi/Sirsi-Resolver Link
by Shar Shar 09 Mar '09

09 Mar '09

We are on the latest stable Koha version (3.0001005). We would like to remove the Check Sirsi label which links to the sirsi-resolver.sirsi.net in the results page. We looked at the OPAC templates, scripts and XSLT (which is set to on in the preferences) but we cannot find how this is triggered. How to disable this label in the OPAC? Thank you all! Dishar

5 4

[help] how to creat book entry
by yatheesh babu 09 Mar '09

09 Mar '09

1)ACCESSION NUMBER [ which place should we enter 0,1 2)author (s) 3)source 4)Bill No 5)pages 6)distributor / supplier what is *items* how do we know books details enter perfectly [ created record after "addbibilio" ] what is *addbilio no* -- Yatheesh Babu Librarian Shri Shakti College of hotel management

2 1

Check on how MaxFine works?
by Wagner, Jane 09 Mar '09

09 Mar '09

Can someone check my understanding of MaxFine? If it's set to $10, and fine increments are .20, and the last total was $9.80, does the MaxFine kick in with the next .20 increment (total $10), or the first one AFTER the $10 threshhold (total $10.20)? Thanks. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

4 10

printing and koha
by Janson, Aad 09 Mar '09

09 Mar '09

Newby here! So perhaps my questions are very obvious. If so, I'am sorry. How do you define printers in Koha to print holdrequests, immediately after these holds are made? How do you define a label printer in Koha ? Thanks! Aad Janson Peace Palace Library P Please consider the environment before printing this e-mail

2 1

Re: [Koha] I'm confused about where normal view customization occurs
by Owen Leonard 09 Mar '09

09 Mar '09

> Any idea why my Koha install would not show the $b field in the title under the Normal > view the way yours and Rachel's does? I noticed she is on a later release than I am. I've tracked down the commit that enables the display of the subtitle and it looks like it's old enough that you should have it. It was in the 3.0 stable release: kohabug 1621 - add subtitle to main results and details pages Including the subtitle in search results and OPAC and staff details templates. The subtitle is expected to be in the MARC subfield that is mapped to the (now nonexistant) column bibliosubtitle.subtitle. > What about the "Koha Link" field under the Advanced Constraints for a subfield. My reading of this > is that this is the link between the Koha DB fields and the MARC fields It sounds from those notes above that the fix depends on the "Koha Link" value for 245$b to be set to "bibliosubtitle.subtitle," a Koha field that, as the notes say, doesn't exist anymore. The trouble is, since it doesn't exist you can't choose it from the interface. Perhaps the only option is to change it in MySQL? "UPDATE marc_subfield_structure SET kohafield = 'bibliosubtitle.subtitle' WHERE tagfield = 245 AND tagsubfield = 'b'" ...and add "AND frameworkcode = 'XXX'" if you only want to change the XXX framework. Maybe Galen could chime in with comments since he was the author of the patch. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 1