- Koha - lists.katipo.co.nz

link bibs to autorities error
by Arayik Manukyan 24 Feb '17

24 Feb '17

Dear list, We tried to link bibs to authorities in Koha 3.22.13 and have got such error Any suggestions? Thanks, Arayik *************************************************************************************** <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00576nam a2200157 u 4500</leader> <controlfield tag="001">000526469</controlfield> <controlfield tag="005">20170208160921.0</controlfield> <controlfield tag="008">070316s1931 ai | |||||||||||||arm|d</controlfield> <datafield tag="041" ind1="0" ind2=" "> <subfield code="a">arm</subfield> </datafield> <datafield tag="100" ind1="1" ind2=" "> <subfield code="a">т©у╦ж┌ж─у©у╚у╞у╣у║уІ, у█у©у╔ж┐у║уІ у└у╚у╟ж─у║уІу╚,</subfield> <subfield code="d">1908-1986</subfield> </datafield> <datafield tag="245" ind1="1" ind2="0"> <subfield code="a">т©у╦уЄу╣у╔ж─у╚у©уЄу╚у╦ж┌у╘у╣у╦ж┌уІу╗ у║уЇуІу║уІу║ж│у║уІу╚ ж├ж─у╦уІу©у╦ж┌уЄ /</subfield> <subfield code="c">у█. т©у╦ж┌ж─у©у╚у╞у╣у║уІ.</subfield> </datafield> <datafield tag="260" ind1=" " ind2=" "> <subfield code="a">у┘у╔ж─ж┤у║уІ :</subfield> <subfield code="b">у┼у╔у©у╟ж─у║у©,</subfield> <subfield code="c">1931.</subfield> </datafield> <datafield tag="300" ind1=" " ind2=" "> <subfield code="a">46 уїу╩ ;</subfield> <subfield code="c">17 уҐуЄ.</subfield> </datafield> <datafield tag="440" ind1=" " ind2="0"> <subfield code="a">т╠уЇуІу║уІу║ж│у║уІу╚ у╞у║уЄу╨у║уІу╚у║</subfield> </datafield> <datafield tag="650" ind1="1" ind2="4"> <subfield code="a">у▐уІу©у╔уҐу║у╞у║уІ у╚ж─у║у╬у╚уЁу║у╞</subfield> </datafield> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">436808</subfield> <subfield code="d">436808</subfield> </datafield> </record> Can't call method "as_formatted" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 311. DBD::mysql::db DESTROY failed: MySQL server has gone away during global destruction. *************************************************************************************************

1 1

Koha 16.05.10 released
by Mason James 24 Feb '17

24 Feb '17

The Koha community is proud to announce the release of Koha 16.05.10. This is a maintenance release of 16.05 and includes 1 enhancement and 32 bugfixes. The full release notes are available at https://koha-community.org/koha-16-05-10-release Packages will be available soon.

1 0

cron issue with Koha on Ubuntu
by Steve Nickerson 23 Feb '17

23 Feb '17

I seem to recall seeing something about this perhaps but can't find the solution.I have the package version of Koha 16.05.09.000 installed and running on Ubuntu 16.04 LTS using the instructions at https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Add_A_Koha_Co mmunity_Repository. Things seems to be working properly except that none of the scheduled tasks are running (zebra re-indexing, email notices, etc.). Neither root nor the Koha "owner" account have a crontab, so I'm wondering if the install was supposed to have created one or not? Can someone tell me what the crontab(s) should look like and which user they should run under, please? Anyone have a URL with instructions already? Thanks in advance! Steve

3 9

z39.50 protocol
by Luis Moises Rojas 23 Feb '17

23 Feb '17

Hi, We are trying to use the z39.50 protocol, all servers are defined, but when we do a search of any book, only say: <library name> record No. xxx Not result. Any help? Thanks -- *Luis Moisés Rojas P.*

4 6

KOHA Report : Number of bib and Item based on Subject
by book guardian 23 Feb '17

23 Feb '17

Greeting, I am looking your help for KOHA report. I need a report that can provide me total number of bib and item based on subject heading. Since i have a few branch library it will be good if i can be filter by branch also. I have go through KOHA wiki report but could not found the solution. Your kind assistant is highly appreciated regards carl Malaysia -- View this message in context: http://koha.1045719.n5.nabble.com/KOHA-Report-Number-of-bib-and-Item-based-… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

KOHA instalation on Cent OS 6.8
by paulson kf 23 Feb '17

23 Feb '17

