[Koha] Data lost when using the batch patron modification tool in 3.22.2 and 3.20.8

2016-01-20 Thread Jonathan Druart
Hello, A quick warning about the batch patron modification tool, in the 3.22.2 and 3.20.8 releases: bug 15332 [1] has introduced a bad bug which could cause data lost (reset of date enrolled and date expiry). I would recommend not to use this tool if you are using one of these version. Note that

Re: [Koha] Data lost when using the batch patron modification tool in 3.22.2 and 3.20.8

2016-01-20 Thread Jonathan Druart
released next week? > > Chris > > On 20 January 2016 10:01:03 pm NZDT, Jonathan Druart > <jonathan.dru...@bugs.koha-community.org> wrote: >> >> Hello, >> >> A quick warning about the batch patron modification tool, in the >> 3.22.2 and 3.20.8 releases:

Re: [Koha] Fixing Zebra After Upgrade

2016-02-15 Thread Jonathan Druart
Try to modify 666 with 644 and change the owner of the file instead. It's often a bad idea to let others with +w 2016-02-13 3:03 GMT+00:00 wildness : > HI Katrin, > Thank you so much for your help! I did a chmod 666 on the file I > mentioned and reindexed and like

Re: [Koha] Turning a MARC field into a URL

2016-03-18 Thread Jonathan Druart
Hello, To make it clickable you need to check the "Is a url" flag when editing the framework. Regards, Jonathan 2016-03-16 18:34 GMT+00:00 King, Fred : > Hello, all, > > I'm using Koha 3.20.05 on Ubuntu 14.04. > > I'm trying to add a new MARC field that's a URL. I've

Re: [Koha] Suggestion Challenge

2016-04-08 Thread Jonathan Druart
Yes, by default you will only see the suggestion from your library. To see all the suggestions, you can change the filter on the left (Acquisition information block) and select "Any" 2016-04-08 0:11 GMT+01:00 Kerrie Stevens : > Hi Bruce, > > Do you have multiple locations

Re: [Koha] v3.22 - Import Patrons

