- Koha - lists.katipo.co.nz

Class reports
by library 09 Nov '15

09 Nov '15

Hi everyone I wonder if anyone can help me with my report. I am trying to adapt the "Patrons with most checkouts in date range report" to enable me to print borrowing statistics by classes which I have as an additional attribute. I keep getting an error message "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers b ' at line 2" which is the part I didn't change. This is as far as I have got in my report. SELECT concat(b.surname,', ',b.firstname) AS name, a.code, a.attribute, c.branchcode count(s.borrowernumber) AS checkouts FROM statistics s LEFT JOIN borrowers b USING (borrowernumber) LEFT JOIN borrower_attributes a USING (borrowernumber) WHERE c.branchcode = 'KKC' AND s.datetime BETWEEN <<Top checkouts BETWEEN (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> WHERE a.code = Class AND a.attribute=<<Class>> Thanks Ann Murphy Katikati College

1 0

ABCD is a an Open Source web-based integrated library management software
by Rasheed Ahmed 08 Nov '15

08 Nov '15

Dear All, ABCD (Automation of Libraries and Documentation Centers, from its name in Spanish and Portuguese) is a multilingual, Web application for the management of libraries, containing core library functions such as acquisitions, cataloging, lending and database administration. It also includes an advanced lending module called EmpWeb ABCD ABCD logo *ABCD <http://reddes.bvsaude.org/projects/abcd> is a an Open Source web-based integrated library management software developed by BIREME and VLIR (the Flemish Interuniversity Council, Belgium).* It comprises the main basic library functions, including: - Cataloguing of books and serials - End user search (OPAC) - Loans circulation - Acquisitions - Statistics - Library services like SDI, barcode printing, quality control, etc. *For Presentation click here* http://www.slideshare.net/Rasheed1976/presentation-by-rasheedahmedmarch2011 For Download click here http://www.unesco.org/new/en/communication-and-information/access-to-knowle… *Rasheed Ahmed*

3 2

Who manages docs list?
by Nicole Engard 08 Nov '15

08 Nov '15

Hi all, It looks like I got a patch on the docs list earlier this month, but it never came through as an email: https://lists.koha-community.org/cgi-bin/mailman/private/koha-docs/2015-Nov… did anyone else get this email? Thanks Nicole

1 0

3.20 circulation email to staff
by Elaine Bradtke 08 Nov '15

08 Nov '15

We're testing 3.20 before installing it in production. As part of the test, I ran some items through checkout and check in. I was surprised to receive emails about both these actions at the end of the day. I have been digging around in the system preferences, but haven't yet found where to switch this off, or at least change the email address. It wasn't happening in earlier versions, so I assume this is a new feature? -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)

4 6

Re: [Koha] DB errors during upgrade from 3.18.09 to 3.20.04
by Bortel, Gary 06 Nov '15

06 Nov '15

I, too, am seeing these two MySQL errors (1060 & 1062) thrown when trying to update from 3.18.11 --> 3.18.12. There never seemed to be a resolution posted to this issue. Is it benign as Doug suggested or something about which concern should be raised? The installation here is Ubuntu 14.04.3 with a package install of Koha. . . . . Upgrading database schema for abc Upgrade to 3.18.11.001 Done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.18.12.000 Done (3.18.12.000 release) DEV atomic update: hourlyloans.sql C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql: ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit' DEV atomic update: oai_sets.sql C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql: ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY' Upgrading database schema for xyz Upgrade to 3.18.11.001 Done (Bug 14820: SMSSendUsername and SMSSendPassword are not listed in the system preferences) Upgrade to 3.18.12.000 Done (3.18.12.000 release) DEV atomic update: hourlyloans.sql C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql: ERROR 1060 (42S21) at line 1: Duplicate column name 'lengthunit' DEV atomic update: oai_sets.sql C4::Installer::load_sql returned the following errors while attempting to load /usr/share/koha/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql: ERROR 1062 (23000) at line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY' . . . . Thanks gcb > While doing a upgrade on our test koha instance (based on a copy of > production), I received the following errors.: > > - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: C4::Installer::load_sql > returned the following errors while attempting to load > /home/koha/koha-test/intranet/cgi-bin/installer/data/mysql/atomicupdate/hourlyloans.sql: > - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: ERROR 1060 (42S21) at > line 1: Duplicate column name 'lengthunit' > - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: C4::Installer::load_sql > returned the following errors while attempting to load > /home/koha/koha-test/intranet/cgi-bin/installer/data/mysql/atomicupdate/oai_sets.sql: > - [Sat Oct 24 23:52:23 2015] updatedatabase.pl: ERROR 1062 (23000) at > line 35: Duplicate entry 'OAI-PMH:AutoUpdateSets' for key 'PRIMARY' > > I know from previous experience that these kinds of error are sometimes > benign, but I would like some feedback on whether I need to take any kind > of action in this particular case. > > Thanks, > -Doug-

