- Koha - lists.katipo.co.nz

Recall: Items borrowed alert
by Hartman, David W. - Tech Library 29 Apr '15

29 Apr '15

Hartman, David W. - Tech Library would like to recall the message, "Items borrowed alert".

1 0

updatedatabase.pl failing from 3.10 to 3.12
by Jürgen Eichenbrenner 28 Apr '15

28 Apr '15

Upgrading from 3.10.13 to 3.12.15 or any higher version, the updatedatabase.pl script is broken. Does it work when I upgrade to a lower 3.12 version? Or do I have to fix this manually? Or is there a script to get it fixed? Thanks, Jürgen Eichenbrenner, International School Stuttgart. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Table 'borrower_attribute_types_branches' already exists at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6119. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Table 'categories_branches' already exists at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6121. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Table 'authorised_values_branches' already exists at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6123. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'OPACNumbersPreferPhrase' for key 'PRIMARY' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6405. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'IntranetNumbersPreferPhrase' for key 'PRIMARY' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6406. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'UNIMARCAuthorityField100' for key 'PRIMARY' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6413. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Table 'linktracker' already exists at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6458. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'batch_id_record_type' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6483. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '1-overdues_report' for key 'PRIMARY' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6492. [Tue Apr 28 12:29:33 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'UNIMARCAuthorsFacetsSeparator' for key 'PRIMARY' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6538. [Tue Apr 28 12:31:08 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'CalculateFinesOnReturn' for key 'PRIMARY' at /home/koha/koha312/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 6845.

3 2

3.18.06 Package Warning
by Renvoize, Martin 28 Apr '15

28 Apr '15

tl;dr Don't Upgrade Koha Packages to 3.18.06 yet! Hi All, Though I'd send a quick heads up that there's a nasty bug in the 3.18.06 package (available on the debian.koha-community.org repository). An upgrade will result in a couple of warning about unpacking some yui library files on the command line and in my experience so far, leave you with a rather nasty display in the staff client. I'm sure it's a trivial fix at this end once rangi or eythian is awake, but I'd hold off on upgrading until they give the go ahead ;) Martin Renvoize Software Engineer, PTFS Europe Ltd Content Management and Library Solutions Skype: Landline: 0203 286 8685 Mobile: 07725985636 http://www.ptfs-europe.com

6 8

RFID koha
by arunkumar s 28 Apr '15

28 Apr '15

Dear all, Does any one using 3M RFID with Koha. Thanks in advance -- *with regards * *S.ARUNKUMAR*

5 4

Using RFID with Koha
by Prajeesh 27 Apr '15

27 Apr '15

Exactly we would like to implement RFID in our library with Koha. Anyone is using Koha with RFID, any problems occurred during the implementation. Any additional software needed. Is it possible to create RFID tag using Koha. Tell me your experience. -- With Regards Prajeesh Bhaskaran Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Mob:+919846677502.

5 4

SQL Report help
by Jeramey Valley 24 Apr '15

24 Apr '15

Sure there’s a simple solution, not very good with SQL… This query works great: SELECT p.cardnumber, p.surname, p.firstname, DATE_FORMAT(c.issuedate, "%m/%d/%Y") AS Issue_Date, DATE_FORMAT(c.date_due, "%m/%d/%Y") AS Due_Date, h.attribute AS teacher, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue', b.title, b.author, i.itemcallnumber, i.replacementprice, i.barcode FROM borrowers p LEFT JOIN issues c ON (p.borrowernumber=c.borrowernumber) LEFT JOIN items i ON (c.itemnumber=i.itemnumber) LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) LEFT JOIN borrower_attributes g ON (p.borrowernumber=g.borrowernumber) LEFT JOIN borrower_attributes h ON (p.borrowernumber=h.borrowernumber) WHERE c.branchcode = <<Branch|branches>> AND (TO_DAYS(curdate())-TO_DAYS( date_due)) >= <<Days overdue>> AND h.code="HOMEROOM" ORDER BY g.attribute, h.attribute, p.surname ASC I need to also add to the above: SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code="c"]') AS heading FROM biblioitems WHERE length(ExtractValue(marcxml, '//datafield[@tag="020"]/subfield[@code="c"]')) != 0 ORDER BY heading Basically need to combine the two, how to do so? -- Regards, Jeramey Valley Network Manager, Bullock Creek Schools valleyj(a)bcreek.org

2 2

Koha not authorized to use CAS
by Ahmed Hadzic 23 Apr '15

23 Apr '15

Hello all, I am newbie for CAS and I'm trying to integrate some application with it (KOHA library). My CAS is running fine but when I'm trying to login to application with my CAS user I get the error "The application you attempted to authenticate is not authorized by CAS". I found out that I need to get the CAS server's Manager to add the OPAC Url to the Service Management system in CAS itself. But when I'm trying to acces it (https://localhost:8443/cas/services) it redirects me to the CAS login page. Does that means that I don't have CAS Service Management istalled or something else? I really don't know what to do so please, any help is appreciated. Thanks ! Ahmed

1 0

Koha 3.16.10 released
by Mason James 23 Apr '15

23 Apr '15

Hi Folks, The Koha release team are proud to announce the release of Koha 3.16.10. This is a bugfix/maintenance release As always, the best option is to upgrade using the debian packages, at debian.koha-community.org, Otherwise you can download the tarball at download.koha-community.org Full release notes are here http://koha-community.org/koha-3-16-10-released/ cheers, Mason

1 0

Upgrading from Koha 3.18.5.1 to 3.18.6 Problem
by Arslan Farooq 23 Apr '15

23 Apr '15

Hi, I'm having an error when upgrading the koha-common package on my Debian 7. Aptitude says: =========================================== [...] Unpacking replacement koha-common ... dpkg: error processing /var/cache/apt/archives/koha-common_3.18.06_all.deb (--unpack): unable to open '/usr/share/koha/opac/htdocs/opac-tmpl/lib/yui/skin.css.dpkg-new': No such file or directory [...] Errors were encountered while processing: /var/cache/apt/archives/koha-common_3.18.06_all.deb E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover: =========================================== Any suggestion what's wrong would be great. Arslan

1 0

Koha 3.18.6 released
by Chris Cormack 22 Apr '15

22 Apr '15

Hi Everybody The Koha release team are proud to announce the release of Koha 3.18.6. As always, the best option is to upgrade using the debian pacakges, at debian.koha-community.org . Otherwise you can download the tarball at download.koha-community.org Full release notes are here http://koha-community.org/koha-3-18-6-released/ Chris

1 0