2016-04-08 Thread Jonathan Druart
Sergio, which version of the 3.22 branch are you using? What you describe make me think about bug 15840, a fix has been pushed to 3.22.05 2016-04-07 16:35 GMT+01:00 Sergio Scotto : > Hi Tomas, thx for the reply! > > This is what i do: > > First i import the file test.csv (its

Re: [Koha] HTTP::OAI

2016-03-22 Thread Jonathan Druart
Try install it using the debian package: `sudo apt-get install libhttp-oai-perl` 2016-03-22 10:15 GMT+00:00 regina kivuyo : > sorry for disturbance i tried to install HTTP::OAI > root@library-HP-Pro-3400-Series-MT:/home/koha-3.10.02# cpan force install > HTTP::OAI >

Re: [Koha] Problem with Check expiration in Serials

2016-03-08 Thread Jonathan Druart
Confirmed: perl -wc serials/checkexpiration.pl Global symbol "$branch" requires explicit package name (did you forget to declare "my $branch"?) at serials/checkexpiration.pl line 84. Global symbol "$branch" requires explicit package name (did you forget to declare "my $branch"?) at

Re: [Koha] Koha MARC modification template and field 008 position 07-10

2016-03-02 Thread Jonathan Druart
At the moment, it's not possible to copy control fields into another field (and the reverse). The interface should warn you if you try to do it (subfield inputs should be both filled or empty). 2016-03-03 4:48 GMT+00:00 Jesse : > Just so you know, this ended up in my spam

Re: [Koha] problem installing Koha

2016-05-21 Thread Jonathan Druart
Hi Tommaso, Koha 3.22 is not ready yet for Ubuntu 16.04 (because of the version of MySQL) See bug 13669 and bug 16402 for more informations. Regards, Jonathan https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402

[Koha] Remove the password option in patron attributes

2016-04-19 Thread Jonathan Druart
Hello everybody, I'd like to get opinion on the password option available in patron attributes. Initially this field was created to allow patrons to use an alternate password to login, but it has never been implemented. I have suggested to remove it on bug 12267 as we don't use it internally and

Re: [Koha] Koha delete Item type

2016-04-18 Thread Jonathan Druart
Hello Decka, Are you using the last version of the 3.20 branches (3.20.10)? Did you try to delete all the items of the record? Then delete the record, then the item type. Regards, Jonathan 2016-04-18 9:56 GMT+01:00 Decka David : > I still cannot delete the Item type

Re: [Koha] SQL help please

2016-08-10 Thread Jonathan Druart
ored in marc at > all... it's *always* generated on the fly. > > You can query against items.itype instead. > > --Barton > > On Tue, Aug 9, 2016 at 4:18 AM, Jonathan Druart > <jonathan.dru...@bugs.koha-community.org> wrote: >> >> Hi Kerrie, >> I'd say

Re: [Koha] Alt-y not working on Please confirm checkout dialogs.

2016-07-15 Thread Jonathan Druart
Hi Tim, Please open a new bug report on bugs.koha-community.org Regards, Jonathan 2016-07-14 17:56 GMT+01:00 Tim McMahon : > In Koha 16.05, the accesskey for yes selects the renew tab when there is a > "Please confirm checkout" dialog. Also the new "Don't check out and print

Re: [Koha] Fine amount does not display on patron checkout page

2016-07-06 Thread Jonathan Druart
Already reported (and patched), see bug 16810 2016-07-04 9:29 GMT+01:00 Jonathan Druart <jonathan.dru...@bugs.koha-community.org>: > Hi Vimal, > > It looks like a bug, please open a bug report on bugs.koha-community.org > > Regards, > Jonathan > > 2016-07-04 8:42 GM

Re: [Koha] SQL help please

2016-08-09 Thread Jonathan Druart
Hi Kerrie, I'd say that the following query returns what you want: SELECT biblioitems.biblionumber, marcxml from biblioitems where ExtractValue( marcxml, '//datafield[@tag="942"]/subfield[@code="c"]' ) = ""; Regards, Jonathan 2016-08-09 7:36 GMT+01:00 Kerrie Stevens : >

Re: [Koha] Fine amount does not display on patron checkout page

2016-07-04 Thread Jonathan Druart
Hi Vimal, It looks like a bug, please open a bug report on bugs.koha-community.org Regards, Jonathan 2016-07-04 8:42 GMT+01:00 Vimal Kumar V. : > Dear Friends, > We are using koha 16.05.1. > Fine amount does not show on Patron account > Check out page. > Please see the

Re: [Koha] Fine amount does not display on patron checkout page

2016-07-04 Thread Jonathan Druart
And please link it to bug 14497. 2016-07-04 9:29 GMT+01:00 Jonathan Druart <jonathan.dru...@bugs.koha-community.org>: > Hi Vimal, > > It looks like a bug, please open a bug report on bugs.koha-community.org > > Regards, > Jonathan > > 2016-07-04 8:42 GMT+01:00 Vimal

Re: [Koha] Hold: Patron is from different library

2017-02-03 Thread Jonathan Druart
Hello, This message is displayed if the library of the patron is different from the home library of the item. You should double check these 2 values. I have just tested right now on 16.11.02 and I do not see the message. Regard, Jonathan On Thu, 2 Feb 2017 at 19:09 rfblanchard

Re: [Koha] Acquisitions error : Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054

2017-01-31 Thread Jonathan Druart
at > /usr/share/koha/intranet/cgi-bin/acqui/spent.pl line 88. > > It would be great if these errors can be fixed. > > > Thanks! > > > Jane Chang > Christian Witness Theological Seminary > 1975 Concourse Dr. > San Jose, CA 95131 > (408)433-2280 x109 <(408)%20433-228

Re: [Koha] Duplicate entry in old_reserves

2017-02-01 Thread Jonathan Druart
o_increments on InnoDB > the way we use them. > > "Switch to Postgres" is not a valid answer, please :-D > > El mar., 31 ene. 2017 a las 16:42, Tim McMahon (<tmcma...@wlpl.org>) > escribió: > > On 01/31/2017 12:37 PM, Jonathan Druart wrote: > > On Tue,

Re: [Koha] Customizing self service to display title

2017-02-01 Thread Jonathan Druart
en. This confirmation pop up will prevent > errors during the checkout process if wrong bar code numbers are entered. > > We gave done a confirmation pop up with bar code alone. The challenge is > to show the title also. How to do this ? > > On Tue 31 Jan, 2017, 9:52 PM Jonatha

Re: [Koha] Customizing self service to display title

2017-01-31 Thread Jonathan Druart
Hello Krishna, When you checkout an item via the self-checkout module of Koha, the checked out items appear in a table. In this table you can see the title of the different items. Why would you want to open a pop-up? Could you please detail the need? Regards, Jonathan On Tue, 31 Jan 2017 at

Re: [Koha] Duplicate entry in old_reserves

2017-01-31 Thread Jonathan Druart
On Tue, 31 Jan 2017 at 18:59 Tim McMahon wrote: > Thanks for the quick reply. We've been on Koha since 2006 and the item > in question was fairly new, so that wouldn't be it. I agree, the > auto-incremement on the reserves key should keep this problem from > happening. >

Re: [Koha] Multiple OPAC interfaces

2017-02-07 Thread Jonathan Druart
For Plack you can have a look at bug 16520, it is in 16.11. On Tue, 7 Feb 2017 at 18:51 Chris Cormack wrote: > Hi Michael > > This won't work with Plack, because the environment variables set in > Apache are not passed through to Plack. > This still works fine without

Re: [Koha] Circulation-empty barcode-internal server error

2017-01-23 Thread Jonathan Druart
Hi Clint, I do not recreate, what is the error you get? Regards, Jonathan On Mon, 23 Jan 2017 at 04:05 clint.deckard wrote: > 16.05.06- Package > > With the CircAutoPrintQuickSlip syspref set to "clear the screen", > hitting enter with an empty barcode field

Re: [Koha] Unknown column 'me.lastseen' in 'field list' in KOHA

2017-01-23 Thread Jonathan Druart
ebuild the schema. > > On Thu, Jan 19, 2017 at 4:25 AM, Jonathan Druart < > jonathan.dru...@bugs.koha-community.org> wrote: > > An upgrade to which version? 16.11? > That column is added by bug 16276 and is only in 16.11, so I guess it is > the one. > Everything looks

Re: [Koha] Circulation-empty barcode-internal server error

2017-01-24 Thread Jonathan Druart
e at > /usr/share/koha/intranet/cgi-bin/circ/circulation.pl line 472. > > Seems related to Bug 14015? > > Clint. > > Jonathan Druart wrote: > > Hi Clint, > > > > I do not recreate, what is the error you get? > > > > Regards, > > Jon

Re: [Koha] Acquisitions error : Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054

2017-01-25 Thread Jonathan Druart
Hi Jane, We need more information to help you. What is the version of Koha you are using? How did you install it? Is it a new error you get (after an upgrade) or just after you installed Koha? Then give us a step by step plan to recreate the issue, and if possible the error you get in the Koha

Re: [Koha] Circulation-empty barcode-internal server error

2017-01-25 Thread Jonathan Druart
Please open a new bug report. I will not be able to provide a patch, I still cannot recreate. On Thu, 26 Jan 2017 at 07:57 clint.deckard wrote: > These are exactly the steps to recreate the issue in 16.05 although I > hit enter rather than clicking the checkout

Re: [Koha] WG: Introducing myself, adress administration, and accessibility

2017-01-27 Thread Jonathan Druart
Hi Andrea, Welcome to the Koha community! Indeed there are 3 kinds of address you can define per patron: "Main address", "Alternate address" and "Alternate contact". However you can define an unlimited number of "additional attributes". They are free text fields you can fill by patron. That

Re: [Koha] Extracting empty bibliogrphic records

2017-01-27 Thread Jonathan Druart
Hello Lukasz, Can you define "empty"? Regards, Jonathan On Fri, 27 Jan 2017 at 12:47 wrote: > Hello, > > > > I would like to extract all the empty bibliografic records, to use Batch > record deletion afterwards. > > We have quite a lot of empty records so maybe CSV

Re: [Koha] SQL Report-Circulation-- Help

2017-02-22 Thread Jonathan Druart
Hello Satish, To add conditions to a SQL query you just need to separate them with the "AND" keyword, do not repeat "WHERE". So it's: SELECT fields FROM TABLE WHERE condition_a AND condition_b AND condition_c Regards, Jonathan On Wed, 22 Feb 2017 at 11:05 SATISH

Re: [Koha] SQL Report-Circulation-- Help

2017-02-22 Thread Jonathan Druart
What is the error you get? Please answer to the list. On Wed, 22 Feb 2017 at 12:12 SATISH <lis4sat...@gmail.com> wrote: > thank you Jonathan for correcting sql syntax. > but after corrections,it is still showing error! > > with thanks > satish > > On 22 February 201

Re: [Koha] Replace Module for C4::Branch

2017-02-23 Thread Jonathan Druart
Hello Admire, Which subroutine of C4::Branch did you use? You should have a look at bug 15758. It removes GetBranches and GetBranchesLoop, you certainly used one of these two. Basically you will need to call Koha::Libraries->search. Regards, Jonathan On Fri, 24 Feb 2017 at 07:34 Admire

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

2017-02-14 Thread Jonathan Druart
Hi Rejeesh, I have just written a patch using CGI->uploadInfo. I think it does what you want. See bug 18087, patch 'Handle invalid filetypes'. Regards, Jonathan On Tue, 14 Feb 2017 at 07:11 Rejeesh K.Nair wrote: > Hi All, > > Many thanks for all your timely support ,

Re: [Koha] Koha catalogue search

2017-02-14 Thread Jonathan Druart
Hello Ian, Try a full reindexation: koha-rebuild-zebra -f -a -b -v $instance_name Regards, Jonathan On Tue, 14 Feb 2017 at 15:55 i.pr...@zigzagee.com wrote: > Hi, > > I have installed Koha on Debian (yay!). Version 16.05.06.000. I want to > use UNIMARC format. > > I

Re: [Koha] Fwd: No results with the advanced search

2017-02-09 Thread Jonathan Druart
Hi Vanda, The item search is not using Zebra but requests the database directly. You should fully rebuild your zebra index using `rebuild-zebra.pl -f -a -b -v` Regards, Jonathan On Thu, 9 Feb 2017 at 13:16 vanda koha wrote: > -- Forwarded message -- >

Re: [Koha] Unknown column 'me.lastseen' in 'field list' in KOHA

2017-01-19 Thread Jonathan Druart
An upgrade to which version? 16.11? That column is added by bug 16276 and is only in 16.11, so I guess it is the one. Everything looks fine for me. If you are using Plack you should restart it. "Everything is mess" What else is a mess? On Thu, 19 Jan 2017 at 02:28 Luis Moises Rojas

Re: [Koha] flat fee on notice generation

2017-01-19 Thread Jonathan Druart
Hi Radek, The feature is not in at the moment, but we got some tries. See bug 14666, bug 13816 and bug 12769. Cheers, Jonathan On Thu, 19 Jan 2017 at 00:24 Radek Šiman wrote: > Hello everyone, > > I'd like to ask a question concerning overdue fees. One of our library >

Re: [Koha] Further adventures with Koha update to 16.xxx

2017-01-16 Thread Jonathan Druart
Hi David, You have several errors, some are "expected", some are not. 1/ DBD::mysql::db do failed: Duplicate column name 'updated_on' => It's a bug, I have proposed a patch on bug 17234 to avoid that in the future. You can ignore it. The columns borrowers.updated_on and

Re: [Koha] No Zebra indexing - missing field "biblioitems.marc"

2017-01-16 Thread Jonathan Druart
Hi Michael, It sounds like you are usinga gitified install but the Koha scripts have not been updated. /usr/share/koha/bin/migration_tools/rebuild_zebra.pl is certainly refering to an old version of this script. Cheers, Jonathan On Tue, 17 Jan 2017 at 01:19 Chris Cormack

Re: [Koha] [Fwd: Koha Image Installation]

2017-01-17 Thread Jonathan Druart
Hello, What do you call "an image"? It seems that the user defined in the apache configuration is not created. Regards, Jonathan On Mon, 16 Jan 2017 at 15:20 Via Vitae Solutions wrote: > Hi, > I am having a problem while installing an image of Koha 16.05.05.000 to >

Re: [Koha] Claim mail is not sent to Vendor - KOHA 16.05.02

2016-08-25 Thread Jonathan Druart
Hi, The email has been sent but rejected by the mail server: "SMTP error from remote mail server" "Sender address rejected" Check your MTA configuration. Regards, Jonathan 2016-08-25 9:01 GMT+01:00 kamild : > Helo, > when claim order (Acquisitions › Late orders) I get

Re: [Koha] Claim mail is not sent to Vendor - KOHA 16.05.02

2016-08-25 Thread Jonathan Druart
When you claim issues, the email is sent directly and does not pass by the message_queue table. Moreover the email used for the 'From' is the email address defined for the logged in user. As the error is "Sender address rejected", you should check the email of the account used to claim

Re: [Koha] MARC Modification Templates & indicators

2016-08-30 Thread Jonathan Druart
Hi Eric, I confirm that MARC modification templates do not deal with indicators so far. Regards, Jonathan 2016-08-30 1:19 GMT+01:00 Eric Phetteplace : > Hi collective wisdom, > > We're trying to fix up an issue with our records by copying information > from the 810 MARC

Re: [Koha] No patron categories in Munich

2016-09-29 Thread Jonathan Druart
Hi Frans, Welcome to the Koha community! The patch on bug 17069 fixes a bug added by bug 6906, which is not in 16.05. So you should not need it. What is the error? You can also try the latest 16.05.04 Regards, Jonathan 2016-09-29 17:54 GMT+02:00 Frans van Koppen

Re: [Koha] Zebra/Plack/Timeout Issue

2016-10-05 Thread Jonathan Druart
For the timeout, you can also try to switch off SessionRestrictionByIP. Please keep us in touch if it fixes the issue. 2016-10-04 21:11 GMT+02:00 rfblanchard : > Upgraded to koha 16.05.04 and debian 8.6 today > -my sessionStorage was mysql. I tried to change it to

Re: [Koha] Zebra/Plack/Timeout Issue

2016-10-04 Thread Jonathan Druart
Hi, try to swith the system preference SessionStorage to mysql instead of memcached 2016-10-04 19:31 GMT+02:00 rfblanchard : > I just started using plack yesterday and I ran the commands below to get > started. Everything was fine. The next morning I found that plack

Re: [Koha] Koha Performance Issue

2016-10-04 Thread Jonathan Druart
Hi Martin, You can have a look at the server load to know if it's busy. You will need to fix your network issues before inspecting any else I'd say. Regards, Jonathan 2016-10-03 21:02 GMT+02:00 Martin House : > Out of curiosity, does the amount of RAM make a significant

Re: [Koha] Koha Performance Issue

2016-10-04 Thread Jonathan Druart
Hi, What are the specs of your server? Koha 3.0 and Koha 16.05 are completely different in term of features and architecture. I would recommend you to start a fresh install using packages (https://wiki.koha-community.org/wiki/Koha_on_Debian), re-inject your DB and upgrade it. Then you must

Re: [Koha] IP restrictions not taking effect

2016-08-18 Thread Jonathan Druart
Hi, I have fixed this bug a couple of days ago on bug 9569. Regards, Jonathan 2016-08-17 6:26 GMT+01:00 Dalton Fury : > Hey Katrin, > > I tried it and still it does not work. > > Regards, > Navaneeth > > On Sun, Aug 14, 2016 at 2:10 PM, Katrin Fischer

Re: [Koha] Global system preferences changes not taking effect completely

2016-08-26 Thread Jonathan Druart
I found this line in your log: DBD::mysql::st execute failed: MySQL server has gone away [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='opacgroupresults'] at

Re: [Koha] Not able to change framework when editting biblio record

2016-09-29 Thread Jonathan Druart
Hi Pedro, Have a look at bug 17206 - Can't switch to default framework Cheers, Jonathan 2016-09-28 19:13 GMT+02:00 Pedro Amorim : > Dear all, > > I just recently updated our Koha from 3.22 to 16.05 and now we cannot > change from whatever framework the record is (editting

Re: [Koha] OPAC self registration - userid non-Latin characters problem

2016-10-04 Thread Jonathan Druart
Hi Michax, hum Michał I mean Yes this is a bug, please see bug 17393, I will try to provide a patch quickly Regards, Jonathan https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17393 2016-10-03 17:40 GMT+02:00 Michał Dudzik : > Hi, > when a user registrates from

Re: [Koha] Curious behaviour with batch modified records - ghost fields

2016-11-08 Thread Jonathan Druart
Hello Elaine, Is 245$h linked with a koha field? Did you keep a version of the record before you managed to remove the "ghost" field? If yes, did you try to import it on a fresh install to see if the behavior is the same? It would be good to have some steps to recreate the issue :) Regards,

[Koha] What's on in Koha devel #6 - Special post hk16

2016-10-19 Thread Jonathan Druart
Hello librarians and developers, On the same way as my previous email, I think it would be useful for everybody to get feedback on what was going on during the hackfest in Marseille last week. I plan to send the next "What's on in Koha devel" emails to both koha and koha-devel lists, if nobody

Re: [Koha] Z39.50 - internal server error

2016-11-14 Thread Jonathan Druart
Hi Radek, Which version of Koha are you running on? What are you local changes? Did you try without? Cheers, Jonathan On Mon, 14 Nov 2016 at 08:49 wrote: > Hi, > > sometimes we are facing very annoying problem concerning Z39.50 > searching, bacause all attempt to

[Koha] What's on in Koha devel #7

2016-11-15 Thread Jonathan Druart
Hello librarians and developers, Koha 16.11 will be released soon, in 1 week only (November 22nd). We are entering the string freeze which means that only bug fixes without string changes will get pushed. But developers are already focused on 16.12, the next development version :) Note that we

