Re: [Koha] How disable sending email

2017-04-05 Thread Jonathan Druart
Hi Tim, This is certainly dues to bug 15854. It has been fixed in all stable releases. Regards, Jonathan On Wed, 5 Apr 2017 at 14:37 Tim Koop wrote: > Our Koha is sending duplicated emails for checkin notices. > > Is there an easy way to disable this for everybody until

Re: [Koha] Slow Koha OPAC login process

2017-04-17 Thread Jonathan Druart
Hello Michael, How many issues and holds has the patron? Regards, Jonathan On Thu, 13 Apr 2017 at 15:13 Michael Kuhn wrote: > Hi > > We're running a new host with Debian GNU/Linux 8 and Koha 16.11.04. > > Usually the Koha OPAC login process is quick as expected. But

Re: [Koha] Koha upgrade from 3.16 to 16.11

2017-04-19 Thread Jonathan Druart
Nicolas, what you describe can be ok, if the tax rate is 0. You need to provide ALL the price values from aqorders (quantity, listprice, unitprice, unitprice_tax_excluded, unitprice_tax_included, quantityreceived, rrp, rrp_tax_excluded, rrp_tax_included, ecost, ecost_tax_excluded,

Re: [Koha] Koha upgrade from 3.16 to 16.11

2017-04-21 Thread Jonathan Druart
Nick did open one, there is a patch to signoff, see bug 18471. On Thu, 20 Apr 2017 at 11:38 Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Yes indeed, the formatting should be done template side. > They are the only 2 occurrences of this kind apparently. > Did

Re: [Koha] Koha upgrade from 3.16 to 16.11

2017-04-20 Thread Jonathan Druart
-E 'say "2,2" + 2' > 4 > $ perl -E 'say "2.2" + 2' > 4.2 > > > 2017-04-19 17:43 GMT+02:00 Jonathan Druart > <jonathan.dru...@bugs.koha-community.org>: > > Nicolas, what you describe can be ok, if the tax rate is 0. > > You need to prov

Re: [Koha] Search page don't always show results when it should

2017-04-20 Thread Jonathan Druart
Ha! bug 2422 comment 17, turn off UseQueryParser On Thu, 20 Apr 2017 at 11:13 Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Got access to the OPAC. > We already seen this error before but cannot remember what was the cause: > > If you search for 'europe

Re: [Koha] Software error: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column

2017-04-20 Thread Jonathan Druart
Restart plack On Thu, 20 Apr 2017 at 10:26 Vimal Kumar V. wrote: > Dear Friends, > I got following error when restored an old version of Koha to latest > version. > The error shown after loginto Koha staff client. Here is the error message: > > Software error: >

Re: [Koha] Search page don't always show results when it should

2017-04-20 Thread Jonathan Druart
Got access to the OPAC. We already seen this error before but cannot remember what was the cause: If you search for 'europe': /cgi-bin/koha/opac-search.pl?q=europe_group_limit= The link to page 2 is: http://81.57.170.67/cgi-bin/koha/opac-search.pl?q=europe%20%23relevance_asc=60_by=relevance_asc

Re: [Koha] Slow Koha OPAC login process

2017-04-18 Thread Jonathan Druart
prctl >0.000.00 0 2 openat > -- --- --- - - ---- > 100.00 0.00 159942 total > > I wonder if this output is helpful? > > Best wishes: Michael > > > >

Re: [Koha] Koha upgrade from 3.16 to 16.11

2017-04-18 Thread Jonathan Druart
Hi Hugo, A big work has been done in price calculation in 16.11, see bug 13321 and related. It certainly comes from these patches. I guess you can see differences in orders as well? If you find one, would you be able to give us the vendor and order tax configuration as well as the prices and

Re: [Koha] Slow Koha OPAC login process

2017-04-18 Thread Jonathan Druart
Use `strace -c -p PID` and paste the whole output please (hastebin or similar) On Tue, 18 Apr 2017 at 10:23 Michael Kuhn wrote: > Hi Marc and Jonatahn > > Marc wrote: > > > What version of Koha is it? > > We're running a new host with Debian GNU/Linux 8 and Koha 16.11.04. >

Re: [Koha] Slow Koha OPAC login process

2017-04-18 Thread Jonathan Druart
There are now 766 calls vs 1599 in your previous paste. I would have expected more, less does not help :) If it is the pl script execution that takes 30s, it should not come from network latencies. On Tue, 18 Apr 2017 at 13:09 Michael Kuhn wrote: > Hi Jonathan > > > I do not

