Re: [Koha] Help! This title cannot be requested

2023-11-30 Thread Katrin Fischer
Hi, some more ideas on what to check in the circulation rules: * Can the item be checked out by this patron? (number of allowed checkouts > 0) * Are there 1 ore more holds allowed? (check all hold relevant settings) For system preferences you could also check MaxReserves. In the item type con

Re: [Koha] Help! This title cannot be requested

2023-11-30 Thread Bruns, Anke
Hi, not being super familiar with circulation rules, but have you checked the current item status? Is it available for loans (item subfield 7 0 or empty), or has it temporarily or permanently another status? Has it any restriction in item subfield 5 or is it marked as lost (subf. 1) or withdr

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-19 Thread Cindy Murdock Ames
That's an interesting thought. I *am* missing the section in my config file, but am I interpreting the patch correctly that it defaults to "1" if it's not present? --- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-19 Thread Jonathan Druart
It would be interesting to revert the changes from 32558 that have been backported into 22.11.04 and see if it helps. Le mer. 19 avr. 2023 à 18:01, Cindy Murdock Ames a écrit : > > Hi Jonathan, > > I just tried sending SHGCHLD to the parent processes, it didn't have any > effect. The parents ar

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-19 Thread Cindy Murdock Ames
Hi Jonathan, I just tried sending SHGCHLD to the parent processes, it didn't have any effect. The parents are "/usr/bin/perl /usr/share/koha/bin/ background_jobs_worker.pl --queue default" and "/usr/bin/perl /usr/share/koha/bin/background_jobs_worker.pl --queue long_tasks". worker-error.log has

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-18 Thread Jonathan Druart
Did you have a look at worker-*.log? Nothing useful there? You can try to send SIGCHLD to the parent to kill the zombie. Le mar. 18 avr. 2023 à 22:09, Cindy Murdock Ames a écrit : > > A few other things I've noticed: > > - Sometimes the zombie processes will go away on their own, sometimes it >

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-18 Thread Cindy Murdock Ames
A few other things I've noticed: - Sometimes the zombie processes will go away on their own, sometimes it seems when you retry the MARC import or whatever it was that failed. This one is really weird to me as in all my years as a sysadmin I thought it was not possible for zombie processes to go a

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-18 Thread Cindy Murdock Ames
Yes, it's 22.11.04, package version. --- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org On Tue, Apr 18, 2023 at 2:59 PM Jonathan Druart < jonathan.dru...@bugs.koha

Re: [Koha] Help needed with zombie background_jobs processes

2023-04-18 Thread Jonathan Druart
Hi Cindy, Which exact version of Koha 22.11.xx? It should be the latest one. Regards, Jonathan Le mar. 18 avr. 2023 à 19:13, Cindy Murdock Ames a écrit : > > Hi all, > > A couple weekends ago I upgraded our Koha instance from 22.05 to 22.11, and > I'm having trouble with the background_jobs proce

Re: [Koha] Help about GDPR policy settings

2021-12-06 Thread Katrin Fischer
Hi, I think it doesn't show in the staff interface, but you could create a report to check for users that haven't accepted. You'd have to look for borrowernumbers not present in the patron_consent table. Hope that helps, Katrin On 02.12.21 13:27, Tadas G wrote: Hello I using Koha 21.05 I set

Re: [Koha] HELP - 502 Proxy error on version 19.11.14

2021-02-26 Thread gveranis
Hi Jose, Do you check the logs from your koha ? under the following path ? /var/log/koha/ Best Regards, George Παραθέτοντας από Jose Ricardo Quaglio : Hi, We used koha in version 19.11.09.000, when upgrading to version 19.11.14.000 we see a performance difference when running resources.

Re: [Koha] Help debugging Internal Server Error

2021-02-22 Thread skaman.tx
ey did not tank Koha altogether. 20.06 to 20.11 though is another story. Scott -Original Message- From: Doug Dearden Sent: Monday, February 22, 2021 4:05 PM To: skaman...@gmail.com Cc: koha@lists.katipo.co.nz Subject: RE: [Koha] Help debugging Internal Server Error Hey Scott, What versi

Re: [Koha] Help debugging Internal Server Error

2021-02-22 Thread Doug Dearden
kaman...@gmail.com] Sent: Friday, February 19, 2021 12:32 PM To: Doug Dearden ; 'Alvaro Cornejo' Cc: koha@lists.katipo.co.nz Subject: RE: [Koha] Help debugging Internal Server Error Doug, I would love to hear the same. I have been unsuccessfully fighting an upgrade from 19.05 to 20.11.x for