Re: [Koha] Field 773 $t not editable in any framework

2016-11-18 Thread Jonathan Druart
Michael, Recreate against master, please open a new bug report. This is very weird, I did not manage to find why this tab causes problem. Did you find another one? Cheers, Jonathan On Fri, 18 Nov 2016 at 15:32 Michael Kuhn wrote: > Hi > > I'm working with Koha 16.05.05. > >

Re: [Koha] Item type icons do not show

2016-11-18 Thread Jonathan Druart
Hi Michael, Yes this is a bug: when you edit the item types, the images are picked from the intranet image dir (intranet-tmpl/prog/img/itemtypeimg) but when they are displayed, they are picked from the opac image dir (opac-tmpl/bootstrap/itemtypeimg). I don't understand why the demos do not have

Re: [Koha] Item type icons do not show

2016-11-18 Thread Jonathan Druart
See bug 17657, patch is coming very soon On Fri, 18 Nov 2016 at 09:00 Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Hi Michael, > > Yes this is a bug: when you edit the item types, the images are picked > from the intranet image dir (intranet-tmpl/pr

Re: [Koha] F5 Attacks

2016-11-01 Thread Jonathan Druart
Hi, I don't think this can/must be fixed on Koha side. It's a sysadmin duty to take care of that. I would take a look at fail2ban to parse the web server access logs. But make sure not to block your X librarians using the same ip ;) On Wed, 26 Oct 2016 at 12:28 Pedro Amorim

