Re: [Koha] SQL Help - Daily (on Monthly basis) & Monthly (on Yearly basis) Transactions Counts (Circulation)

2017-03-06 Thread Mark Alexander
Excerpts from Barton Chittenden's message of 2017-03-06 08:08:04 -0500: > I'll do the 'month, by year'; the 'day by month' one will follow the same > pattern. > > SELECT > monthname(datetime), > SUM( IF(type = 'issue'), 1, 0 ) as issues, > SUM( IF(type = 'renew'), 1, 0 ) as renewals,

Re: [Koha] Koha 16.11.04 - Setting a template cache directory

2017-03-02 Thread Mark Alexander
Excerpts from Mark Alexander's message of 2017-03-02 15:53:19 -0500: > In this bug comment: > > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17951#c2 > > it was suggested that we use /var/cache/koha//templates, > so that was what I used, and it seems to work fine. I forgot to

Re: [Koha] Koha 16.11.04 - Setting a template cache directory

2017-03-02 Thread Mark Alexander
Excerpts from Craig Butosi's message of 2017-03-02 13:42:07 +: > >You are missing the entry in your koha-conf.xml file. > >That will bring a performance boost to >enable it. > > Is there an expected, standard, or best directory path to use? The error is > clear enough; however, I'd like to

Re: [Koha] cron issue with Koha on Ubuntu

2017-02-23 Thread Mark Alexander
Excerpts from Steve Nickerson's message of 2017-02-23 09:15:26 -0500: > OK, so I dug further and do indeed find cron running and can see the > jobs executing via /var/log/syslog. It appears that everything is > working EXCEPT that the zebra indexing updates aren't working > correctly. I see the

Re: [Koha] cron issue with Koha on Ubuntu

2017-02-21 Thread Mark Alexander
I wrote: > I'm not sure I understand why anacron was required. Looking at this some more, could it be that your server isn't running continuously? The reason I ask is that the file /etc/crontab on Debian 8 looks like this: 17 ** * * rootcd / && run-parts --report /etc/cron.hourly 25

Re: [Koha] cron issue with Koha on Ubuntu

2017-02-21 Thread Mark Alexander
Excerpts from Steve Nickerson's message of 2017-02-20 23:28:51 -0500: > Thank you Mark! As it turns out apparently my issue was that 'cron' was > installed but not 'anacron'. I had those same /etc/cron.d, /etc/cron.daily, > etc. files that you provided, but anacron wasn't installed/running,

Re: [Koha] cron issue with Koha on Ubuntu

2017-02-18 Thread Mark Alexander
Excerpts from Steve Nickerson's message of 2017-02-18 13:38:56 -0500: > 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? Under my 16.11 installation, I see the following cron files, all owned

[Koha] Mandarin conversion scripts

2017-02-18 Thread Mark Alexander
Over the past few months, I have written some scripts to convert Mandarin catalog and patron data into formats suitable for importing into Koha. I have placed these scripts on github, in case there are any other Mandarin users who are also going through the conversion process:

Re: [Koha] Zebra server is not running

2017-02-13 Thread Mark Alexander
Excerpts from Luis Moises Rojas's message of 2017-02-13 10:15:24 -0400: > When i see KOHA ABOUT its says:Zebra service is not running > > But when we try to restart o star using koha-zebra-restart or start: say > > Zebra is already running? > > Where is the problem? > > Is this the cause

Re: [Koha] How to check a file's MIME type in KOHA

2017-02-07 Thread Mark Alexander
Excerpts from Rejeesh K.Nair's message of 2017-02-07 15:49:42 +0530: > I have checked the MIME information of a specific file using its extension. > But actually I need details of exact file. I'm a newbie with the Koha source code. But I'm wondering if there is some way you could use the

Re: [Koha] Hosting options for Koha installation

2017-01-31 Thread Mark Alexander
Excerpts from Lennon Mazonde's message of 2017-01-31 12:38:06 +0200: > I've run Koha using a VPS before, but they are limited in terms of the > resources you get. I found i frequently ran out of inodes and space and > had too many bandwidth limitations. I'd like to know more about this, since

Re: [Koha] Date Wise List of Checked In Books

2017-01-27 Thread Mark Alexander
Excerpts from Scott Owen's message of 2017-01-27 08:08:43 -0500: > SELECT > old_issues.returndate,items.barcode,biblio.title,biblio.author,borrowers.firstname,borrowers.surname,borrowers.cardnumber,borrowers.categorycode > FROM old_issues LEFT JOIN borrowers ON >

[Koha] Mistakes (?) in wiki pages

