- Koha - lists.katipo.co.nz

Re: [Koha] Catalogue - SQL Report Help (Paul A)
by Paul A 12 Dec '14

12 Dec '14

At 07:18 PM 12/11/2014 -0500, Matthew Charlesworth, S.J. wrote: [snip] >I attach it here in case you might find it useful. I'm stuck with trying to >get a version of the report that only shows 0 copies or copies greater than >1 (or to use the input technique to specify by x number of Copies)... I've >tried the WHERE Copies=0 clause but that doesn't seem to work... No, the logic breaks down counting itemnumbers -- count the items.biblionumbers instead: SELECT DISTINCT CONCAT('<a title="Search for Title with Biblionumber: ',b.biblionumber,'" href="/cgi-bin/koha/catalogue/search.pl?q=ti%3A',REPLACE (b.title, ' ', '+'),'">Search</a>') AS "Search for Title", b.biblionumber, CONCAT('<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber,'">',b.title,'</a>') AS "Item Title", b.author, t.editionstatement, t.publishercode, t.isbn, count(i.biblionumber) AS "Copies" FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) GROUP BY b.biblionumber ORDER BY Copies ASC; Best -- Paul >SELECT DISTINCT CONCAT('<a title="Search for Title with Biblionumber: >',b.biblionumber,'" >href="/cgi-bin/koha/catalogue/search.pl?q=ti%3A',REPLACE (b.title, ' >', '+'),'">Search</a>') AS "Search for Title", b.biblionumber, >CONCAT('<a >href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',b.biblionumber,'">',b.title,'</a>') >AS "Item Title", b.author, t.editionstatement, t.publishercode, >t.isbn, count(i.itemnumber) AS "Copies" FROM biblio b LEFT JOIN >biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) >GROUP BY b.biblionumber ORDER BY Copies ASC > > >Regards > >Matthew. > > >------------------------------ > > > > > Message: 4 > > Date: Thu, 11 Dec 2014 01:19:06 +0000 > > From: Kerrie Stevens <KStevens(a)harvest.edu.au> > > Subject: Re: [Koha] Catalogue - SQL Report Help (Paul A) > > > > SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, > > t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT > > JOIN > > biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) > > WHERE i.ccode=<<Enter collection code>> GROUP BY b.biblionumber > > > > Thanks so much for your sharing of this report. > > > > Kerrie Stevens

1 0

Error while upgrading from 3.14 to 3.16 stable
by Vimal Kumar V. 11 Dec '14

11 Dec '14

Dear Friends, I just tried to upgrade Koha 3.14 (old stable) to 3.16. I installed Koha from Ubuntu packages. I executed following three commands to upgrade Koha, sudo apt-get update sudo apt-get upgrade sudo apt-get install koha-common I got following error message at the end in terminal, DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7987. DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 7987. dpkg: error processing koha-common (--configure): subprocess installed post-installation script returned error exit status 255 E: Sub-process /usr/bin/dpkg returned an error code (1) Up gradation process in web interface does not proceed and it repeat it again and again. How can I overcome this problem. Regards, -- Vimal Kumar V. Technical Assistant Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.info Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in http://moovandan.blogspot.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White

1 0

Search: Biblios not found after reindexing
by Beda Szukics 11 Dec '14

11 Dec '14

Hallo I upgraded today to koha 3.18.1 using the debian packages. I noticed that the links between authority records and bibligraphic records weren't updated using koha-rebuild-zebra So I tried a full reindex: koha-rebuild-zebra -f kb I get: 16:41:54-10/12 zebraidx(4827) [warn] Couldn't open collection.abs [No such file or directory] 17:05:59-10/12 zebraidx(4827) [fatal] reckeys.c:214: Out of memory - malloc(364288000 bytes) Right now I can't search biblios any more. An authority search does fine, but the the "used in"-row shows allways 0 results. What shall I do? Beda

5 9

Add daemon mode to rebuild_zebra.pl on 3.18
by Iming Chan 11 Dec '14

11 Dec '14