Re: [Koha] Not accepting Date of birth after upgrade to 16.05.05

2016-11-02 Thread Jonathan Druart
Hi José, Yes it's a bug and it will be fixed by the patch on bug 17524. Regards, Jonathan On Wed, 2 Nov 2016 at 17:41 anjoze wrote: > After upgrading to version 16.05.05 I cant insert/change Patron's Date of > Bird anymore. > > If I pick from calendar it just disappears.

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

Re: [Koha] F5 Attacks

2016-10-26 Thread Jonathan Druart
Hi, I don't think this can/must be fixed on Koha side. It's a sysadmin duty to take care of that. I would take a look at fail2ban to parse the web server access logs. But make sure not to block your X librarians using the same ip ;) On Wed, 26 Oct 2016 at 12:28 Pedro Amorim

Re: [Koha] ldap authentication in Koha 16.11 become broken when enabling plack

2016-12-14 Thread Jonathan Druart
Hello Mohammed, I did not test the ldap authentication under plack but reading the code of C4/Auth_with_ldap.pm I confirm that it's not plack compatible. Please open a new bug report and mark it as a blocker of bug 7172. Regards, Jonathan On Wed, 14 Dec 2016 at 12:04 Mohammad Nashbat

Re: [Koha] Number of Koha Libraries in the Word