Re: [Koha] Help debugging Internal Server Error

2021-02-19 Thread Doug Dearden
koha@lists.katipo.co.nz Subject: Re: [Koha] Help debugging Internal Server Error Hey Everyone, Thank you Alvaro and Jonathan for your help, I wanted to report back that I got this fixed and what the problem was in case someone else runs into this. An error in the plack-opac-error.log appears, and the

Re: [Koha] Help debugging Internal Server Error

2021-02-19 Thread skaman.tx
someone can share this information. Scott -Original Message- From: Koha On Behalf Of Doug Dearden Sent: Friday, February 19, 2021 1:22 PM To: Alvaro Cornejo Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Help debugging Internal Server Error Hey Everyone, Thank you Alvaro and Jonathan

Re: [Koha] Help debugging Internal Server Error

2021-02-19 Thread Doug Dearden
Hey Everyone, Thank you Alvaro and Jonathan for your help, I wanted to report back that I got this fixed and what the problem was in case someone else runs into this. An error in the plack-opac-error.log appears, and the same warning appears when I did koha-rebuild-zebra with the –v option: DB

Re: [Koha] Help debugging Internal Server Error

2021-02-18 Thread Jonathan Druart
Yes, you should rerun the upgrade-schema script on the backup. Le ven. 19 févr. 2021 à 00:45, Doug Dearden a écrit : > Hey Alvaro, > > > > Forgot to hit reply all to my last message so am including the list and > Jonathan on this one. > > > > I looked at the database in the new test instance and

Re: [Koha] Help debugging Internal Server Error

2021-02-18 Thread Doug Dearden
asrv(425530) [warn] ir_session (exception) 13:15:19-17/02 zebrasrv(425531) [warn] ir_session (exception) 13:15:22-17/02 zebrasrv(425532) [warn] ir_session (exception) 13:15:25-17/02 zebrasrv(425533) [warn] ir_session (exception) 13:15:30-17/02 zebrasrv(425534) [warn] ir_session (exception) 13:15:31

Re: [Koha] Help debugging Internal Server Error

2021-02-18 Thread Jonathan Druart
Hey, Buster is Debian 10, not 11! So we are supporting it and it's known to work correctly! Le jeu. 18 févr. 2021 à 10:11, Jonathan Druart a écrit : > > Hello Doug, > > What do you see in the other error log files? (tail -f > /var/log/koha//*.log) > > Our support for "buster" is buggy at the mome

Re: [Koha] Help debugging Internal Server Error