Dear all, We have successfully upgraded to 3.18 and encountered a problem when tried to add daemon mode to rebuild_zebra.pl (bug# 6435, from 3.16). Our IT person has supplied the following: [9:50:24 AM] Alexey - Neo Universe: root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# ./rebuild_zebra.pl Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6. BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6. [9:50:35 AM] Alexey - Neo Universe: root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# python -V Python 2.7.3 [9:51:03 AM] Alexey - Neo Universe: actually just this: [9:51:04 AM] Alexey - Neo Universe: root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# python -V Python 2.7.3 root@ip-172-31-0-233:/usr/share/koha/bin/migration_tools# ./rebuild_zebra.pl Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 6. BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 6. Have we missed something? Iming ----- Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: iming(a)translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Add-daemon-mode-to-rebuild-zebra-pl-on-3-… Sent from the Koha-general mailing list archive at Nabble.com.

2 1

Usage Stats Library Type
by Lenora Oftedahl 11 Dec '14

11 Dec '14

In 3.18, there's a system preference under Administration for Sharing anonymous usage statistics. Unfortunately, we can't choose a library type because we are neither a public library under the usual definition or a university. We are a special or government library. How can we add that? Lenora

2 1

Potential XSS attack vector in opac
by Bob Ewart 11 Dec '14

11 Dec '14

When our site was scanned for potential vulnerabilities, they came up with the following links typed into Firefox. 50.199.57.14/cgi-bin/koha/opac-search.pl?q=123&sort_by='"><script>prompt('Happy_Holidays')</script>&limit=123 and 50.199.57.14/cgi-bin/koha/opac-search.pl?q=ccl=su%3AGay%20men%20and%20su%3ASexual%20behavior&offset=100&sort_by=relevance_asc'"><script>prompt('Happy_Holidays')</script> Both of these scripts are executed and cause a pop up This looks similar to bug 11341 which was fixed in 3.14. We are running 3.18 on Xubuntu 14.04 LTS installed from the PPA. I noticed that in the patch at http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23313&action=diff there were a number of '|html %' entries which appear as '|url %' in 3.18. Is this a regression on bug 11341? Bob Ewart

5 6

Re: [Koha] Catalogue - SQL Report Help (Paul A)
by Kerrie Stevens 11 Dec '14

11 Dec '14

Hi Paul & Heather, The report you developed for Satish below is very helpful, but I'd like to tweak it a little differently - I've tried every variation I can think of with no luck (I don't have very much SQL experience)... how can I get it to select by branch, rather than collection code? SELECT DISTINCT b.biblionumber, b.title, b.author, t.editionstatement, t.publishercode, t.isbn, i.ccode, count(i.itemnumber) FROM biblio b LEFT JOIN biblioitems t USING(biblionumber) LEFT JOIN items i USING(biblionumber) WHERE i.ccode=<<Enter collection code>> GROUP BY b.biblionumber Thanks so much for your sharing of this report. Kerrie Stevens Harvest Bible College Melbourne, Australia

2 1

Zebra facets warning
by Iming Chan 11 Dec '14

11 Dec '14

Dear all, We have recently upgraded to 3.18 and I just noticed the following warning found in staff client under About > System Information: The <use_zebra_facets> entry is missing in your configuration file. Falling back to legacy facet calculation. How do we resolve this issue? Thank you in advance for your help. Iming ----- Iming Chan Translib Information Service Melbourne, Australia http://opac.translib.com Phone: +61 3 9801 5097 Fax: +61 3 9801 4024 E-mail: iming(a)translib.com -- View this message in context: http://koha.1045719.n5.nabble.com/Zebra-facets-warning-tp5821815.html Sent from the Koha-general mailing list archive at Nabble.com.

1 0

z39.50 in Koha
by Nisreen Qabbani 10 Dec '14

10 Dec '14

Hello How can we activate z39.50 in Koha In order to obtain records from the World catalog and other libraries

2 1

Catalogue - SQL Report Help
by satishamv 10 Dec '14

10 Dec '14

Dear Friends, I am looking for a report which has list of all unique titles(biblio records) in a home library AND also by collection code. In my case, new record is created for - change in edition or change in item type. with thanks. Satish MV Librarian Govt. Engineering College, Hassan. Karnataka. INDIA. -- View this message in context: http://koha.1045719.n5.nabble.com/Catalogue-SQL-Report-Help-tp5820185.html Sent from the Koha-general mailing list archive at Nabble.com.

5 10