2016-12-12 Thread Jonathan Druart
Hello Sebastian and others, Do not forget that you can easily register a library on the hea community website: https://wiki.koha-community.org/wiki/KohaUsageStat_RFC In addition to list the library it also permits to collect different statistics on the usage of Koha. Regards, Jonathan On Wed,

Re: [Koha] Number of Koha Libraries in the World

2016-12-13 Thread Jonathan Druart
The easiest way in my opinion would be to improve Hea, we already have Koha instances sending their data. It is very easy for libraries to register as they just need to fill some sysprefs in. On Tue, 13 Dec 2016 at 17:04 Nathan Curulla wrote: > Hi Everyone, > > I hear

Re: [Koha] Number of Koha Libraries in the Word

2016-12-12 Thread Jonathan Druart
That has been fixed in new versions. On Mon, 12 Dec 2016 at 12:04 Michael Kuhn wrote: > Hello Jonathan > > > Do not forget that you can easily register a library on the hea community > > website: > > https://wiki.koha-community.org/wiki/KohaUsageStat_RFC > > > > In addition

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Jonathan Druart
No, I meant for the next upgrades:when something went wrong during the update process, don't close your eyes. If the table items_search_fields was missing you certainly got an error when you upgraded from a previous version. On Wed, 30 Nov 2016 at 18:03 anjoze wrote: >

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Jonathan Druart
Yes, keep in mind to check the errors when you upgrade your database :) On Wed, 30 Nov 2016 at 17:19 anjoze wrote: > Ok, I've found the sql file on > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/kohastructure.sql > > I've executed: > CREATE TABLE IF NOT EXISTS