2017-01-25 Thread Mark Alexander
What is the standard procedure for reporting possible errors in wiki pages? The reason I ask is that during my attempts to install Koha from (1) Debian packages, and (2) a git development environment, I have run into a small number of commands or config file lines in the wiki pages I used that I

Re: [Koha] Checkout limit by household

2017-01-22 Thread Mark Alexander
Excerpts from Katrin's message of 2017-01-23 00:25:38 +0100: > If you add relationships between the members of one household (guarantor > and guarantees), you should be able to see in the staff client what the > other members of the household have checked out when you are in the > patron

[Koha] Checkout limit by household

2017-01-20 Thread Mark Alexander
Our library (running Mandarin currently) has a limit of two DVDs per household. Mandarin doesn't enforce this limit; the librarian knows pretty much everybody in this little town and has the data in her head. But we volunteers don't have that brainpower. I have been working on a Koha upgrade

Re: [Koha] connecting to zs39

2017-01-16 Thread Mark Alexander
Excerpts from Solomon mwangi's message of 2017-01-16 06:09:54 -0600: > question: why does the port need to be greater than 1023? Ports below 1024 are privileged. When I tried using port 210 (the usual port number for Z39.50) I got a "permission denied" error when I restarted Zebra. The error

Re: [Koha] connecting to zs39

2017-01-13 Thread Mark Alexander
Excerpts from Solomon Mwangi's message of 2017-01-13 12:55:12 +0300: > I have Koha running on an Linux server running Ubuntu 12.04 > > Koha runs fine - no issues. > > I have been trying to connect to it via ZS39 but unable to connect. > > Yaz client gives me this error = System (lower-layer)

Re: [Koha] Koha zebra indexing stops every day morning.

2016-12-19 Thread Mark Alexander
Excerpts from Server Room Thane's message of 2016-12-19 13:38:38 +0530: > I am using Koha 16.05.04.000 version on Ubuntu 16.04.1 LTS. Problem is > that, each day morning OPAC searching stops. We checked the status of > Koha-common service. Its active. I ran into this problem, too. It might be

[Koha] Manual locations?

2016-11-23 Thread Mark Alexander
Hi all, I'm not able to find the 16.05 (English) manual. It used to be here: http://translate.koha-community.org/manual/16.05/en/ I don't see it here either: http://translate.koha-community.org/manual/ I took a look at the new Sphinx-ified manual, but it doesn't seem quite ready yet. (I was

Re: [Koha] Can't specify due date/renewal due date in 16.05

2016-11-18 Thread Mark Alexander
Excerpts from King, Fred's message of 2016-11-18 09:43:33 -0500: > Yesterday I upgraded Koha from 3.20 to 16.05, on Ubuntu 14.04LTS. Now we > can't specify a due date for either checkouts or renewals. When we use the > calendar to click on a date nothing happens; when we try to put in a date >

[Koha] logrotate, anacron and bug 16885

2016-11-02 Thread Mark Alexander
This morning I started up my Koha test VM (Debian 8) and around 7:35 plack stopped working. I believe this is the logrotate/zebra death issue mentioned here: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16885 I am running 16.05.04.01 and verified that the patch shown in the above

Re: [Koha] AdvancedSearchTypes and OPAC

2016-10-21 Thread Mark Alexander
Excerpts from Hugo Agud's message of 2016-10-21 15:31:25 +0200: > depending the version of koha you're using and if you have plack enabled or > not... you perhaps need to clean memcache and restart plack > > try > > sudo service memcached restart Thanks, that did it! > sudo koha-plack

[Koha] AdvancedSearchTypes and OPAC

2016-10-21 Thread Mark Alexander
Hi all, I'm trying to add tabs for collections (ccode) and shelving locations (loc) to the advanced search pages for the OPAC client. I set the AdvancedSearchTypes preference to "itemtypes|ccode|loc", and this caused the ccode and loc tabs to appear on the staff client search page, as expected.

Re: [Koha] Hello from Vermont

2016-08-28 Thread Mark Alexander
Excerpts from Joy Nelson's message of 2016-08-28 18:23:32 -0500: > I worked on some mandarin data in the past. Let me know if you have any > questions Thanks, all, for the kind welcome and advice! Right now I'm working on a couple of things: 1. To set the item call number on import, I think I

[Koha] Hello from Vermont

2016-08-28 Thread Mark Alexander
Hi all, I'm a retired software geek, now living in a small town in Vermont after many years in Silicon Valley. I've been using Linux on my own computers for 20 years, and have hacked on everything from microkernels in assembly language to web apps in Ruby on Rails. I also spent a year in NZ as

<    1   2