2 1

Koha glacially slow
by Aparrish 05 Nov '15

05 Nov '15

Hello all, Fresh install of Koha on a Debian Jessie computer. The machine has three gigs of RAM and an Athlon dual-core 4050-e. It's about 7 years old so I'm going to assume I just need a better PC, but this Koha instance (a local test server through 127.0.1.1) is so slow it's literally impossible to use, both staff and opac side. It takes about twenty seconds to resolve any request at all. Everything else on the PC is quite snappy though. Am I correct in my suspicion or is something configured incorrectly? -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-glacially-slow-tp5856288.html Sent from the Koha-general mailing list archive at Nabble.com.

6 8

Re: [Koha] Difficulty filling out accounting info
by library 05 Nov '15

05 Nov '15

Hi Jonathan Here's a strange thing. On Friday I paid for our subscription by credit card (in New Zealand but Australian magazine so no tax) then looked up the exchange rate for the day and entered that in NZ$. This is when I got the error — see screen shot. Today I thought I would enter it in AU$ to see what happened and it entered everything fine. I still cannot edit the two middle fields (now the exchange rate is wrong) but at least I can save the item with accounting fields filled out. I would be tempted to leave it like this except I have problems entering donated books where I would like to record the item cost but change it to 100% discount. There is obviously something I haven't understood about the procedure. I have read the manual but it is a bit basic. Thank you very much for your help Regards Ann Murphy Message: 10 Date: Fri, 30 Oct 2015 10:36:09 +0000 From: Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> To: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Difficulty filling out accounting info Message-ID: <CAJzKNY4mSEb2gaU9OQrT9hUkoq2oYbMWUs+91QEqEEYMwyiLRg(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Hi Ann, I confirm that it seems to work for me using 3.20.4 so it certainly comes from your data. Could you please make a screenshot of the form when you get the NaN and give us the rate for the currency you use? Regards, Jonathan 2015-10-29 22:27 GMT+00:00 library <library(a)katikaticollege.school.nz>: > Good morning > > Ever since we were upgraded to 3.20.4 I have had difficulty filling out the > accounting information for each item. I have found a work around for the > books as I can can fill them out using the Uncertain Prices page then edit > each item later, but I cannot do this for the subscriptions. > > Basically as soon as I enter the vendor price the rest of the price fields > change to NaN (have no idea what this means) but the Budgeted cost and > total cost fields are not editable. Then I cannot save because I get the > error message -Total must be a number. > > Could anyone give me a hint as to what is wrong so I can tell our tech > support where to look. > > Gratefully > > Ann Murphy > Katikati College > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha

2 1

General IRC meeting and 3.24 elections in 30 minutes
by Mirko Tietgen 04 Nov '15

04 Nov '15

Hello everyone, just a short reminder that we have a community IRC meeting in half an hour, and we are electing the team for the next release cycle. Please attend and show your support for our volunteers. The meeting agenda can be found at http://wiki.koha-community.org/wiki/General_IRC_meeting_4_November_2015 Candidates for the 3.24 release cycle can be found here http://wiki.koha-community.org/wiki/Roles_for_3.24 See you there http://koha-community.org/get-involved/irc/ Mirko -- Mirko Tietgen mirko(a)abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de

1 0

Fundraising Committee Meeting
by Bob Birchall 04 Nov '15

04 Nov '15

The newly formed Koha fundraising committee held its first meeting on 15 October 2015. Minutes of the meeting have now been uploaded to the Koha wiki: http://wiki.koha-community.org/wiki/Fundraising_IRC_meeting_15_October_2015 A promising start has been made. Cheers, Bob Birchall Calyx

3 2

Attempting to restore server -- aqbasket error
by Boulier, Jack 04 Nov '15

04 Nov '15

I am attempting to restore my new server with the old data from the previous server. Using the command: 'mysql -uroot -p koha_library < koha_library.sql ' I keep getting an error 1005 in line 161. The file name is aqbasket that seems to be missing. I have found that this file is not in the mysql database. Any suggestions are appreciated. Thanks, Jack Jack Boulier, LRC Director 5221 Madison Ave. Sacramento, CA 95841 (916) 339-4370 Direct (916) 339-0305 FAX (916) 339-1500 Main jboulier(a)mticollege.edu

1 0