Re: [Koha] broken kohadevbox

2016-11-30 Thread Jonathan Druart
The Internet answers things about proxies, firewalls and http, try using git:// instead: `git remote set-url origin git://git.koha-community.org/koha.git` then `git remote update` On Wed, 30 Nov 2016 at 20:22 Radek Šiman wrote: > Dear collegues, > please help me to fix

Re: [Koha] Migration erros from 16.05 to 16.11

2016-11-30 Thread Jonathan Druart
The table items_search_fields does not exist whereas it has been created by 3.17.00.046. You should manually replay this update DB entry ("CREATE TABLE IF NOT EXISTS items_search_fields [...]") then redo the whole update process. On Wed, 30 Nov 2016 at 12:13 anjoze wrote: >

Re: [Koha] MySQL database server, dedicated vs virtual

2016-12-05 Thread Jonathan Druart
Paul, Hum sounds like I already answered you the same things a few months ago... Well, you are still comparing 3.8 with 3.18, last release is 16.11, with plack and memcached support. What you missed (living in the past): Bug 15342 - Performance 3.22 - Omnibus Bug 7172 - Omnibus for Plack

Re: [Koha] Wide character error

2016-12-05 Thread Jonathan Druart
This is a bug, I have opened a new bug report and will try to attach a patch soon. See bug 17096. On Sun, 4 Dec 2016 at 11:05 Abdulsalam Yousef wrote: > Hello all, > > We have an error appears during navigation through ( patron pages) in koha > 16.11 > for example when

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