2021-02-18 Thread Jonathan Druart
Hello Doug, What do you see in the other error log files? (tail -f /var/log/koha//*.log) Our support for "buster" is buggy at the moment. Have a look at bug 26893 (New version of JSON::Validator (D11) breaks our REST API routes) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26893 Reg

Re: [Koha] Help with shelf browser and classification source

2021-01-18 Thread Katrin Fischer
-feira, 1 de janeiro de 2021 17:53 Para: Inês M. Ferreira ; koha@lists.katipo.co.nz Assunto: Re: [Koha] Help with shelf browser and classification source Hi, there are several options, depending a bit on how many items you have. You can use the batch item edit tool or you could change the field in

Re: [Koha] Help with shelf browser and classification source

2021-01-18 Thread Inês M . Ferreira
. De: Katrin Fischer Enviado: sexta-feira, 1 de janeiro de 2021 17:53 Para: Inês M. Ferreira ; koha@lists.katipo.co.nz Assunto: Re: [Koha] Help with shelf browser and classification source Hi, there are several options, depending a bit on how many items you have. You can use the batch

Re: [Koha] Help regarding display of title field based in condition

2021-01-09 Thread Katrin Fischer
Hi, currently the 246 will display also, but cannot replace the 245 in display. You could customize your XSLT templates to achieve that. There are some examples for customizations on the wiki: https://wiki.koha-community.org/wiki/XSLT_Overview https://wiki.koha-community.org/wiki/XSLT_Library H

Re: [Koha] Help with shelf browser and classification source

2021-01-01 Thread Katrin Fischer
*From:* Koha on behalf of Katrin Fischer *Sent:* Tuesday, December 29, 2020 11:42:41 PM *To:* koha@lists.katipo.co.nz *Subject:* Re: [Koha] Help with shelf browser and classification source Hi Ines, I think once your search is fixed, the shelf browser

Re: [Koha] Help with shelf browser and classification source

2020-12-29 Thread Inês M . Ferreira
Thank you very much for your reply. I do have one question. How do I bulk edit all items to the right code? Regards, Inês From: Koha on behalf of Katrin Fischer Sent: Tuesday, December 29, 2020 11:42:41 PM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Help

Re: [Koha] Help with shelf browser and classification source

2020-12-29 Thread Katrin Fischer
Hi Ines, I think once your search is fixed, the shelf browser might be working again. You can also check the various shelf browser prefs to make sure that your new locations are taken into account. For the classification source: The DefaultClassificationSource preference will change the default

Re: [Koha] Help with SQL script please

2020-08-26 Thread Ian Bays
Hi Carlos. Your SQL does not need type-casting. It is just missing an @ and a couple of " in the ExtractValue for the 100 tag. It should be: WHERE ExtractValue(metadata, '//datafield[@tag="100"]/subfield[@code="9"]') IN rather than WHERE ExtractValue(metadata, '//datafield[tag=10

Re: [Koha] Help with SQL script please

2020-08-25 Thread Carlos Lopez
Hi all I sent this through yesterday (see below) and it's really annoying me: The query seems to bring up 0 results when I'm trying to compare authids (UNSIGNED) to an ExtractValue string from biblio_metadata.metadata (LONGTEXT?). Is this even possible? If so, how do I go about CONVERTing my au

Re: [Koha] Help with SQL script please

2020-08-24 Thread Alvaro Cornejo
Hi Gustavo Not sure where the error might be but for troubleshooting you can split your query from the inside out and see where it stops working. Also, if you do know the values for Jesuit%, you might replace that query with a list of values or a specific value for testing purposes. A) Test

Re: [Koha] Help with a report query

2019-09-24 Thread Carlos Lopez
.vic.edu.au | library.dmlibrary.org.au -Original Message- From: Koha On Behalf Of Kerrie Stevens Sent: Wednesday, 25 September 2019 10:46 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Help with a report query Adding to this report from Carlos below, we have multiple campuses so I'd

Re: [Koha] Help with a report query

2019-09-24 Thread Kerrie Stevens
ne Campus HDR Liaison Librarian ALPHACRUCIS COLLEGE -- Message: 2 Date: Mon, 23 Sep 2019 21:17:25 -0700 From: Eric Phetteplace To: Carlos Lopez Cc: koha Subject: Re: [Koha] Help with a report query Message-ID: Content-Type: text/plain; charset="UTF-8" Hi Carl

Re: [Koha] Help with a report query

2019-09-23 Thread Katrin Fischer
Hi Carlos, what I usually do for years is a free text entry: <> or similar. So you could just switch out YEAR(NOW()) for that in your query below. We always try to use the statistics tables where possible as it's usually faster than having to work with than a union of issues and old_issues. Hop

Re: [Koha] Help with a report query

2019-09-23 Thread Eric Phetteplace
Hi Carlos, Your report is actually very close to doing that already. Since you're already limiting by year in your WHERE clause, you just need to change it to accept a parameter instead of using YEAR(NOW()). So this should do want you want: SELECT monthname(datetime) month, type, count(datetime)

Re: [Koha] Help restoring OPAC search box

2019-09-22 Thread Katrin Fischer
Hi, On 09.09.19 19:20, Sayward Schoonmaker wrote I copied and pasted some code from ByWaterSolutions into the OpacCustomSearch field (which was empty) and in doing so I unintentionally erased the library branch pulldown menu from the main search page. Is there a way to return to the default sea

Re: [Koha] Help Me....................

2019-09-10 Thread vikram zadgaonkar
Dear Rajesh, You need to take a cloud and install koha on that. For professional services you may contact Mr. Anant Kulkarni on +919075008487. Vikram Zadgaonkar

Re: [Koha] help with SQL query for the existence of a MARC field?