Re: [Koha] Stuff is experimental response from cron

2017-03-09 Thread Jonathan Druart
You are certainly running an old version of Koha, this warning has been removed in recent versions. You can ignore it anyway. On Thu, 9 Mar 2017 at 14:01 Tim Koop wrote: > I get emails from my Koha server with the subject: > Cron koha-foreach --enabled --email

Re: [Koha] Duplicated Emails

2017-03-09 Thread Jonathan Druart
Hi Tim, Does it occur for checkin and renewal notices? In that case, see bug 15854 Regards, Jonathan On Thu, 9 Mar 2017 at 13:57 Tim Koop wrote: > Some of our people are complaining about getting duplicated emails. > > Does anybody have any ideas how to diagnose or fix

Re: [Koha] Duplicated Emails

2017-03-09 Thread Jonathan Druart
rsion of > Koha? Or is it a simple fix? What do you recommend I do? > > Thanks! > > -- > Tim > > -Original Message- > From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan > Druart > Sent: Thursday, March 09, 2017 11:15 AM > To: koha@list

Re: [Koha] Facets show more link with elastic search

2017-03-09 Thread Jonathan Druart
Hello Yousef, Could you give us the url before you click on the "Show more" link, then the url generated after you clicked. Please do not send your question to both koha and koha-devel mailing lists. Regards, Jonathan On Thu, 9 Mar 2017 at 03:05 Abdulsalam Yousef wrote: >

Re: [Koha] Add pictures in notices

2017-03-14 Thread Jonathan Druart
And you can use the pref NoticeCSS to add some CSS. On Tue, 14 Mar 2017 at 13:04 Katrin wrote: > Hi Sonia, > > I think there is no 'graphical' way of doing this, but you can use plain > HTML. For testing I just added this to the DISCHARGE notice template: > >

Re: [Koha] SQL query to enable all patrons messaging preferences

2017-03-01 Thread Jonathan Druart
Did you call it with --doit? See perl misc/maintenance/borrowers-force-messaging-defaults -h On Wed, 1 Mar 2017 at 07:03 Vimal Kumar V. wrote: > Dear Liz, > The script borrowers-force-messaging-defaults did not change the messaging > preferences of patrons already entered.

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 &

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

Re: [Koha] Search page don't always show results when it should

2017-04-07 Thread Jonathan Druart
dmin/preferences.pl?tab=tools > > > Regards. > > Joël M. > Administrateur Réseaux/Système. > Institut Biblique de Nogent-sur-marne. > > Disponible Lundi-Mardi-Jeudi-Vendredi de 14h à 17h. > > On 04/04/17 19:39, Jonathan Druart wrote: > > Hello "admin",

Re: [Koha] Slow Koha OPAC login process

2017-04-17 Thread Jonathan Druart
ut more or less often. At the moment we can't see a > pattern why it happens, but it does happen... > > Is there maybe a way how to debug "opac-user.pl" so we could find out > what the script is actually doing during the slow login process? > > Regards, Michael > > >

Re: [Koha] Facets show more link with elastic search

2017-04-17 Thread Jonathan Druart
Hello, Which version of ES are you using? (curl -XGET "localhost:9200"). I can only tell you that it works with ES version 5 and master (no need to test version 5 on 16.11, see bug 17255). I do not have a 16.11 install with previous version of ES setup. Regards, Jonathan On Mon, 17 Apr 2017 at

Re: [Koha] Impossible to renew items

2017-07-31 Thread Jonathan Druart
Hi, What is the value of AllowRenewalIfOtherItemsAvailable? And the result of SELECT * FROM issuingrules; Regards, Jonathan On Mon, 31 Jul 2017 at 10:07 mpw wrote: > I'm running Koha version 17.05.01 on Debian 8.8. > > I'm setting up a new library. I have

Re: [Koha] Saving Template for Send EMAIL

2017-07-31 Thread Jonathan Druart
Hi, Something in the logs? In the console? Regards, Jonathan On Mon, 31 Jul 2017 at 12:40 Luis Moises Rojas wrote: > Hello everybody, > > When we go to: Home->tools - Notices & Slips and create a new template (By > the way, we do not see any templates) and we try to

Re: [Koha] adding more than first 20 results to a list