2016-12-05 Thread Jonathan Druart
Hello librarians and developers, Koha 16.11 and its Debian packages have now been released [1]. As Mirko noted Debian Wheezy is no longer supported and Debian packages won't be provided for 3.22 [2]. I should also added that some important bugs have been reported recently and it may be better

Re: [Koha] Handling of TimeZones and different Calendars (Thailand Buddhist Calendar) on a single shared Koha server

2017-01-02 Thread Jonathan Druart
Hello Alex, On Tue, 3 Jan 2017 at 05:09 Alex Shepherd wrote: > Hi Guys, > > I’m hoping to host several independent libraries on a single VM. > > The libraries are all in Asia spread across Sri Lanka, Myanmar and Bangkok > and the server is a VM hosted on Digital Ocean in

Re: [Koha] Template Toolkit Syntax for Slips & Notices

2017-01-02 Thread Jonathan Druart
Silence will be considered as an agreement. If you have any questions, please do not hesitate to ask. Regards, Jonathan On Tue, 6 Dec 2016 at 16:03 Kyle Hall wrote: > Hey All! > > As you may know, Koha 16.11 supports the use of Template Toolkit markup in > Koha's slips

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

2017-01-09 Thread Jonathan Druart
Hello librarians and developers, I wish you a happy new year, 2017 will be awesome, I am sure :) At least it will be a great year for your favourite ILS - Koha is constantly improving and next releases will be even better than the last ones, as always :) = Hea = Some of us are still a bit

Re: [Koha] "Item-level_itypes set but no itemtype set" leads to 'Can't locate object method "ymd"'

2016-12-29 Thread Jonathan Druart
Hello Fred, If bug 17502 fixes your problem that mean that you have the items.onloan field set to '-00-00'. That could happen with old database. The easiest way to fix it is to fix the value in the database directly. You can fix it (without applying the patch) by setting this value to NULL.

Re: [Koha] Wide character error

2016-12-29 Thread Jonathan Druart
The issue occurs when userid has unicode characters. I am going to submit a patch on bug 17830. On Sun, 4 Dec 2016 at 11:05 Abdulsalam Yousef wrote: > Hello all, > > We have an error appears during navigation through ( patron pages) in koha > 16.11 > for example when

Re: [Koha] Repeat this Tag not working

2016-12-21 Thread Jonathan Druart
Can you try and recreate the problem on a demo install? On Wed, 21 Dec 2016 at 11:27 anjoze wrote: > This is worst than I thought! > If I edit a Record and try to duplicate *field 021* it will do nothing. > Then I change the subfield *$a* (Country code) and than I can

Re: [Koha] SQL for overdues / fines by borrower ?

2016-12-20 Thread Jonathan Druart
Hello Scott, You should find what you are searching for on the wiki: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Accounting_Reports_.28Fines.2FCredits.2FEtc.29 Regards, Jonathan On Tue, 20 Dec 2016 at 17:57 Scott Owen wrote: > Hi all, > One of my Liberians is

Re: [Koha] Add funds in bulk?

2016-12-21 Thread Jonathan Druart
Hi Márton, No there is no way to do that using the interface, but you can construct SQL queries to insert the funds into the budgets table (table aqbudgetperiods for the budgets and aqbudgets for the funds). Regards, Jonathan On Wed, 21 Dec 2016 at 13:09 Marton VILLANYI

Re: [Koha] Repeat this Tag not working

2016-12-20 Thread Jonathan Druart
Hello José, It seems to work correctly for me (16.11.00, UNIMARC, fields 701 and 702). Did you just upgrade? Did you restart memcached and plack? Cheers, Jonathan On Tue, 20 Dec 2016 at 10:24 anjoze wrote: > Since upgrade to 16.11 when I click on *Repeat this Tag*

Re: [Koha] Repeat this Tag not working

2016-12-28 Thread Jonathan Druart
See bug 17817 (Repeat this Tag (cloning) not working) for a patch. On Tue, 27 Dec 2016 at 19:03 Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Confirmed, please open a new bug report and assign it to me. > I will try and provide a patch tomorrow. > > O

Re: [Koha] Repeat this Tag not working