2019-05-09 Thread Eric Phetteplace
Hi Jason, I think the syntax you want is just to check an ExtractValue statement against the text being an empty string. So, for instance, to modify your report to return only those records with 490 fields it would be: SELECT biblio.biblionumber, biblio.title FROM biblio_metadata JOIN biblio ON (

Re: [Koha] Help with barcode encoding

2019-04-18 Thread Coehoorn, Joel
Koha doesn't care what format you use. What matters is what kind of barcode reader/scanner hardware you have... and even there, most barcode readers can handle several different formats. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoeho...@york.edu * *Please contact helpd...@y

Re: [Koha] Help with barcode encoding

2019-04-18 Thread Chris Brown
Hi Christopher, I am not an expert on these things but I think the question is "what barcode formats will my barcode reader handle?". So long as Koha gets numerical data it doesn't care whether you typed it in on the keyboard or scanned it in with the barcode reader. The barcode reader is support

Re: [Koha] Help with SQL report

2019-01-25 Thread Caroline Cyr-La-Rose
Hi Christopher, Do you use the acquisitions module? If not, what MARC field is your vendor information in? If you use the acquisitions module, you can try this SELECT     biblionumber AS "" FROM     aqorders LEFT JOIN aqbasket USING (basketno) LEFT JOIN aqbooksellers ON (aqbasket.booksellerid

Re: [Koha] Help required for problem related with KOHA

2018-12-05 Thread Jonathan Druart
Hi, What is you version of Koha? Le mar. 20 nov. 2018 à 02:53, D Thma a écrit : > > Dear , > > Help is required to rectify the problem crop up while trying to access KOHA > ... > > The problem generated is as follows : > Software error: > > Can't call method "STORE" on an undefined value at > /u

Re: [Koha] Help testing marc staging performance issues

2018-10-05 Thread Barton Chittenden
So, looking around, I see some bugs that seem to cover the same ground: Bug 17240 - "Allow processes that rely on background jobs run in Plack mode" Bug 15032 - [Plack] Scripts that fork (like stage-marc-import.pl) don't work as expected Bug 20342 - Fix table locking issue, progress bar not upda

Re: [Koha] help

2018-10-03 Thread Narcis Garcia
Please, descibe concrete steps about each of these tasks. El 02/10/18 a les 23:41, rodrigo aleman ha escrit: > Hi everyone, > > In the Marc template I have the registry set up, but when I'm going to > register that item it won't let me, and I can't see the item's information, > how can I solve t

Re: [Koha] Help testing marc staging performance issues

2018-09-20 Thread Barton Chittenden
Tomas, Do you know if there's a bug open for this? If not, would you mind filing one? Thanks, --Barton On Wed, Sep 19, 2018 at 7:57 PM, Tomas Cohen Arazi wrote: > We should really do a two-pass processing, so the first thing is > calculating the batch size. That way Ajax will not timeout. > >

Re: [Koha] Help testing marc staging performance issues

2018-09-19 Thread Tomas Cohen Arazi
We should really do a two-pass processing, so the first thing is calculating the batch size. That way Ajax will not timeout. El mié., 19 de sep. de 2018 20:04, Barton Chittenden < bar...@bywatersolutions.com> escribió: > On Wed, Sep 19, 2018 at 6:29 PM, Jonathan Druart < > jonathan.dru...@bugs.ko

Re: [Koha] Help testing marc staging performance issues

2018-09-19 Thread Barton Chittenden
On Wed, Sep 19, 2018 at 6:29 PM, Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hi Barton, > > > I believe this typically happens under plack. > > These scripts should not run under plack, check your apache config file > (search for "ProxyPass" in apache-shared-intranet-plack.

Re: [Koha] Help testing marc staging performance issues

2018-09-19 Thread Jonathan Druart
Hi Barton, > I believe this typically happens under plack. These scripts should not run under plack, check your apache config file (search for "ProxyPass" in apache-shared-intranet-plack.conf) Cheers, Jonathan On Wed, 19 Sep 2018 at 19:17 Barton Chittenden wrote: > Hi, All! > > At ByWater, we

Re: [Koha] Help with error (menus)

2018-07-18 Thread Narcis Garcia
What made the difference? Change in configuration settings? OS upgrade? Koha upgrade? Web browser upgrade? Different web browser? New browser protection plugin? Time ago? El 19/07/18 a les 04:35, Luis Bernardo Olarte Jaramillo ha escrit: > Hello everyone, > > I would like to share an incident t

Re: [Koha] Help with funding the koha-community.org webserver (also short outage for Linode free upgrade!)

2018-06-06 Thread Liz Rea
Further to that, I do mostly keep the work on the website separate from the work I do for Catalyst. That excepts the occasional urgent apt or wordpress upgrade that has to happen during working hours, or urgent help requests from members of the community in relation to working with the website. I'

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-06 Thread Chris Cormack
Kia ora tātou Yay, so great to see how fast this was funded! Just a bit of background. After what happened in 2009 when we had a company in control of lots of our infrastructure, we decided to never let that happen again. Hence Liz running the www.koha-community.org site (rather than say Catalyst

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-06 Thread Liz Rea
Victory, everyone! Goal achieved and the website is golden for another year! Thank you all so much <3 The Koha community is truly awesome. Now... To go freshen up that website :D Cheers, Liz On Wed, 6 Jun 2018, 20:39 Narcis Garcia, wrote: > It's time to propose a better alternative for send

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-06 Thread Narcis Garcia
It's time to propose a better alternative for sending money: https://en.wikipedia.org/wiki/List_of_online_payment_service_providers El 06/06/18 a les 07:54, Michael Kuhn ha escrit: > Hi Liz > >> I have set up a ko-fi at https://ko-fi.com/lizrea and you can >> contribute there > > Sorry, but I d

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-05 Thread Michael Kuhn
Hi Liz > I have set up a ko-fi at https://ko-fi.com/lizrea and you can > contribute there Sorry, but I don't like Paypal and I don't want to set up an account there. But as said I will contribute immediately if you send me the necessary details (bank account etc). Best wishes: Michael -- Ges

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-05 Thread Liz Rea
Oh everyone, you are really the best folks anywhere. I have set up a ko-fi at https://ko-fi.com/lizrea and you can contribute there Why don't you all chip in a little and we can get this done lickety split and tjay way nobody gets stuck with it all <3 <3 Thank you all so much! Liz (wizzyrea) O

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-05 Thread Chris Brown
Liz, I would be happy to chip in if you come up with an easy way to pay. Perhaps you could set up a PayPal account? Best Regards, Chris Brown On Tue, Jun 5, 2018 at 10:21 PM, Liz Rea wrote: > Hi all, > I've been funding the koha-community web server for about 5 years now, and > I've been hap

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-05 Thread Joann Ransom
I totally love the Koha community including for reasons just like this. J On Wed, 6 Jun 2018, 16:52 Marc Véron, wrote: > Hi Liz > > Tanks a lot for funding the Koha community server for years. > > I will be happy to pay the server for this year ( $308 NZD ). > > Please send your banking informa

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-05 Thread Michael Kuhn
Hi Liz > The server is paid for yearly, this year it was $308 NZD It's all paid > up until June of next year. > > If you'd be interested in tossing a few dollars my way to support > running the website, I'd be really grateful. I think it would be > better to have a community funded server anyway.

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-05 Thread Marc Véron
Hi Liz Tanks a lot for funding the Koha community server for years. I will be happy to pay the server for this year ( $308 NZD ). Please send your banking information to me. Have a great day Marc Am 05.06.2018 um 23:21 schrieb Liz Rea: Hi all, I've been funding the koha-community web serve

Re: [Koha] help me auto increment issue to be fixed

2018-05-30 Thread Jonathan Druart
Hello, Did you read the wiki page? Do you understand the problem? Regards, Jonathan On Wed, 30 May 2018 at 04:28 takan bhatt wrote: > Data problems > > Some of your tables have problems with their auto_increment values which > may lead to data loss. > > *You should not ignore this warning.* >

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-03 Thread Jonathan Druart
Mason opened bug 20693 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20693 On Tue, 1 May 2018 at 22:49 Tomas Cohen Arazi wrote: > Not using Plack is unacceptable nowadays. > > Maybe a 3x speed gain is a good argument. And we still use the old and > loved Apache server in front of it.

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread Tomas Cohen Arazi
Not using Plack is unacceptable nowadays. Maybe a 3x speed gain is a good argument. And we still use the old and loved Apache server in front of it. As for the install not pulling the dependencies, please file a bug so the packaging manager takes care. El mar., 1 de may. de 2018 7:20 p. m., Paul

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread Paul A
On 2018-05-01 05:37 PM, Mason James wrote: On 2/05/18 9:11 am, Mason James wrote: [snip] aah, false alarm... :) # aptitude why  libcgi-emulate-psgi-perl i   koha-common   Depends    starman Yup -- we're running (testing Ubuntu 18.04) into the same sort of problem. Apparently (could be wrong

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread Mason James
On 2/05/18 9:11 am, Mason James wrote: > hmm, i think this may be a possible bug... > > 'libcgi-emulate-psgi-perl' doesn't seem to be listed as an explicit > dependency for any koha* package > > > so, it seems probable that this package wouldn't be installed by default :'( > (am i missing somethin

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread Mason James
hmm, i think this may be a possible bug... 'libcgi-emulate-psgi-perl' doesn't seem to be listed as an explicit dependency for any koha* package so, it seems probable that this package wouldn't be installed by default :'( (am i missing something here?) Mason On 2/05/18 8:40 am, Piotr Wejman wr

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread Piotr Wejman
Hi, I've just finished setting Plack, so few tips which you may find helpfull: - you probably need to install libcgi-emulate-psgi-perl libcgi-compile-perl (not sure if packaged for Ubuntu 16.04, I'm using Debian 9.4) - If you;re missing any perl modules, try to google them first and check if they

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread ksorbo
I followed those koha-plack steps. When I do that I get the following error in my /var/log/koha/plack-error.log - Error while loading /etc/koha/plack.psgi: Can't locate CGI/Emulate/PSGI.pm in @INC (you may need to install the CGI::Emulate::PSGI module) (@INC co

Re: [Koha] Help Installing Plack on Koha 17.11

2018-05-01 Thread Tomas Cohen Arazi
Once you created the instance you just need to run $ koha-plack --enable instance $ koha-plack --start instance $ service apache2 restart Enjoy El mar., 1 de may. de 2018 2:52 p. m., ksorbo escribió: > /Running Ubuntu 16.04, mariadb, Koha 17.11/ > > I have installed Koha on a testing server. K

Re: [Koha] Help me

2018-02-28 Thread Katrin Fischer
Hi, please always include your Koha version and some information about the steps that led to the error. It's often hard to tell what happened from the error message alone and it will make it easier to help you. The Koha version can be found on the "About" page. From the link it looks like yo

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Elaine Bradtke
Thanks everyone! I added the limit by biblio number and this works: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemn

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Elaine Bradtke
OK, that works. Now I just need to limit it to the range of biblio numbers. I think I can manage that. 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

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Jonathan Druart
Sorry, I badly pasted the query. Try: SELECT biblioitems.biblionumber,biblio.title,biblio.copyrightdate, ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Elaine Bradtke
this time it says: 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 'JOIN biblio_metadata m ON (biblio.biblionumber=m.biblionumber) ORDER BY biblio' at line 7 I think we're getting closer. Elaine Bradtke Data Wran

Re: [Koha] Help Me

2017-10-09 Thread King, Fred
se Sent: Monday, October 09, 2017 9:03 AM To: Tim Young Cc: KOHA Subject: Re: [Koha] Help Me I should have more clear on my response. I use the Dedicated Server solution at https://urldefense.proofpoint.com/v2/url?u=http-3A__atlantic.net&d=DwIGaQ&c=RvBXVp2Kc-itN3g6r3sN0Q

Re: [Koha] Help Me

2017-10-09 Thread Martin House
I should have more clear on my response. I use the Dedicated Server solution at atlantic.net, but my actual server is hosted in Canada. It seems that the closest server solution near you would be Singapore, not sure that's close enough. But I do think that you need to find a dedicated server soluti

Re: [Koha] Help Me

2017-10-09 Thread Martin House
I have been successfully running Koha on a cloud server over at www.atlantic.net. The most basic setup will cost you about $10 per month with backups. We are currently paying $50 for 4GB Ram and plenty of HD space. Although, we are about to upgrade RAM to 8GB to increase speed. Martin House martin

Re: [Koha] Help Me

2017-10-09 Thread Tim Young
Hi, I see that you do have a local Koha install.  I am assuming that someone set it up for you and that you are trying to do something with it now that you have it set up? I also see that you are coming from India.  You do well with your English. Kindly add more details. Am I right in think

Re: [Koha] Help Me

2017-10-09 Thread vikram zadgaonkar
Dear Friend, You need koha cloud hosting service provider. Let me know if you need more details. On Oct 9, 2017 5:13 PM, "Rajesh Shelar" wrote: > Dears Friends, > I am using the Koha Open Source library software ,so Please send me the > Details of Library Catalog add in koha cloud base . i

Re: [Koha] Help Me

2017-10-09 Thread Michael Kuhn
Hi Rajesh > I am using the Koha Open Source library software ,so Please send me > the Details of Library Catalog add in koha cloud base . i humbly > request please help me . There is no such thing as an official "Koha cloud base". Maybe you are customer of a specific endor, so you should conta

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Jonathan Druart
Since 17196 (17.05) you need to join on biblio_metadata Try the following query: SELECT biblioitems.biblionumber, biblio.title, biblio.copyrightdate, ExtractValue(m.metadata, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioi

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Barton Chittenden
Elaine, In 17.05, biblioitems.marcxml was moved to biblio_metadata.metadata. --Barton On Thu, Oct 5, 2017 at 10:43 AM, Elaine Bradtke wrote: > It gives the error message: > *The following error was encountered:* > The database returned the following error: > Unknown column 'biblioitems.marcxml

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Elaine Bradtke
It gives the error message: *The following error was encountered:* The database returned the following error: Unknown column 'biblioitems.marcxml' in 'field list' Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, L

Re: [Koha] Help needed with SQL report

2017-10-05 Thread Holger Meissner
Hi Elaine, how about this: SELECT biblioitems.biblionumber, biblio.title, ExtractValue(biblioitems.marcxml, '//datafield[@tag="260"]/subfield[@code="c"]') AS text FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitem

Re: [Koha] Help Me

2017-08-26 Thread Eric Bégin
Rajesh, All MARC21 fields/subfields are available at the following link https://www.loc.gov/marc/bibliographic/ Regards, Eric Bégin Solutions inLibro inc. Message d'origine De : Rajesh Shelar Date : 25/08/2017 23:48 (GMT-05:00) À : Koha Objet : [Koha] Help Me Dear

Re: [Koha] Help Me

2017-08-23 Thread vinod mishra
Dear Mr. Sanjay and Rajesh Please see the below link https://wiki.koha-community.org/wiki/Holdings_data_fields_(9xx) With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 Website: http://mish

Re: [Koha] Help Me

2017-08-23 Thread Sanjay Jha
Dear Sir, Bill Date 952$w, Bill no. 952$f With deepest regards Sanjay Kumar Jha Asst.Librarian(M.Phil LIS) Central Library, Amity University From: Koha on behalf of Rajesh Shelar Sent: 23 August 2017 17:06 To: Koha Subject: [Koha] Help Me Dear Frien

Re: [Koha] Help please! we have problem after upgrading ubuntu from 11.10 up to 12.04

2017-07-03 Thread Luis Moises Rojas
Hello, I am a little late, but, can you tell the problem again? On Mon, Jul 3, 2017 at 9:11 AM, Деловой Библиотекарь wrote: > Hi, Tim! > > > > Ok. Did you change versions of Koha during your upgrade? Or just > upgrade > > your operating system? > > [Николай Ластовка] yes, I just upgrade Ubuntu

Re: [Koha] Help please! we have problem after upgrading ubuntu from 11.10 up to 12.04

2017-07-03 Thread Деловой Библиотекарь
Hi, Tim! > Ok. Did you change versions of Koha during your upgrade? Or just upgrade > your operating system? [Николай Ластовка] yes, I just upgrade Ubuntu > Great! Sadly, this is as far as my personal help can help you. From here, > someone else who is better versed in Koha will need to jum

Re: [Koha] Help please! we have problem after upgrading ubuntu from 11.10 up to 12.04

2017-06-27 Thread Tim Young
On 6/27/2017 9:08 AM, "D DuD>DtD2DtD1 D'D,D+D>D,DtN,DuD0DoN N "@LightSys.org wrote: Hi, Tim It would be helpful to know if you upgraded using package or tarball. [Николай Ластовка] I upgraded start command "do-upgrade-release", I have no mind is it package or tarball, sorry! Ok. Did you c

Re: [Koha] Help please! we have problem after upgrading ubuntu from 11.10 up to 12.04

2017-06-27 Thread Lamb Joseph
Nicolay, This is the upgrade procedure that I recently used. - Install Ubuntu server 16.04. I ran up a new host on my ESXi server. - I followed the install procedure from the wiki (https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages). I used Mariadb - I replaced the "li

Re: [Koha] Help please! we have problem after upgrading ubuntu from 11.10 up to 12.04

2017-06-27 Thread Деловой Библиотекарь
Hi, Tim > It would be helpful to know if you upgraded using package or tarball. [Николай Ластовка] I upgraded start command "do-upgrade-release", I have no mind is it package or tarball, sorry! > > It also helps to know what *nix distro you are using (Centos, Ubuntu, etc) > [Николай Ластовка]

Re: [Koha] Help please! we have problem after upgrading ubuntu from 11.10 up to 12.04

2017-06-27 Thread Tim Young
Greetings, It would be helpful to know if you upgraded using package or tarball. It also helps to know what *nix distro you are using (Centos, Ubuntu, etc) It looks like you may need to install a package? You can usually see if the package is installed by running: locate Cache/Memcached.pm If

Re: [Koha] Help - Email lookup while using lists

2017-05-03 Thread Indranil Das Gupta
Druart) > >2. Re: Circulation - Notices (over due) - help (Barton Chittenden) > >3. Re: Help - Email lookup while using lists (Jonathan Druart) > >4. Koha Community Newsletter: March 2017 (kohanews) > > > > > > --

Re: [Koha] Help - Email lookup while using lists

2017-05-03 Thread Suresh Kumar Tejomurtula
on - Notices (over due) - help (Barton Chittenden) >3. Re: Help - Email lookup while using lists (Jonathan Druart) >4. Koha Community Newsletter: March 2017 (kohanews) > > > -- > > Message: 1 > Date: Fri,

Re: [Koha] Help - Email lookup while using lists

2017-03-31 Thread Jonathan Druart
Well, it could be on the staff interface, not the OPAC. That would be a big privacy problem On Fri, 31 Mar 2017 at 11:44 Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hello, > > No this is not implemented, but could be. > > Regards, > Jonathan > > > On Fri, 31 Mar 2017 at 11

Re: [Koha] Help - Email lookup while using lists

2017-03-31 Thread Jonathan Druart
Hello, No this is not implemented, but could be. Regards, Jonathan On Fri, 31 Mar 2017 at 11:05 Suresh Kumar Tejomurtula wrote: > Dear all, > > Is there any option to lookup for sending emails using lists or cart in > koha opac. > > What iam looking is if I type a name when trying to send emai

Re: [Koha] Help - Patrons Deletions- best practice

2017-03-21 Thread Sawers, Colin
[mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of vanda koha Sent: 21 March 2017 10:07 To: SATISH Cc: Koha Subject: Re: [Koha] Help - Patrons Deletions- best practice Hi Satish, I have worked in a College library and we have never erased the patrons from our databese: we just blocked the students

Re: [Koha] Help - Patrons Deletions- best practice

2017-03-21 Thread vanda koha
Hi Satish, I have worked in a College library and we have never erased the patrons from our databese: we just blocked the students access when they finished their course. As simple as that. I think that's the best policy. Imagnie that later on they decide to attend another course: you'll just have

Re: [Koha] Help - Patrons Deletions- best practice

2017-03-21 Thread SATISH
Hi, Your answers will be highly appreciated. Kindly share your best practices. On 17 March 2017 at 12:41, SATISH wrote: > Hi, > > Currently With Koha 16.5/Package Installation/ Ubuntu 14.04 Desktop / > > Since last six months I am using Koha (production / live) in the Library. > Now, one batc

Re: [Koha] Help: Patron Cards Creation Fields Not Responding

2017-03-10 Thread Marc Véron
Dear Olufunmilayo Error reproduced and found. I filed a bug with a patch: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18244 (ready for Signoff) Kind regards Marc Am 10.03.2017 um 09:52 schrieb olufunmilayo favour: Dear All, My name is Olufunmilayo. I am a Systems Librarian wit

Re: [Koha] Help needed in advanced searching with barcode

2017-01-25 Thread vikram zadgaonkar
Hi, You can use bc:35 to search particular barcode or use advance search. On 26-Jan-2017 10:20 AM, "Tanzeem M.B" wrote: When I search for a bibliographic record using advanced search with barcode eg 35 I get all the records with barcode containing 35, ie 135,35, 3501 etc. how can I limit the se

Re: [Koha] Help I can't search my Koah 16.05.05.000 catalog

2016-11-04 Thread Jonathan Druart
Hi Dennie, Whaou, from Koha 2.2.9 to 16.05.05, such a big step! How did you migrate? Did you follow a tutorial? Give us more information and we will be able to help you. Regards, Jonathan On Fri, 4 Nov 2016 at 03:56 dgum wrote: > Hello my name is Dennie Gum and I work for a small library in N

  1   2   3   >