Hi, I am trying to install KOHA ( latest stable version ) in Cantos 6.8 . I have a dedicated server with three website running successfully in it . I need to park my KOHA along with these website . CentOS.6.3 is that latest official documentation published on KOHA ( https://wiki.koha-community.org/wiki/Koha_3.10_on_Centos_6.3_x86_64_en ) . I have tried this but not getting succeeded . Any one have any information about this. Best Regards, Paulson k f

2 1

link biblio to authorities error
by Arayik Manukyan 23 Feb '17

23 Feb '17

Dear List, We imported more than 1000 000 records in Koha 3.22.13, Ubuntu 3.14. 04, and Authority record nearly 30 000. Now when we wanted to link bibs with authority |sudo perl -I /usr/share/koha/lib /usr/share/koha/bin/link_bibs_to_authorities.pl| and have got such error **************************************************************************************************** DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389843'] at /usr/share/koha/lib/C4/Biblio.pm line 1287. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389843'] at /usr/share/koha/lib/C4/Biblio.pm line 1288. Out of memory (Needed 8164 bytes) DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with ParamValues: 0='389843'] at /usr/share/koha/lib/C4/Biblio.pm line 2233. DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with ParamValues: 0='389843'] at /usr/share/koha/lib/C4/Biblio.pm line 2234. Could not retrieve bib 389843 from the database - record is corrupt. Out of memory (Needed 8164 bytes) DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389844'] at /usr/share/koha/lib/C4/Biblio.pm line 1287. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389844'] at /usr/share/koha/lib/C4/Biblio.pm line 1288. Out of memory (Needed 8164 bytes) DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with ParamValues: 0='389844'] at /usr/share/koha/lib/C4/Biblio.pm line 2233. DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with ParamValues: 0='389844'] at /usr/share/koha/lib/C4/Biblio.pm line 2234. Could not retrieve bib 389844 from the database - record is corrupt. Out of memory (Needed 8164 bytes) DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389845'] at /usr/share/koha/lib/C4/Biblio.pm line 1287. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389845'] at /usr/share/koha/lib/C4/Biblio.pm line 1288. Out of memory (Needed 8164 bytes) DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with ParamValues: 0='389845'] at /usr/share/koha/lib/C4/Biblio.pm line 2233. DBD::mysql::st fetchrow failed: fetch() without execute() [for Statement "SELECT frameworkcode FROM biblio WHERE biblionumber=?" with ParamValues: 0='389845'] at /usr/share/koha/lib/C4/Biblio.pm line 2234. Could not retrieve bib 389845 from the database - record is corrupt. Out of memory (Needed 8164 bytes) DBD::mysql::st execute failed: MySQL client ran out of memory [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389846'] at /usr/share/koha/lib/C4/Biblio.pm line 1287. DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues: 0='389846'] at /usr/share/koha/lib/C4/Biblio.pm line 1288. Out of memory! DBD::mysql::db DESTROY failed: MySQL server has gone away during global destruction. ************** And noticed in koha-error.log such error. ************************************ [Thu Feb 23 12:22:54.769719 2017] [cgi:error] [pid 10443] [client 37.26.174.105:2094] AH01215: [Thu Feb 23 12:22:54 2017] additem.pl: DBIx::Class::Storage::DBI::selec [Thu Feb 23 12:25:18.418824 2017] [cgi:error] [pid 10512] [client 37.26.174.105:2099] AH01215: [Thu Feb 23 12:25:18 2017] additem.pl: DBIx::Class::Storage::DBI::selec [Thu Feb 23 12:26:05.141596 2017] [cgi:error] [pid 10536] [client 37.26.174.105:2102] AH01215: [Thu Feb 23 12:26:05 2017] additem.pl: DBIx::Class::Storage::DBI::selec ************************************ After that we encrease buffer_size <https://mariadb.com/kb/en/myisam-system-variables/#key_buffer_size>parameter in /etc/mysql/my.nf from 16 M to 1G . After that when the command |(link_bibs_to_authorities.pl|) was running again, we have got the same error. ||

1 0

Order PDF report
by Andreas Wolf 23 Feb '17

23 Feb '17

Dear all, just wondering how I can customize the basket group order PDF report (found in Acquisitions as ,Print this basket group in PDF')? Thanks for your assistance. Kind regards, Andreas

2 1

problem Installing koha on ubuntu 12.04
by Subhranil Bhattacharyya 23 Feb '17

23 Feb '17

Dear sir, I have some problem during KOHA installation, i am using Ubuntu 12.04 desktop-i386, when i am writing the terminal, sudo apt-get install koha common, its shows following error messege root@koha-H81M-WW:/home/koha# sudo apt-get install koha-common Reading package lists... Done Building dependency tree Reading state information... Done 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: libarchive-extract-perl but it is not installable Depends: libgd-perl but it is not installable Depends: libsereal-decoder-perl but it is not installable Depends: libsereal-encoder-perl but it is not installable E: Unable to correct problems, you have held broken packages. root@koha-H81M-WW:/home/koha# sudo apt-get install -f Reading package lists... Done Building dependency tree Reading state information... Done 0 upgraded, 0 newly installed, 0 to remove and 2 not upgraded. root@koha-H81M-WW:/home/koha# sudo apt-get install koha common Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package koha E: Unable to locate package common root@koha-H81M-WW:/home/koha# please give my suggesion, what can I do

4 3

Having two servers for Koha - Database and Application server
by Admire Mutsikiwa 23 Feb '17

23 Feb '17

Hi I would like to enquire if it is possible to implement Koha on two servers , with one server as the Database server running Mysql Database and another as the application server running Koha. I will appreciate any pointers on how to have such a setup/ Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University of Zimbabwe Tel:+263-4-303276 Mob:+263771117777 "It is easy to dodge our responsibilities, but we cannot dodge the consequences of dodging our responsibilities." Josiah Charles Stamp <http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

2 1