2016-12-27 Thread Jonathan Druart
Confirmed, please open a new bug report and assign it to me. I will try and provide a patch tomorrow. On Tue, 27 Dec 2016 at 18:03 anjoze wrote: > This is for sure a bug. > I've setup a completely new VM: > Debian GNU/Linux 8.6 (jessie) > MariaDB Ver 14.14 Distrib 5.5.53 >

Re: [Koha] Fwd: Error in Koha

2017-03-30 Thread Jonathan Druart
Looks like it means you have one record without the biblionumber field. How did you import you records into Koha? Did you try a full reindex? On Thu, 30 Mar 2017 at 01:58 Bharat Chaudhari wrote: > now my koha version is 16.11.05.000 > > On Thu, Mar 30, 2017 at 12:53 AM,

Re: [Koha] Fwd: Error in Koha

2017-03-30 Thread Jonathan Druart
Hi, I do not find your message in my mailbox... This error is caused because you have one of your subfields (in one of your biblio frameworks) which is linked with the authorised value 'branches'. However one of your records has a value in this subfield that is not a branchcode defined in your

Re: [Koha] INSTALLATION OF KOHA ON DEBIAN USING TERMINAL

2017-03-23 Thread Jonathan Druart
Hello, If you are more confident with Ubuntu, stick with it. You can fix the MySQL 5.7 issues with 2 ways: remove the strict mode or use MariaDB instead. See the wiki page: https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Ubuntu_16.04_and_MySQL_5.7 On Thu, 23 Mar 2017 at 13:11

Re: [Koha] Software Error while exporting data

2017-03-29 Thread Jonathan Druart
Hi, Yes it's a known bug in very recent version. See bug 18312. It's on its own to be included, but its inclusion took more time than expected, no idea why. Regards, Jonathan On Wed, 29 Mar 2017 at 07:16 Sahadeo Taware wrote: > Dear Friends > > While exporting data,

Re: [Koha] Error - Exported database from the tools

2017-03-29 Thread Jonathan Druart
Hi, Yes it's a known bug in very recent version, it will be fixed in next stable release (next month). See bug 18312. Regards, Jonathan On Wed, 29 Mar 2017 at 09:11 Shivendra wrote: > When I Exported database from the tools menu fails with the message > Internal Server

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

2017-03-21 Thread Jonathan Druart
Hi Michael, That sounds like a bug. By chances do you have a dump of this table somewhere? I'd like to recreate the issue. Cheers, Jonathan On Mon, 20 Mar 2017 at 21:27 Michael Kuhn wrote: > Yesterday I wrote: > > > Using Koha 16.11.04 (via Debian package installation) on

Re: [Koha] Facebook, twitter and other icons

2017-03-21 Thread Jonathan Druart
Turn on pref SocialNetworks. On Tue, 21 Mar 2017 at 11:16 Luis Moises Rojas wrote: > Hi, > How can we insert facebook, twitter, whatsapp and others icons in our OPAC? > > Thanks > > -- > *Luis Moisés Rojas P.* > > > < >

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

2017-03-21 Thread Jonathan Druart
If we are lucky, only the issuingrules table would be needed. But nevermind, if you fixed it I guess everybody is happy. On Tue, 21 Mar 2017 at 08:08 Michael Kuhn wrote: > Hi Jonathan > > > That sounds like a bug. > > By chances do you have a dump of this table somewhere? I'd

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

2017-04-04 Thread Jonathan Druart
Hello librarians and developers, Not much has happened this month in terms of development. Things are going very slowly at the moment, despite the hackfest in Marseille. We see a lot of new people on the mailing list and the IRC channel asking for questions, but we need more people to be

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

2017-04-04 Thread Jonathan Druart
Hello "admin", What you describe is very weird: launch a search, click on a page number, then "No results found" is displayed, you refresh and you see the expected results? That's it? I'd try the English interface (not translated) and check Koha logs. Regards, Jonathan On Tue, 4 Apr 2017 at

Re: [Koha] No patron search results in Koha 16.05.09

2017-04-12 Thread Jonathan Druart
Anselm, You are using a non supported version of Koha, you should try and update it to a more recent one. What you describe can happen if the JSON returned by the server is malformed. To check that, before launching a patron search, open the browser's console (firebug or dev tool) and copy/paste

Re: [Koha] [Koha-devel] What's on in koha-devel #11

2017-04-11 Thread Jonathan Druart
org> wrote: > Of the two meetings you mention, which one would best fit a librarian user > and abuser? > > Wendy Sharkey > Bennington, Vermont > > > ------ > *From:* Jonathan Druart <jonathan.dru...@bugs.koha-community.org>

<    1   2   3   4   5   6   7   8   >