2017-07-31 Thread Jonathan Druart
FYI there is "Bug 10858 - Browse selected biblio" that would have allowed to selected results from several pages (and then to add it to your basket or to a list), OPAC only. But this patch has been waiting for years for testers and QAers, and is now abandoned. I have never really understood why

Re: [Koha] Possibilities and Help in Translation

2017-08-03 Thread Jonathan Druart
Hi Balaji, Welcome! :) This language already exists on our translation server ( http://translate.koha-community.org/ta/). You should take a look at https://wiki.koha-community.org/wiki/Translating_Koha to know how to translate Koha. I am not a translator so I cannot help you more. The language

Re: [Koha] Slow OPAC search

2017-08-03 Thread Jonathan Druart
Hello Manoj, Koha 3.22.02 is a lot of versions behind the last 3.22.x version (3.22.21). Take a look at the value of use_zebra_facets in your koha-conf.xml file. If enabled, disable it (see bug 13665). If you are not using Plack, take a look at this wiki page

[Koha] Results of the poll "Ready to help the Koha community?"

2017-08-01 Thread Jonathan Druart
Hello everybody, I have published the results of the poll, launched at the beginning of the 17.11 development release cycle. https://koha-community.org/answers-of-the-poll-ready-to-help-the-koha-community There are the results, and a list of remarks and notes that people did. I tried to give

Re: [Koha] [Important] Update your MySQL|MariaDB configuration to avoid data loss

2017-08-03 Thread Jonathan Druart
Vinod, Yes you should create the file to make sure the situation will not appear again for other rows. For the corrupted records (the ones returned by the SQL queries), please follow bug 19016. Regards, Jonathan On Thu, 3 Aug 2017 at 05:00 vinod mishra wrote: > Dear All,

Re: [Koha] Koha capacity planning advice?

2017-08-03 Thread Jonathan Druart
Hi Chris, I have opened a new card on our kanban tool and asked some of the guys to list configurations. Hopefully we will get more answers and will be able to create an example list. https://tree.taiga.io/project/joubu-koha-rm-1711/us/132 Regards, Jonathan On Sat, 22 Jul 2017 at 05:00 Chris

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

2017-08-10 Thread Jonathan Druart
Vinod, This already exists and is auto-generated for each release. For 17.05, https://koha-community.org/koha-17-05-released But, as said previously by others, 1 != 1 and there are much more than just writing patches in a community daily tasks. Regards, Jonathan On Thu, 10 Aug 2017 at 07:15

Re: [Koha] OPAC access denied Code 403 in browser

2017-07-12 Thread Jonathan Druart
Hi, How did you install Koha? If it was using package you could recreate an install using the --letsencrypt flag of the koha-create script. If not, make sure your have enabled the ssl apache module. I do not understand why do you modify 000-default.conf, do not you have a specific .conf file for

Re: [Koha] OPAC access denied Code 403 in browser

2017-07-12 Thread Jonathan Druart
I have no idea if this tutorial is correct, but it is old (Koha 3.16). I recommend you to read the official documentation to install Koha on Debian: https://wiki.koha-community.org/wiki/Koha_on_Debian When you will run the koha-create command, specify the --letsencrypt flag to get a certificate

Re: [Koha] Fwd: Re: Cataloguing

2017-07-19 Thread Jonathan Druart
Ubuntu 14.04 is no longer supported: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Introduction On Wed, 19 Jul 2017 at 03:24 Indranil Das Gupta wrote: > -- Forwarded message -- > From: "Ambika C.A." > Date: Jul 19,

Re: [Koha] Koha 17.05 and memcached

2017-07-25 Thread Jonathan Druart
Wait guys, you are certainly doing something wrong here. With Koha 17.05 you should use Plack, and if you are using Plack the MEMCACHED* variables you will define in your apache config files will not be used. You should setup plack correctly, fill the 2 entries in your koha-conf.xml files

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-25 Thread Jonathan Druart
nes. > > > Thanks, > > On Tue, Jul 25, 2017 at 4:27 PM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > >> I think the 2 "Listen" lines should go to ports.conf >> >> On Tue, 25 Jul 2017 at 18:11 C.J.S. Hayward <c...@cj

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-25 Thread Jonathan Druart
Try with --create-db: koha-create --create-db library The doc says that --create-db is the default value, but it does not seem to work. Could you report the bug? On Tue, 25 Jul 2017 at 15:36 C.J.S. Hayward wrote: > Thank you. I've used koha-remove, and uninstalled and

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-25 Thread Jonathan Druart
tening on that port, the > error would be "Connection refused", not "System maintenance". > > On Tue, Jul 25, 2017 at 10:02 PM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > >> Try with --create-db: >> koha-creat

[Koha] Reminder: dev meetings are essential

2017-07-25 Thread Jonathan Druart
Hello everybody, To me, when someone never attends any dev meetings it means: - they do not have specific needs/priorities - they do not have any opinions on how the development team is prioritizing / organising the next developments - they do not want to get involved in the technical decisions

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-25 Thread Jonathan Druart
had earlier tried to access opac:7027 and got the reported error. Now I > am trying to access intranet:7028 and I can't tell a difference. > > Do I need to be doing more if I reassign port numbers? > > > Thanks, > > > On Tue, Jul 25, 2017 at 11:47 PM, Jonathan Druart < &g

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-25 Thread Jonathan Druart
d line way (bash or mysql) to set the password for > kohauser? > > > Thanks, > > On Tue, Jul 25, 2017 at 5:18 PM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > >> I tried to add the "Listen" lines and it breaks everything for me. &g

Re: [Koha] Cataloging

2017-07-24 Thread Jonathan Druart
Hello, Ubuntu 14.04 is no longer supported, you should try installing 16.04. You can also try to switch off the system preference UseQueryParse. Regards, Jonathan On Mon, 24 Jul 2017 at 06:44 Ambika C.A. wrote: > Dear Sir/Madam, > > Our cataloging is showing the

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-27 Thread Jonathan Druart
What was the problem finally? :) On Wed, 26 Jul 2017 at 14:48 C.J.S. Hayward wrote: > I am now the proud new owner of a live Koha installation. > > Thanks to all of the people who addressed my questions! (-: > > On Wed, Jul 26, 2017 at 8:48 AM, Michael Kuhn

Re: [Koha] Self Check - "Outsdanding fines block issue"

2017-07-27 Thread Jonathan Druart
Hi Uğur, Just in case, did you check the syspref noissuescharge? It should block the checkout from the staff interface as well so I do not think it comes from that. You should also check IssuingInProcess if rental charges are defined for item types. Otherwise I would suggest you to debug if you

Re: [Koha] Book renewed online does not show the time of renewal

2017-07-19 Thread Jonathan Druart
Hi Vinod, Did you compare the content of the notice? Regards, Jonathan On Wed, 19 Jul 2017 at 08:40 vinod mishra wrote: > Dear All, > > I have activated the renewal date in messages, but if a member returns the > book from koha staf client it reflect the Time of renewal

Re: [Koha] All items "not renewable" SOLVED

2017-07-19 Thread Jonathan Druart
Hello, Please create a new thread and detail your problem. Regards, Jonathan On Wed, 19 Jul 2017 at 11:31 mpw wrote: > I'm having this same problem, i.e. "Not renewable (0 of 0 renewals > remaining)" for > every single item. > > Koha version: 17.05.01. > Debian

Re: [Koha] Any way to track user logins

2017-07-05 Thread Jonathan Druart
Hi, See the system preferences TrackLastPatronActivity, TrackClicks and, maybe, FailedLoginAttempt. Regards, Jonathan On Fri, 23 Jun 2017 at 06:10 MAKAUTCL WB wrote: > Hello list, > > I would like to know if there is any way within Koha by which i can track / > generate a

Re: [Koha] Life cycle of a Koha software bug

2017-07-05 Thread Jonathan Druart
Hi Christopher, I covered this subject during a talk at KohaCon16. Here are the slides: https://www.dropbox.com/s/6dn9mi0p04m8whm/KohaCon16_talk.pdf?dl=0 https://www.dropbox.com/s/ojrwm330s3wvo34/KohaCon16_talk.odp?dl=0 See slide 19 for a graph. Copyright is on the last page. Cheers, Jonathan

[Koha] Proposal for RM 17.11

2017-04-27 Thread Jonathan Druart
Hello everybody, A quick email to let you know that I propose to serve as Release Manager for the development cycle of the version 17.11 of Koha. The proposal is on the wiki : https://wiki.koha-community.org/wiki/Proposal_for_RM_17.11_joubu Remember that you can see (and add your name to) the

[Koha] What's on in koha-devel #12

2017-04-25 Thread Jonathan Druart
Hello librarians and developers, My last email got a lot of interest and people do not stop contacting me to help us, it's fantastic! Heh, no, just kidding. But I am still willing to help you! Whenever you are ready, just let me/us know! The next release is on its way. We are in the final

Re: [Koha] Plack unable to restart once every week

2017-04-25 Thread Jonathan Druart
Hello Andreas, You should take a look at bug 17814, it may be related and fix your problem. Let us know Regards, Jonathan On Tue, 25 Apr 2017 at 05:48 Andreas Roussos wrote: > Dear List, > > We are running Koha 16.05.02 on Debian 8, installed from packages. > > Recently

Re: [Koha] Koha Check- Error -The item has not been checked in due to a configuration issue in your system.

2017-08-01 Thread Jonathan Druart
Hello Admire, Indeed there is no auto increment field on old_issues, but it is not where the problem comes from. You have issues.issue_id with 2 and 3. But these 2 values already exist in the old_issues table. When the checkin is done, the row is moved from one table to the other, but

[Koha] [Important] Update your MySQL|MariaDB configuration to avoid data loss

2017-08-01 Thread Jonathan Druart
Hello everybody, This is an important email and you should not ignore it. If you are a librarian and have no technical skills you should forward this email to the administrator of your Koha installation. We have been dealing with circulation history loss in the last versions of Koha, and we

Re: [Koha] checkin problem

2017-08-01 Thread Jonathan Druart
Hello Sahadeo, I have just sent an email on the list to explain a bit more why you get this message. Take a look at https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Regards, Jonathan On Tue, 1 Aug 2017 at 05:32 Sahadeo Taware wrote: > Dear Friends > >

Re: [Koha] After Upgrade no biblio_metadata and mo marcxml

2017-08-01 Thread Jonathan Druart
Hi, What is the exact error you got? Regards, Jonathan On Tue, 1 Aug 2017 at 04:07 gevos wrote: > Overyesterday We have updated ubuntu server and the koha was updated too. > Apparently because of the mysql 5.7 the script somehow failed and we have > landed to a point

Re: [Koha] Records are not show in catelog

2017-08-01 Thread Jonathan Druart
Hi Fahad, How did you reindex Zebra? Which versions of Koha and Zebra are you using? We will need more information to help you. Regards, Jonathan On Tue, 1 Aug 2017 at 00:48 Fahad Ubaid wrote: > Dear Community, > > We facing a Problem regarding searching records in the

Re: [Koha] Koha on Debian Stretch?

2017-08-08 Thread Jonathan Druart
Hi Chris, Take a look at our wiki page to install Koha on debian using packages: https://wiki.koha-community.org/wiki/Koha_on_Debian All what you need to know is on this page. I have installed Koha on Debian Stretch using this method last week. I did not add Debian 9 in the "known systems" list

Re: [Koha] Spam from BestBookBuddies (OpenLX)

2017-08-08 Thread Jonathan Druart
his kind of email off the list in future. >> >> And if you plan to continue to send unsolicited emails to people then I >> think the request to remove the listing should stand >> >> Chris >> >> On 9 August 2017 5:58:37 AM NZST, "Sudhi

[Koha] What's on in koha-devel #14

2017-08-08 Thread Jonathan Druart
Hello librarians and developers, The what's on in koha-devel #14 is available on the Koha website: https://koha-community.org/whats-on-in-koha-devel-14 Regards, Jonathan ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Koha giving frequent software errors

2017-08-09 Thread Jonathan Druart
Hello Gurpreet, Answers inline: On Wed, 9 Aug 2017 at 11:26 ILOBWeb wrote: > Hello everyone, > > We are using Koha for our resource centre and we are getting frequent > software errors while working on it. Errors are like - > > Error 1 : > Software error: > > Wrong CSRF

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

2017-08-09 Thread Jonathan Druart
Just to cross the topics, we already had this discussion earlier: https://lists.katipo.co.nz/public/koha/2015-July/043138.html "Proposal to remove the 'Paid support' list" On Wed, 9 Aug 2017 at 12:17 Mark Tompsett wrote: > Greetings, > > Nathan A. Curulla suggested: > >

Re: [Koha] Unknown column 'metadata' in 'field list'

2017-08-09 Thread Jonathan Druart
Vimal, Koha 17.05 has been released with bug 17898. With it you should see a new "Update" column on the report list if you have reports using the biblioitems.marcxml columns. There is a "Update SQL" button, when clicked a script will update the query to use the new biblio_metadata column. This

Re: [Koha] Possibilities and Help in Translation

2017-08-09 Thread Jonathan Druart
the version 17.05. > There is also a version of Koha 3.22 and many other versions. Can you > please provide suggestions on how to select versions for translating? Some > are marked as obsolete. Kindly help is selecting versions. > > On 3 August 2017 at 19:51, Jonathan Druart &l

Re: [Koha] Koha on Debian Stretch?

2017-08-08 Thread Jonathan Druart
uction > ever since. > > The only glitch was Zebra shutting down on Sunday. Shutting down > anacron and letting cron do the job solved that problem. See Radek's > email in > https://lists.katipo.co.nz/pipermail/koha/2016-September/046167.html > > Bob > > On 08/08/2017 08:15 AM,

Re: [Koha] Spam from BestBookBuddies (OpenLX)

2017-08-04 Thread Jonathan Druart
I have sent them several emails and they never answered. They are already on my list of companies to remove from the list. Cheers, Jonathan On Fri, 4 Aug 2017 at 08:56 Owen Leonard wrote: > Has anyone else received spam from "BestBookBuddies - an Initiative > of: OpenLX

Re: [Koha] Wiping all partial or full Koha isntallation(s) and installing stable under Mint

2017-07-25 Thread Jonathan Druart
tallation is corrupt. > > (koha-password displayed a password, but it didn't work for logging in as > kohauser either.) > > I want to uninstall and reinstall. Any words of advice besides being > meticulous about the wiki instructions? > > > Thanks > > On Tue

Re: [Koha] Error in Patrons

2017-05-03 Thread Jonathan Druart
if you log in as a real patron, you should not see that error. The > >> > Administrator login is not associated with a branch. > >> > HTH, > >> > Bob Birchall > >> > Calyx > >> > > >> > On 03/05/17 14:52, Rejeesh K.Nair wrot

Re: [Koha] Fwd: Re: bulkmarcimport

2017-05-11 Thread Jonathan Druart
Hi Bob, Can you open a bug report please? On Wed, 10 May 2017 at 23:58 Bob Ewart wrote: > I found the problem. > I had created a framework for archives, but didn't set the MARC structure. > > MARC Bibliographic framework test should have caught that, but didn't. > >

Re: [Koha] How to remove unwanted characters when importing MARC data?

2017-06-21 Thread Jonathan Druart
Take a look at C4::Charset::nsb_clean I guess you can add more substitutions there. On Wed, 21 Jun 2017 at 13:55 Michael Kuhn wrote: > Hi > > Our library receives MARC data from EKZ (a German cataloging data > provider) which includes two unwanted characters: > > * a

Re: [Koha] Items Not Being Cleared From Patron Account After Check-In

2017-05-22 Thread Jonathan Druart
I did not follow everything in your manipulations, but there is definitely a bug. I have opened bug 18651 to try and fix it. On Mon, 22 May 2017 at 13:49 Lennon Mazonde wrote: > Hi Nick, > > Just out of interest's sake, i changed the increment value in >

[Koha] Koha: Call for volunteers for next release (17.11)

2017-05-24 Thread Jonathan Druart
let us know and we will guide you! You can contact me (Jonathan) using this email address. Or Nick Clemens nick .AT. bywatersolutions .DOT. com For Spanish speakers: Tomas Cohen Arazi - tomascohen .AT. gmail .DOT. com For French speakers: Jonathan Druart - jonathan.druart .AT. bugs.koha-com

Re: [Koha] Koha 16.05.13 release

2017-05-26 Thread Jonathan Druart
Hi Gary, Apparently something went wrong when this package has been built. The package has been removed from the server and is no longer available. Mirko has been contacted and the package should be rebuilt soon/next week. Thanks for catching it Regards, Jonathan On Fri, 26 May 2017 at 11:31

Re: [Koha] Slow Koha OPAC login process - a bug? Workaround exists

2017-05-18 Thread Jonathan Druart
I still do not recreate the problem. ^ dates are handled in our Koha::DateUtils module, take a look at: 223 # FIXME: see bug 13242 => no TZ for dates 'infinite' 224 if ( $dt->ymd !~ /^/ ) { 225 my $tz = $dateonly ? DateTime::TimeZone->new(name => 'floating') :

Re: [Koha] user history

2017-05-30 Thread Jonathan Druart
Hello Scott, 3.22.06 is one year old, 3.22.21 is the newest 3.22.x version. Please update to this version and retest. Regards, Jonathan On Tue, 30 May 2017 at 11:22 Scott Owen wrote: > Hi all, > > One of my Koha installs, (3.22.06.000 ) seems to not save user check out >

Re: [Koha] Regarding sql report for analytical records created

2017-05-30 Thread Jonathan Druart
Hello, Syntactically the query is wrong, try replacing 'bi' with 'biblioitems' Regards, Jonathan On Tue, 30 May 2017 at 10:53 Suresh Kumar Tejomurtula wrote: > Hi, > > I would like to get a report on analytical records created in koha. > > The below is the query I tried,

Re: [Koha] Error after upgrading to latest version of Koha

2017-05-31 Thread Jonathan Druart
Hello, What is the value of the system preference SessionStorage? If it is not 'mysql', try it. Regards, Jonathan On Sun, 28 May 2017 at 00:52 George Masters wrote: > I just recently upgraded to Koha 16.11.08 and the database schema > conversion completed OK (based

Re: [Koha] Serious problem with Koha issue/return

2017-06-13 Thread Jonathan Druart
ks also does not move from check out to circulation > history completely but it remains in check out and shows in circulation > history too with return date. > > Please suggest corrective step as we are in live and daily approx 10 > problem we are facing. > > On 14 Jun 2017 07:30, &

Re: [Koha] Serious problem with Koha issue/return

2017-06-13 Thread Jonathan Druart
Hello Vinod, What you describe may be related to bug 18651 (Move of checkouts is still not correctly handled). Regards, Jonathan On Tue, 13 Jun 2017 at 22:18 vinod mishra wrote: > Dear All, > > I am facing very serious issue regarding issue/return of books from koha >

Re: [Koha] Error in Patrons

2017-05-02 Thread Jonathan Druart
Hello, Are you logged in with the DB user? On Tue, 2 May 2017 at 11:16 Rejeesh K.Nair wrote: > Hi All, > > We just migrated KOHA version 3.18.01.000 to 16.05.04. When we click on any > of the letter(A-Z listing) in 'Patrons' tab it won't show the corresponding > patrons.

[Koha] What's on in koha-devel #13

2017-05-31 Thread Jonathan Druart
Hello librarians and developers, I have a lot of things to tell you :) First, Koha 17.05 is out! I would like to congratulate Kyle and all the release team! It includes 7 new features and many enhancements and bug fixes. You can find the release notes on the website :

Re: [Koha] Problem with migration from KOHA 3.20 to 16.11.11

2017-09-15 Thread Jonathan Druart
Paul, I am sure you understood what I meant: the Koha debian packages are based on Jessie (and so Ubuntu 16.04). We had problems with Apache versions (2.4) and other Perl libs that were not packaged/packagable easily for Wheezy. Debian packages are generated by only 1 guy (Mirko) and developers

Re: [Koha] Problem with migration from KOHA 3.20 to 16.11.11

2017-09-14 Thread Jonathan Druart
Hello, We have an entry in the bug tracker that is related to what you describe: Bug 11000 - koha-restore not working: Koha username error Maybe you can try and add more information there? Note that Ubuntu 14.04 is not longer supported. Cheers, Jonathan On Thu, 14 Sep 2017 at 09:48 Przemek

Re: [Koha] Cross-site scripting vulnerability - Koha 16.11

2017-09-13 Thread Jonathan Druart
Please open a bug report in the "Koha security" project https://bugs.koha-community.org/bugzilla3/enter_bug.cgi That way we can keep the vulnerability hidden until a fix is published On Wed, 13 Sep 2017 at 15:35 Tom Hanstra wrote: > We received email from our campus InfoSec

Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Jonathan Druart
Hello Michael, It works for me on 17.05.01. Check the logs, if you see something like: Template process failed: undef error - round() overflow. Try smaller precision or use Math::BigFloat at /home/koha/src/Koha/Number/Price.pm line 44 It's a known bug: Bug 15770 - Number::Format issues with

Re: [Koha] Check-out Counts difference

2017-09-18 Thread Jonathan Druart
Hello Satish, Please update to the newest 16.11.x version and read this wiki page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix Regards, Jonathan On Mon, 18 Sep 2017 at 08:37 SATISH wrote: > Hi > > After upgrade from Koha 16.5 to 16.11.09.000 / Package

Re: [Koha] Software error: Koha Web Installer-MARC21

2017-09-19 Thread Jonathan Druart
We received good feedbacks from people using Koha packages on stretch, see this recent thread https://lists.katipo.co.nz/pipermail/koha/2017-August/048673.html On Tue, 19 Sep 2017 at 15:59 Michael Kuhn wrote: > Hi Dimitris > > According to

Re: [Koha] Check-out Counts difference

2017-09-19 Thread Jonathan Druart
Hello, I am not sure to understand, do you have a screenshot? One screen displays the current checkouts and the other screen (history) displays all current and previous checkouts. Regards, Jonathan On Tue, 19 Sep 2017 at 10:24 SATISH wrote: > Hi Jonathan, > Thank you for

Re: [Koha] Problem with page number

2017-09-20 Thread Jonathan Druart
2 > 3 > > Instend of 1 2 3 > > On Wed, Sep 20, 2017 at 9:49 AM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > >> Luis, >> >> The pagination block appears correctly horizontally. >> http://catalogo.bijrd.gob.do/cgi-bin/koha/o

Re: [Koha] Check-out Counts difference

2017-09-20 Thread Jonathan Druart
This is a weird behavior. What returns the following SQL query? SELECT COUNT(*) FROM issues WHERE borrowernumber=516 At the OPAC, do you see 3 or 10 checkouts? On Wed, 20 Sep 2017 at 02:20 SATISH wrote: > Hi Jonathan, > > Please find the screen captures here... > > for

[Koha] Coordinate Koha releases -- September 2017

2017-09-21 Thread Jonathan Druart
The Koha community is releasing an update for all supported versions of Koha. This update is not a security update but contain several security fixes. The update is available for the following new releases: 17.05.04 - https://koha-community.org/koha-17-05-04-release/ 16.11.12 -

Re: [Koha] Check-out Counts difference

2017-09-21 Thread Jonathan Druart
Satish, Yes 16.11.09 was a buggy version, but what you describe is not a known bug. I'd say that old_issues.returndate is set to null and so the history page consider it as "currently checked out", but it is not. In this case the patron should have only 3 items at home and the other items are

Re: [Koha] XSLT for UNIMARC

2017-09-21 Thread Jonathan Druart
Hi Andreas, There are more developers using MARC21, and more enhancements are provided pour MARC21 XSLT only. Sometimes one development in MARC21 does not make sense in UNIMARC (and vice-versa). If you submit patches, we will integrate it (after the different integration steps), so yes it is

Re: [Koha] Internal server error when trying to open Budget or Funds

2017-09-15 Thread Jonathan Druart
So yes, it's a bug, please open a bug report :) On Fri, 15 Sep 2017 at 16:47 Michael Kuhn wrote: > Hi Jonathan > > > But now I also found an error message in > > "plack-error.log". > > > > When clicking "Budgets" it says: > > > > Can't call method "symbol" on an undefined

Re: [Koha] Check-out Counts difference

2017-09-22 Thread Jonathan Druart
Satish, Yes, that was the solution. I cannot explain how it has been possible, but the returndate field should not be set to null for checkins. You must upgrade to the latest 16.11.x version, 16.11.09 may have caused this problem. Cheers, Jonathan On Fri, 22 Sep 2017 at 09:08 SATISH

Re: [Koha] Coordinate Koha releases -- September 2017

2017-09-21 Thread Jonathan Druart
wrote: > Hello, > > There is no "v17.05.04" tag on the Github repo, is it normal ? > > Regards, > > Alex > > On Thu, Sep 21, 2017 at 03:30:30PM +, Jonathan Druart wrote: > > The Koha community is releasing an update for all supported versions of >

Re: [Koha] Problem with page number

2017-09-20 Thread Jonathan Druart
Luis, The pagination block appears correctly horizontally. http://catalogo.bijrd.gob.do/cgi-bin/koha/opac-search.pl?q=d You should, like always, refresh your browser cache. You also should add a red sticker close to your keyboard: "Before sending an email to the Koha list, I refresh my browser

Re: [Koha] Help needed with SQL report

2017-10-09 Thread Jonathan Druart
- > 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

Re: [Koha] Koha password recovery doesn't seem to work

2017-10-10 Thread Jonathan Druart
Hello, You must fill the pref OPACBaseURL Regards, Jonathan On Tue, 10 Oct 2017 at 11:47 VISINI Giacomo wrote: > Hello, > > I've been having issues setting up a password recovery in Koha (version > 16.11.12.000). I've did all the necessary steps, as explained in

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

<    1   2   3   4   5   6   7   8   >