Re: [Koha] Language confusion on the Circ Fine Rules

[Jonathan Druart]

 I'm confused by this one. Is this required? I don't have it filled in
 in my test system and it doesn't block me from circulation or holds.

Hi,

If the section Default checkout, hold and return policy for all libraries
is not defined, the default values are used.
These default values are hardcoded : the max issue quantity is undef (no
limit), the hold policy = 2 (i.e. holds are allowed for any patron) and the
return policy = homebranch (i.e. items has to be returned to the homebranch)

Regards,
Jonathan

The code is in C4::Circulation:
C4::Circulation::GetBranchItemRule, lines
# built-in default circulation rule
$result-{'holdallowed'} = 2 unless ( defined $result-{'holdallowed'}
);
$result-{'returnbranch'} = 'homebranch' unless ( defined
$result-{'returnbranch'} );
and C4::Circulation::GetBranchBorrowerCircRule line
# built-in default circulation rule
return { maxissueqty = undef, };
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] A couple Koha acquisitions questions

[Jonathan Druart]

Hello Mathieu,

Please have a look at the Bug 7180. I introduce this mapping when ordering
from an import in iso2709.

Regards,
Jonathan


2012/12/4 Mathieu Saby mathieu.s...@univ-rennes2.fr

 Hello
 A mapping of 9XX fields in MARC files imported to create orders could be
 an interesting feature.

 For example, in France, some libaries use the website of the main
 commercial record provider (Electre) to define acquisition information
 (quantity, price, discount, statistic codes...) in 9XX fields of exported
 records, and some ILS can manage these informations automatically when
 records are imported (in iso2709).

 This is how it looks in the record provider website :




 And, just for an example, this is how looks the tool used for this mapping
 records in Horizon ILS






 Regards,

 M. Saby



 Ann-Marie Breaux a écrit :

 Thank you for this information, Magnus. I guess that for now, libraries
 are either doublekeying orders between the book vendor system and Koha, or
 else send e-mail or printed orders to the book vendor.
 In any event, YBP would be interested in testing either EDI or embedded
 order data (acquisitions data in 9xx MARC fields) if the community decides
 to pursue it.
 Best regards,
 Ann-Marie

 __**__
 From: koha-boun...@lists.katipo.co.**nz koha-boun...@lists.katipo.co.nz[
 koha-boun...@lists.katipo.co.**nz koha-boun...@lists.katipo.co.nz] on
 behalf of Magnus Enger [mag...@enger.priv.no]
 Sent: Tuesday, December 04, 2012 3:10 AM
 To: koha@lists.katipo.co.nz
 Subject: Re: [Koha] A couple Koha acquisitions questions

 On 3 December 2012 21:47, Ann-Marie Breaux abre...@ybp.com wrote:


 Hi everyone,

 YBP is a book wholesaler for academic libraries. We have several
 libraries now using Koha as their ILS. The acquisitions functionality seems
 a little light, and less integrated than we have with other systems. Could
 you confirm the following for me?


 1.Is there any EDI functionality in Koha yet? Can libraries send
 EDIFACT Orders and/or receive EDIFACT POAs or Invoices?



 There are a couple of bug reports related to this:

 Bug 7736 - Edifact QUOTE and ORDER functionality
 http://bugs.koha-community.**org/bugzilla3/show_bug.cgi?id=**7736http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736

 Bug 2443 - Acquisitions by EDIFACT
 http://bugs.koha-community.**org/bugzilla3/show_bug.cgi?id=**2443http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2443

 The first one has a status of Failed QA, which means someone
 implemented it, but it is temporarily stuck in the Quality Assurance
 stage of development. I am not sure of the state of the second one.



 2.If a library has placed an order in the book vendor's online
 system, is there any way to load that order information into Koha without
 rekeying? Some systems we work with can accept acquisitions data in 9xx
 MARC fields to populate into an order record automatically.



 There is an API described here:
 http://wiki.koha-community.**org/wiki/Koha_/svc/_HTTP_APIhttp://wiki.koha-community.org/wiki/Koha_/svc/_HTTP_API
 that should let you enter bibliographic records into Koha, given the
 right username/password. This would create a record, but not an order
 in the aquisitions module. I have a client that is interested in
 adding functionality to Koha that would place records added in this
 way in a queue, alert librarians to the presence of new records and
 make it easy to attach newly added records to orders in the
 aqusistions module. This development is in the early stages of being
 sketched out, but if anyone else is interested in similar
 functionality please let us know.

 Best regards,
 Magnus Enger
 libriotech.no
 __**_
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/**mailman/listinfo/kohahttp://lists.katipo.co.nz/mailman/listinfo/koha
 __**_
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/**mailman/listinfo/kohahttp://lists.katipo.co.nz/mailman/listinfo/koha




 --
 Mathieu Saby
 Service d'Informatique Documentaire
 Service Commun de la Documentation
 Université Rennes 2
 Téléphone : 02 99 14 12 65
 Courriel : mathieu.s...@univ-rennes2.fr

 __**_
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/**mailman/listinfo/kohahttp://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] 403 Forbidden After dev installation !

[Jonathan Druart]

Hi Karam,

It seems your koha directory doesn't have the read permission for ww-data
(should be 755 too)

drwxrwx--- 3 karam karam 4096 Apr 13 13:22 koha

Regards,

Jonathan


2013/4/16 Karam Qubsi karamqu...@gmail.com

 Thanks Bernardo :)
 I do this :
 chmod 755 /home/karam

 # ls -l
 total 52
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Desktop
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Documents
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Downloads
 -rw-r--r-- 1 karam karam 8445 Apr 15 02:04 examples.desktop
 drwxrwx--- 3 karam karam 4096 Apr 13 13:22 koha
 drwxrwxr-x 8 karam karam 4096 Apr 15 01:14 koha-dev
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Music
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Pictures
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Public
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Templates
 drwxr-xr-x 2 karam karam 4096 Apr 15 02:09 Videos


 sudo /etc/init.d/apache2 restart
 The Problem is not solved :( .







 On Tue, Apr 16, 2013 at 1:47 PM, Bernardo Gonzalez Kriegel 
 bgkrie...@gmail.com wrote:

 Hi Karam,

  Forbidden

 You don't have permission to access / on this server.

 Additionally, a 403 Forbidden error was encountered while trying to use
 an ErrorDocument to handle the request.
 --
 Apache/2.2.22 (Ubuntu) Server at 127.0.1.1 Port 8080

 this indicates that you have permissions problem for apache.
 As you did a dev install, it uses a home dir, so check that
 that folder have proper permisions.

 I suspect thar you user admits only access to himself in his home (ls -l
 /home/$USER),
 if that's the case do a chmod 755 /home/$USER

 Regards,
 Bernardo





 --
 *Karam Qubsi*




 ___
 Koha-devel mailing list
 koha-de...@lists.koha-community.org
 http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
 website : http://www.koha-community.org/
 git : http://git.koha-community.org/
 bugs : http://bugs.koha-community.org/

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Enhanced messages

[Jonathan Druart]

Hello Olugbenga,

You have to switch on the EnhancedMessagingPreferences for theses
messages to be sent.

If you want to enable options for all patrons, you must do that in the
cli of your dbms.

For example, for Item checkout and Item check-in:

insert into borrower_message_preferences(borrowernumber,message_attribute_id)
select borrowernumber, 5 from borrowers;
insert ignore into
borrower_message_transport_preferences(borrower_message_preference_id,
message_transport_type) select borrower_message_preference_id, 'email'
from borrower_message_preferences where message_attribute_id = 5;

insert into borrower_message_preferences(borrowernumber,message_attribute_id)
select borrowernumber, 6 from borrowers;
insert ignore into
borrower_message_transport_preferences(borrower_message_preference_id,
message_transport_type) select borrower_message_preference_id, 'email'
from borrower_message_preferences where message_attribute_id = 6;

The 5 and 6 values correspond to the message_attribute_id in the
message_attributes table (select * from message_attributes;)

Regards,
Jonathan

2013/8/28 Olugbenga Adara gbengaad...@yahoo.com:


 Hello all,

 Is it possible to have all Koha patrons get messages like checkin, checkout 
 etc without setting the
 EnhancedMessagingPreferences to Allow? I had assumed that this was not 
 necessary but Koha was not sending messages until I turned this on and 
 enabled it for the patron.

 If the EnhancedMessagingPreferences must be set, is there any way to auto 
 enable the messaging options for all patrons who are already on the system as 
 a default?

 I am running 3.12.3 on Debian 7


 Thanks

 Olugbenga Adara


 Skype: gbengaadara
 Blog: http://gbengaadara.blogspot.com
 Twitter: http://twitter.com/gbengaadara
 Profile: http://www.linkedin.com/in/gbengaadara
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Solr

[Jonathan Druart]

Viviane,

Did you configure mappings ?

Regards,
Jonathan

2013/10/21 Viviane Ventura vaventu...@yahoo.com.br:
 Hi!

 Im using koha 3.12 e im trying to use solr instead of zebra as search
 engine.
 Everything seems fine except that solr is not indexing the records
 correctly.
 Each record looks like this:

 doc
 str name=idbiblio_1/str
 str name=recordid1/str
 str name=recordtypebiblio/str
 str name=srt_ste_title/
 str name=srt_str_author/
 /doc

 Any ideas?
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Solr

[Jonathan Druart]

Viviane,

Are you conscious of Solr is a not completely implemented in Koha?
The current Koha code allows to configure your indexes/mappings and to
launch a search on OPAC.
The staff interface does not use the Solr search.

Note there has been a discussion at the KohaCon about Solr, see the
wiki page http://wiki.koha-community.org/wiki/KohaCon13_searchengine_plan

Regards,
Jonathan

2013/10/22 Viviane Ventura vaventu...@yahoo.com.br:
 Oh, thanks. Now the record looks like this:


 doc
 str name=idbiblio_1/str
 str name=recordid1/str
 str name=recordtypebiblio/str
 str name=srt_ste_titleCONJUNTURA ECONÔMICA/str
 str name=srt_str_author/
 arr name=ste_titlestrCONJUNTURA ECONÔMICA/str/arr
 arr name=str_titlestrCONJUNTURA ECONÔMICA/str/arr
 /doc

 However, when i search for CONJUNTURA, i have:

 No results found

 No results match your search for 'kw,wrdl: conjuntura'.

 Is there another configuration I'm forgetting to set?




 2013/10/22 Jonathan Druart jonathan.dru...@biblibre.com

 Viviane,

 Did you configure mappings ?

 Regards,
 Jonathan

 2013/10/21 Viviane Ventura vaventu...@yahoo.com.br:
  Hi!
 
  Im using koha 3.12 e im trying to use solr instead of zebra as search
  engine.
  Everything seems fine except that solr is not indexing the records
  correctly.
  Each record looks like this:
 
  doc
  str name=idbiblio_1/str
  str name=recordid1/str
  str name=recordtypebiblio/str
  str name=srt_ste_title/
  str name=srt_str_author/
  /doc
 
  Any ideas?
  ___
  Koha mailing list  http://koha-community.org
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Patches to test for 3.16

[Jonathan Druart]

Hello Koha community,

As some of you know, I work for BibLibre.
So I am a Koha developper and a member of the QA team (freshly re-elected
for 3.16 cycle \o/).
The 3.14 version is closed to be release and we have 6 months for working
together for the 3.16 version.

A lot of BibLibre's patches are in the patches queue (needs signoff, needs
QA) and I think some could interest you.
We never communicate enough.

That's why I would like to list and explain some of features you can
already tested:

* Search history
I refactored some code on search history. This has been permit to simply
add a search history to the intranet interface.
Moreover, I added a search history for authority searches too.
See:
- Bug 10807 - OPAC: There is no authority search history
- Bug 10862 - Add an search history for the staff interface
and linked reports.
These ones are closed to be pushed

* Acquisition module

Small fixes:
- Bug 11171 - The basket group is not displayed on the supplier list page
- Bug 11170 - The pending order list should only display orders to receive

Improvements:
- Bug 8991 - Add a script to delete old orders
A simple script for deleting old oeders.

- Bug 11141 - Filters are not kept on receiving
You are irritated when you receive an order to fill filters for each
reception?
This patch will fix that.

- Bug 11018 - Add order from a reverted file
Currently, a reverted staged file cannot be add to an order. It is caused
by a bug.
A simple patch will allow to do it.

The only big feature in the queue for the moment is:
- Bug 7180 - Order from staged file improvements (in failed QA).

* Serials module
- Bug 8438 - Users should only claim for serials related to their branch.

- Bug 5342 - Serial claiming improvements
This one is lost in the bug list depth. On the same way of orders, a claim
counter will be added to the serials claims.

* Reports module
- Bug 9216 - Add a file for table headings translation and copy of this
file during the translation process.
This patch allows to translate headers. Currently, in the report module,
headers are always in English.

- Bug 7683 - statistic wizard: cataloging

- Bug 7679 - Statistics wizard: circulation (new filters)

* Circulation module
- Bug 11120 - The date option for the overdue_notices cronjob is broken
The overdue_notices cronjob has a --date parameter but it has never worked.
With this patch, you will be able to generate overdue notices for a given
date.
It is really useful when you want to recover a failure, for example.

- Bug 10860 - In-House Use
The current Koha in-house use implementation is not complete.
This feature will allow you to easily distinguish a normal checkout to an
in-house use.

- Multi transport types
Several patches focus on notices and a way to add more than one transport
type for a notice.
For example, it will be possible to notify a patron with an email *and* a
sms for the first overdue level.
Moreover a template per transport type can be created for 1 letter. So it
is possible to create a short notice for sms and a longer one for email.
See the following:
Bug 9016 - Multi transport types for notices
Bug 10833 - Multi transport types for advanced notices
Bug 10845 - Multi transport types for holds
Bug 10832 - Multi transport types for overdue notices

* Cataloguing
- Bug 8064 - Merge several biblio records
To merge 2 records is possible since several versions but this patch allows
to merge as many records as you want.

* Search
- Bug 10857 - Add facets cancellation
At the OPAC and staff interfaces, a link will permit to cancel a facet. In
the current code, you have to re launch your search and re add wanted
facets, with this patch, a simple link will save your time :)

- Bug 10858 - Browse selected biblios
Select a set of biblios and browse them, it is now possible.

- Bug 9811 - Patrons search improvements
A new sexy patron search! Using AJAX, it will be easy to find any patrons
with any information.

* Tools
- Bug 11023 - Toggle new status for items
Automatically change the status for items: a cronjob script will update
status given some conditions.
It can be useful for displaying an icon near new items, create a
syndication feeds with new items only, etc.

- Bug 10212 - Columns configuration for tables
I think this one is really fun. Everyone may configure tables like he wants.
If you want to display only 5 columns in the parcel page, it will be
possible.
This patch is a start, but has to move forward for continuing.

And a lot of others patches!

If something is not clear, don't hesitate to let a question on a note on
the appropriate report.

The goal of this email is to motivate all of you to signing off them (and
all others!), or QA them, and takes your attention on what is existing in
the queue.

During the last year, it was really difficult to rebase again and again
patches for 2 reasons: 1/ Patches are not tested and 2/ Others features
don't take into account patches already submitted. So please developers,
check if an existing 

Re: [Koha] Serials (multiple items)

[Jonathan Druart]

Hello Paul and Robin,

I filled a new report (bug 11256) and submitted a patch.

Regards,
Jonathan


2013/11/15 Robin Sheat ro...@catalyst.net.nz

 Paul schreef op do 14-11-2013 om 20:28 [-0500]:
  I have just been asked (more a comment than a complaint) why serials with
  several items come up on the OPAC with:
 
  This record has many physical items. Click here to view them all.  Is
  this a reasonable message for an OPAC user?

 In theory, because displaying thousands of items can cause some browser
 to bog down, also loading them all all the time takes koha a while
 (there are quite a number of redundant database connections going on per
 item, we've been slowly working on reducing them.) However, it seems to
 load them all anyway even if it's not going to immediately show them, it
 perhaps shouldn't do that.


 --
 Robin Sheat
 Catalyst IT Ltd.
 ✆ +64 4 803 2204
 GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF

 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Acquisition (ordering) error

[Jonathan Druart]

Hi Evan,

I tested on 3.12.06 and I am not able to reproduce your issue.
Do you have your currencies correctly defined (with an active one)?
Do you get a javascript error ?

Regards,
Jonathan


2013/11/15 Evan Mungai Njoroge evan.njor...@gmail.com

 I am running Koha 3.12.06.000 installed via packages (running on ubuntu
 12.04). Everything runs ok until I tested Acquisitions.

 When you try to order on any of the options, new empty file etc, and fill
 in duly the options. The Replacement cost; Budgeted cost and Total do not
 automatically fill in appropriate figures  instead gives an output
 *NaN*.
 See the screenshot here:
 https://dl.dropboxusercontent.com/u/7725309/koha_acqu_error.png

 Kindly help.


   EVAN
 NJOROGE *•*about.me/uhusiano *•*adlsn.org
 * Facilitating access to African digital content *
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to print checked out items and news from the quick

[Jonathan Druart]

Hello,

I just talked about 11040 with Fridolin and he will push it soon in the
3.14.x branches.

Regards,
Jonathan


2013/12/13 Chris Cormack ch...@bigballofwax.co.nz

 On 13 December 2013 12:21, BRANNON, CHRISTOPHER cbran...@cdalibrary.org
 wrote:
  Tim,
  If you can figure something out, let me know.  We've found the
 same issue, and it does not look like you can bring all the information
 from the regular slip over to the quick slip.  It would be nice if we had a
 choice as to which slip is printed with the enter key.
 

 Your wish is Koha's command:

 In fact Peggy Thrasher has written a patch to do exactly this, it was
 pushed to master in November. It will be up the the 3.14.x release
 maintainer if it goes into the 3.14.1 release, otherwise it will be in
 the 3.16.0 release

 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11040

 Chris
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] moremember.pl shows high CPU usage after upgrade to 3.14

[Jonathan Druart]

Hello Jason,

Do you have a lot of holidays defined?
If yes, try to upgrade to 3.14.2 (see bug 2)

Regards,
Jonathan

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2


2014/1/8 Jason Sherman jsher...@usao.edu

 Hi all,

 After upgrading our system to 3.14, things are generally great, with the
 exception of this one issue.  Loading the moremember.pl page for patrons
 with overdues takes upwards of 20 seconds, and top shows that the script is
 completely hogging the CPU.  Patrons without overdues load just fine.  My
 first thought was that it was doing some kind of crazy db query, but mysqld
 doesn't seem to be using any more resouces than usual while this is
 happening. Has anybody else experienced this?  Any suggestions?

 --
 Jason Sherman
 Systems Librarian
 University of Science and Arts of Oklahoma
 405.574.1340
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Sandboxes improvements ?

[Jonathan Druart]

Hello all,

The hackfest in Marseille is coming soon and sandboxes will be used
intensively :)
There are known bugs and I have already received some improvement
requests. I would like to know if someone here, using sandboxes
regularly, has a special need.
If you are annoyed when using them, it is now or never to express yourself!

Regards,
Jonathan
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New patron restrictions data

[Jonathan Druart]

Hello Nicole,

It is in the borrower_debarments table.

Regards,
Jonathan

2014-03-20 15:00 GMT+01:00 Nicole Engard neng...@gmail.com:
 Hi all,

 I'm wondering where in the DB the new restrictions data is stored for
 patrons.  I have a patron with 2 restrictions on her account and when
 I look at borrowers.debarred I only see 1 of them. The other shows
 when I view the record in the staff client so the data has to be
 somewhere ... where is it? :)

 Thanks
 Nicole
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.16 beta available

[Jonathan Druart]

Hello all,

Note that BibLibre sandboxes 6 (MARC21) and 16 (UNIMARC) have been
updated to this tag and can be used to test this beta release.

see http://wiki.koha-community.org/wiki/Sandboxes for more details
about sandboxes.

Regards,

Jonathan

2014-05-06 1:56 GMT+02:00 Galen Charlton g...@esilibrary.com:
 Hi,

 A beta release of Koha 3.16 is available for download at
 http://download.koha-community.org.  More details, including draft
 release notes, can be found at
 http://koha-community.org/koha-3-16-beta-released/.

 I strongly encourage folks to download and test the beta release.
 General release of 3.16.0 is scheduled to occur on Thursday, 22 May.

 Regards,

 Galen
 --
 Galen Charlton
 Manager of Implementation
 Equinox Software, Inc. / The Open Source Experts
 email:  g...@esilibrary.com
 direct: +1 770-709-5581
 cell:   +1 404-984-4366
 skype:  gmcharlt
 web:http://www.esilibrary.com/
 Supporting Koha and Evergreen: http://koha-community.org 
 http://evergreen-ils.org
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 'add basket group' bug in Koha 3.14.6

[Jonathan Druart]

It works here on 3.14.6 and master.
Do you have some warnings/errors in the Koha logs?

2014-05-20 12:56 GMT+02:00 schnydszch eugen...@yahoo.com:
 Hello Koha community! We were trying out the Acquisitions module of Koha ILS,
 the version as you can see in subject post is 3.14.6, and is installed in
 Debian 6.x. Whenever I close a basket wherein we're notified to create a
 basket group for it with the same name as the Basket name, there is no
 basket group created. I'm also trying to create a new Basket Group but to no
 avail. Can anybody confirm this too? Are we missing something? I was able to
 do this in Koha 3.14.5. Thanks in advance!



 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 'add basket group' bug in Koha 3.14.6

[Jonathan Druart]

I don't know, it's depend on how you installed Koha.

2014-05-21 16:31 GMT+02:00 eugene jose espinoza eugen...@yahoo.com:


  Hi! Where do I see the koha error log? Thanks!

 On Wednesday, May 21, 2014 6:37 AM, Jonathan Druart
 jonathan.dru...@biblibre.com wrote:


 It works here on 3.14.6 and master.
 Do you have some warnings/errors in the Koha logs?

 2014-05-20 12:56 GMT+02:00 schnydszch eugen...@yahoo.com:
 Hello Koha community! We were trying out the Acquisitions module of Koha
 ILS,
 the version as you can see in subject post is 3.14.6, and is installed in
 Debian 6.x. Whenever I close a basket wherein we're notified to create a
 basket group for it with the same name as the Basket name, there is no
 basket group created. I'm also trying to create a new Basket Group but to
 no
 avail. Can anybody confirm this too? Are we missing something? I was able
 to
 do this in Koha 3.14.5. Thanks in advance!



 --
 View this message in context:
 http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 'add basket group' bug in Koha 3.14.6

[Jonathan Druart]

 [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 
 2014] basketgroup.pl: DBD::mysql::st execute failed: Unknown column 
 'billingplace' in 'field list' at /usr/share/koha/lib/C4/Acquisition.pm line 
 875., referer: 
 http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/basketgroup.pl?op=addbooksellerid=8

This error is raised by mysql. It means that the
aqbasketgroup.billingplace field does not exist in your DB.
This field has been introduced in 3.01.00.097.
In the mysql CLI, you can execute the following query to show the
structure of the aqbasketgroups table:
  show create table aqbasketgroups;

If the field exists, try to restart mysql.


2014-05-21 17:19 GMT+02:00 schnydszch eugen...@yahoo.com:
 Okay, got the error log. it's in /var/log/koha. We're using the debian 
 package. It seems this is the culprit:
 [Wed May 21 08:35:02 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:02 
 2014] basket.pl: Use of uninitialized value in subroutine entry at 
 /usr/share/koha/intranet/cgi-bin/acqui/basket.pl line 322., referer: 
 http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/booksellers.pl
 [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 
 2014] basketgroup.pl: DBD::mysql::st execute failed: Unknown column 
 'billingplace' in 'field list' at /usr/share/koha/lib/C4/Acquisition.pm line 
 875., referer: 
 http://hreplib.infosolutionphilippines.com:8080/cgi-bin/koha/acqui/basketgroup.pl?op=addbooksellerid=8
 [Wed May 21 08:35:34 2014] [error] [client 58.71.18.113] [Wed May 21 08:35:34 
 2014] basketgroup.pl: DBD::mysql::st execute failed: Cannot add or update a 
 child row: a foreign key constraint fails (`koha_hreplib`.`aqbasket`, 
 CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES 
 `aqbasketgroups` (`id`) ON UPDATE CASCADE) at 
 /usr/share/koha/lib/C4/Acquisition.pm line 881., referer:
 But don't know what to do next


 On Wednesday, May 21, 2014 8:10 AM, Jonathan Druart [via Koha] 
 ml-node+s1045719n5798836...@n5.nabble.com wrote:



 It works here on 3.14.6 and master.
 Do you have some warnings/errors in the Koha logs?

 2014-05-20 12:56 GMT+02:00 schnydszch [hidden email]:

 Hello Koha community! We were trying out the Acquisitions module of Koha ILS,
 the version as you can see in subject post is 3.14.6, and is installed in
 Debian 6.x. Whenever I close a basket wherein we're notified to create a
 basket group for it with the same name as the Basket name, there is no
 basket group created. I'm also trying to create a new Basket Group but to no
 avail. Can anybody confirm this too? Are we missing something? I was able to
 do this in Koha 3.14.5. Thanks in advance!



 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 [hidden email]
 http://lists.katipo.co.nz/mailman/listinfo/koha___
 Koha mailing list  http://koha-community.org
 [hidden email]
 http://lists.katipo.co.nz/mailman/listinfo/koha


 

 If you reply to this email, your message will be added to the discussion 
 below:http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519p5798836.html
 To unsubscribe from 'add basket group' bug in Koha 3.14.6, click here.
 NAML



 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519p5798843.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 'add basket group' bug in Koha 3.14.6

[Jonathan Druart]

The column existed in 3.14.5 but not in 3.14.6?

2014-05-22 10:55 GMT+02:00 schnydszch eugen...@yahoo.com:
 It seems I'm missing some columns, where do I get an sql file for this?
 thanks and cheers!



 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519p5798906.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Overdue notices sent to a random patron (3.16)

[Jonathan Druart]

Hello Yuval,

Bug found, see the patch on bug 12315.
The script is advanced_notices.pl, not overdue_notices.pl

It is highly recommended not to use this script without the patch attached
to the bug report.

Regards,
Jonathan



2014-05-26 15:36 GMT+02:00 Yuval Hager yha...@yhager.com:

 Hi,

 I just upgraded to Koha 3.16 using the Debian repo on Thursday. Everything
 went
 fine and was working well.

 On Friday, I found out that a patron received 51 emails of advanced due
 notices
 of other patrons. I confirmed this with the server mail logs, but I have no
 idea why this happened.

 I verified that this patron's email address only shows up under their
 record on
 the borrowers table.

 Checking the email logs, it seems that it sends a bunch of emails to a
 single
 patron, then another bunch to another (I don't know what the content is),
 so
 I'm suspecting something strange is going on.

 I tried running the overdue_notices.pl script with -n -v, and it just
 spit out
 a list of messages to be sent, but not the email address it would send it
 to.

 Any ideas where to begin searching to investigate this?

 Thanks,

 --yuval
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Overdue notices sent to a random patron (3.16)

[Jonathan Druart]

The easiest way is to wait for 3.16.1 where the fix should be integrated.


2014-05-27 15:46 GMT+02:00 Evan Mungai Njoroge evan.njor...@gmail.com:

 Jonathan;
 A novice query on the same,
 How do I apply a patch to my installation (Ubuntu 12.04 using packages)?


   EVAN
 NJOROGE *•*+254721375981 *•*+254721375981  *•*about.me/uhusiano *•*
 * Facilitating access to African digital content *




 On Tue, May 27, 2014 at 11:19 AM, Jonathan Druart 
 jonathan.dru...@biblibre.com wrote:

 Hello Yuval,

 Bug found, see the patch on bug 12315.
 The script is advanced_notices.pl, not overdue_notices.pl

 It is highly recommended not to use this script without the patch attached
 to the bug report.

 Regards,
 Jonathan



 2014-05-26 15:36 GMT+02:00 Yuval Hager yha...@yhager.com:

  Hi,
 
  I just upgraded to Koha 3.16 using the Debian repo on Thursday.
 Everything
  went
  fine and was working well.
 
  On Friday, I found out that a patron received 51 emails of advanced due
  notices
  of other patrons. I confirmed this with the server mail logs, but I
 have no
  idea why this happened.
 
  I verified that this patron's email address only shows up under their
  record on
  the borrowers table.
 
  Checking the email logs, it seems that it sends a bunch of emails to a
  single
  patron, then another bunch to another (I don't know what the content
 is),
  so
  I'm suspecting something strange is going on.
 
  I tried running the overdue_notices.pl script with -n -v, and it just
  spit out
  a list of messages to be sent, but not the email address it would send
 it
  to.
 
  Any ideas where to begin searching to investigate this?
 
  Thanks,
 
  --yuval
  ___
  Koha mailing list  http://koha-community.org
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha
 
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha



___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Overdue notices not creating the right content for the email.

[Jonathan Druart]

Hellon
Which version of Koha are you using?
A bug has been found (bug 12315) in the 3.16.0 version in the advance
notices cronjob. Are you sure your bug is in the overdue notices
cronjob ?

2014-05-30 12:03 GMT+02:00 Syed Salman Ali Kazmi syedsal...@apu.edu.my:
 Dear All,

 As we are using the overdue notice trigger cronjob to send overdue notices 
 via email. The notices created by cron script contains the wrong contents.

 It creates and repeats one content for many number of patrons, then randomly 
 creates another and repeats.

 Require urgent help.

 Regards,
 Syed Salman Ali Kazmi
 System Engineer
 Centre of Technology and Inovation (CTI)
 Lot G4, Incubator 1,
 Technology Park Malaysia,
 Bukit Jalil, 57000 Kuala Lumpur, Malaysia
 Tel: +603-89946077
 Fax: +603 8994 6207



 DISCLAIMER: The information and any attachments contained in this e-mail 
 communication may be privileged and confidential information originally 
 intended only for the use of the individual or entity named above. To the 
 full extent permitted by law, the APIIT Education Group of Companies does not 
 accept liability for any loss or damage caused either by your failure to 
 check your Email, transmission errors, or your reliance on or use of any 
 information contained in this email. If you are not the intended recipient, 
 or the employee or agent responsible to deliver it to the intended recipient, 
 you are hereby notified that any dissemination, distribution or copying of 
 the communication in any manner is strictly prohibited. If you have received 
 this e-mail communication in error, please immediately notify us by telephone 
 (603-8992 5050) or e-mail to s...@apu.edu.mymailto:s...@apu.edu.my and 
 return the original to us at the above address and then immediately delete 
 the communication
  . Thank
  you.


 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Appeal for developing/updating solr deployment documentation to BibLibre

[Jonathan Druart]

Solr is not completely integrated into Koha.
You have to choose Zebra for production use.

2014-06-04 7:51 GMT+02:00 Nur Ahammad ahammadnu...@gmail.com:
 When I run ./rebuild_solr.pl -i It produces SolrAPI =
 http://localhost:8983/solr/koha
 How many indexed documents = 0;

 Please help to solve this problem.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] koha with solar serch engine

[Jonathan Druart]

Koha does not work with Solr.

2014-07-05 8:16 GMT+02:00 vinod kumar vinod.kumar@gmail.com:
 Hi all
  anyone know how to koha run with solar search engine.
 plz guide me
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Marc Modification Templates

[Jonathan Druart]

Hi Nicole,

I am not sure if that works in 3.16, but you can try the following rule:
Copyfield 856$u with 856$u using the regexp s/^/PROXY_URL/

I am sure this works with the improvements I developed on bugs 11319
and 11413 (not in master yet).

Regards,
Jonathan

2014-07-09 4:27 GMT+02:00 Nicole Engard neng...@gmail.com:
 Hi all,

 I'm looking for a way to add a proxy URL to the front of an existing 856$u
 using the MARC modification templates. I'm sure it's Regex, I'm just not so
 good at Regex so if you can provide and example I'd appreciate it and I'll
 even include it in the manual for all.

 Nicole
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Shifting existing orders from 'current' budget to 'next' budget

[Jonathan Druart]

Hello Joann,

This is not currently possible but I have developed a feature for that
(see bug 12164), which should be available in the next major version.

Regards,
Jonathan

2014-07-11 0:18 GMT+02:00 Joann Ransom joa...@tetakere.org.nz:
 Hi everyone,

 We are just about to flip our acquisitions budget over to the next financial 
 year and I cannot remember how to shift existing orders from the 'current' 
 budget to the 'next' budget so that they will show in the 'ordered' column of 
 the acquisitions summary screen when I close of 2013/2014 and make 2014/2015 
 live.

 Can anyone help?

 J

 #
 This e-mail message and any attached files may contain confidential 
 information, and
 may be subject to legal professional privilege. If you are not the intended 
 recipient,
 please delete. Unless formally stated, this e-mail and any attachments do not
 necessarily reflect the views of the the The Horowhenua Trust.

 The Horowhenua Trust takes extensive precautions with the aim of detecting 
 and removing any
 virus or defects from its e-mail system but accepts no liability for loss or 
 damage
 should this e-mail not be virus or defect free or should there be any errors 
 in
 transmission.

 #
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Shifting existing orders from 'current' budget to 'next' budget

[Jonathan Druart]

Hello Joann,

This is not currently possible but I developt a feature for that (see
bug 12164).
It should be available in the next major version.

Regards,
Jonathan

2014-07-11 0:18 GMT+02:00 Joann Ransom joa...@tetakere.org.nz:
 Hi everyone,

 We are just about to flip our acquisitions budget over to the next financial 
 year and I cannot remember how to shift existing orders from the 'current' 
 budget to the 'next' budget so that they will show in the 'ordered' column of 
 the acquisitions summary screen when I close of 2013/2014 and make 2014/2015 
 live.

 Can anyone help?

 J

 #
 This e-mail message and any attached files may contain confidential 
 information, and
 may be subject to legal professional privilege. If you are not the intended 
 recipient,
 please delete. Unless formally stated, this e-mail and any attachments do not
 necessarily reflect the views of the the The Horowhenua Trust.

 The Horowhenua Trust takes extensive precautions with the aim of detecting 
 and removing any
 virus or defects from its e-mail system but accepts no liability for loss or 
 damage
 should this e-mail not be virus or defect free or should there be any errors 
 in
 transmission.

 #
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Change of Workflow in the existing system of KOHA for Placing New Orders in Acquisition

[Jonathan Druart]

Hi Arun,

Is the code online? It's hard to tell you what is wrong without read the code.
Did you create the basket using the C4::Acquisition::NewBasket subroutine?

Next time, please prefer the koha-devel mailing list for technical questions.

Regards,
Jonathan

2014-07-17 13:03 GMT+02:00 Arun Kumar arun.aimit.2...@gmail.com:
 Hello,

 We are working on various development pointers in Acquisition module to
 customize it according to our workflow

 Placing orders in KOHA 3.12 is vague to our organisation its consuming
 procedure for placing orders which can be acheived with minimal workflow

 i have crafted the workflow to meet our requirements, which includes
 ordering form SUGGESTION MANAGEMENT itself with an hyperlink from Accepted
 tab and passing suggestionid and biblionumber directly to
 neworderempty.pl further
 modifying this file with a new form with vendor and basket details and
 creating a basket with basketno and bookseller id and other credentials
 passed on to addorder.pl

 my question is that how do we create a new basket at neworderempty.pl and
 passing its details to place an order in addorder.pl, i have studied the
 code for creation of basket in basketheader.pl, and followed the same i
 don't understand where i went wrong

 My Sincere Appreciation towards any pointers, thanks in advance

 Regards

 Arunkumar
 Project Assistant
 National Institute of Oceanography
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Change of Workflow in the existing system of KOHA for Placing New Orders in Acquisition

[Jonathan Druart]

Actually you sent on both lists...


2014-07-17 14:47 GMT+02:00 Jonathan Druart jonathan.dru...@biblibre.com:
 Hi Arun,

 Is the code online? It's hard to tell you what is wrong without read the code.
 Did you create the basket using the C4::Acquisition::NewBasket subroutine?

 Next time, please prefer the koha-devel mailing list for technical questions.

 Regards,
 Jonathan

 2014-07-17 13:03 GMT+02:00 Arun Kumar arun.aimit.2...@gmail.com:
 Hello,

 We are working on various development pointers in Acquisition module to
 customize it according to our workflow

 Placing orders in KOHA 3.12 is vague to our organisation its consuming
 procedure for placing orders which can be acheived with minimal workflow

 i have crafted the workflow to meet our requirements, which includes
 ordering form SUGGESTION MANAGEMENT itself with an hyperlink from Accepted
 tab and passing suggestionid and biblionumber directly to
 neworderempty.pl further
 modifying this file with a new form with vendor and basket details and
 creating a basket with basketno and bookseller id and other credentials
 passed on to addorder.pl

 my question is that how do we create a new basket at neworderempty.pl and
 passing its details to place an order in addorder.pl, i have studied the
 code for creation of basket in basketheader.pl, and followed the same i
 don't understand where i went wrong

 My Sincere Appreciation towards any pointers, thanks in advance

 Regards

 Arunkumar
 Project Assistant
 National Institute of Oceanography
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] French specifics for Koha

[Jonathan Druart]

Hello Clint,

You can find a z3950 french server list on
http://irspy.indexdata.com/find.html?_query=fr_search=Search

Regards,
Jonathan

2014-07-16 22:34 GMT+02:00 clint.deckard clint.deck...@frontiers.co.nz:
 I have offered to do an introductory training session for Koha in Vanuatu at
 the end of this month and I would appreciate any hints and tips specific to
 using Koha in a french speaking country.

 I have added french language support without issue but have no experience
 with importing records in french. Also, is there a publicly available Z39.50
 server that would be useful.

 I appreciate your help very much.

 Clint.




 --
 Clint Deckard

 Anact Open Source Solutions
 RD1, Takapau, New Zealand


 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Question about how Notices work in 3.16

[Jonathan Druart]

Hi Nicole,

A wiki page exists: http://wiki.koha-community.org/wiki/Message_transport_types
The expected behavior should be what is described on this page.

Cheers,
Jonathan

2014-08-15 1:36 GMT+02:00 Nicole Engard neng...@gmail.com:
 Hi all,

 I got a good question about notices in 3.16 that I don't know the answer
 to. As always the answer will go in the manual once I have it :)

 

 In the Overdue notice/status triggers tool, if we just put a check mark
 in just the Email column, will an overdue notice be printed for people
 with out email? If we put a check in both the Email and Print columns,
 does Koha send the patron both an email and a printed notice?

 

 I think there is a bug right now where the print isn't generated at all  -
 but I'd like the theoretical answer so that we have it documented when the
 bug is fixed :)

 Nicole
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error Time Zone

[Jonathan Druart]

Hello,
It seems to be the same error as bug 12669 [1]
Regards,
Jonathan

[1]  http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12669

2014-08-19 1:24 GMT+02:00 Carlos Rodrigo Cordova Sandoval
carlos.cordo...@gmail.com:
 hello

 I have installed koha 3.16.02 64bits on debian 7.x with in vmware, I have
 the problem when trying to recover from a usurious staff (circulation) to
 see their loans shows me the following error

 Template process failed: undef Error - Invalid Local time for date in time
 zone: America / Santiago

 enable in apache SetEnv KOHA_BACKTRACES 1 and this was the result

 http://pastebin.com/LE05jTwV

 Error image
 http://snag.gy/Edbfd.jpg

 Log intranet-error.log
 [Mon Aug 18 19:09:51 2014] [error] [client 200.104.159.240] [Mon Aug 18
 19:09:51 2014] circulation.pl: Template process failed: undef error -
 Invalid local time for date in time zone: America/Santiago, referer:
 http://intra-udd.opengeek.cl/cgi-bin/koha/mainpage.pl

 any suggestions

 Carlos
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sandboxes

[Jonathan Druart]

Hello Nicole,
There is a bug (at least one) on sandboxes, sometime the mail is not
sent. I don't know why.
But I think an email is sent if something wrong append.
I hope you managed to test what you wanted.

Regards,
Jonathan

2014-08-09 18:52 GMT+02:00 Nicole Engard neng...@gmail.com:
 Sorry for my delay in responding.  6 and 7 weren't sending emails when
 ready either.  So I figured it might just be the fact that we were all
 hitting the server at the same time and wanted you to know that we'd be
 doing it again.

 Nicole


 On Fri, Aug 8, 2014 at 9:55 AM, Heather Braum (NEKLS) hbr...@nekls.org
 wrote:

 Fridolin, I know I couldn't get the Biblibre Sandbox 2 upgraded to master
 yesterday. The staff side login was stuck at the web installer screen, even
 though I received a sandbox ready email message. In the middle of the email
 message, there was this text:

 Upgrade to 3.15.00.048 done (Bug 10195: Records hidden with OpacSuppression
 can still be accessed)
 DBD::mysql::db do failed: BLOB/TEXT column 'issn' used in key specification
 without a key length at /home/koha/src/installer/data/mysql/
 updatedatabase.pl line 8420.
 DBD::mysql::db do failed: Incorrect prefix key; the used key part isn't a
 string, the used length is longer than the key part, or the storage engine
 doesn't support unique prefix keys at /home/koha/src/installer/data/mysql/
 updatedatabase.pl line 8424.
 Upgrade to 3.15.00.049 done (Bug 11268 - Biblioitems URL field is too small
 for some URLs)

 It looks like part of the upgrade failed.

 That's the one Biblibre Sandbox I was trying to use. (And yes I was setting
 it up with UNIMARC)

 Hope that helps!

 -Heather

 On Friday, August 8, 2014, Fridolin SOMERS fridolin.som...@biblibre.com
 javascript:_e(%7B%7D,'cvml','fridolin.som...@biblibre.com'); wrote:

  Hie,
 
  Tell me which sandox as which problem please.
 
  Regards,
 
  Le 08/08/2014 00:06, Nicole Engard a écrit :
 
  Hi all,
 
  Tomorrow the Koha North American Users Group will be testing a lot of
  patches (we hope). Today when we gave lessons on how to use them we hit
 a
  few snags. Many people never got an email and a few sandboxes kept
 showing
  the installer even though that wasn't chosen.
 
  Would folks at BibLibre please give the sandboxes a look over before
  tomorrow so we don't cause major breakage :)
 
  Thanks a bunch!
  Nicole
  ___
  Koha mailing list  http://koha-community.org
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha
 
 
  --
  Fridolin SOMERS
  Biblibre - Pôles support et système
  fridolin.som...@biblibre.com
  ___
  Koha mailing list  http://koha-community.org
  Koha@lists.katipo.co.nz
  http://lists.katipo.co.nz/mailman/listinfo/koha
 


 --
 Heather Braum
 NExpress Coordinator
 Resource Sharing Librarian
 Northeast Kansas Library System
 Sent from Gmail Mobile
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] In-house use vs on-site vs reading room

[Jonathan Druart]

Hello Koha community,

I developed a new feature [1] to track items in used in a library.
It's like a normal checkout but the patron is not allowed to go out with it
and has to return the item at the end of the day.

I am looking for the best term to use on the interface (and in the code itself).
If you are an English speaker, could you share with me how you call that?

At the moment, I have 3 terms: In house use, on-site and reading room.
I have to choose one!

Regards,
Jonathan

[1] http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10860
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Change search engine in koha 3.16

[Jonathan Druart]

Koha does not work with something else than Zebra.
The Solr implementation has been removed from the Koha code.

2014-11-04 11:40 GMT+01:00 bui phong phongt...@yahoo.com:
 Dear team,

 I'm trying to change search engine from zebra to solr for koha 3.16. I 
 followed instruction from this:

 http://wiki.koha-community.org/wiki/Solr_deployment

 but the solrconfig.xml doesn't work. I faced this error:

 org.apache.solr.common.SolrException:org.apache.solr.common.SolrException: 
 Could not load conf for core koha: Error loading solr config from
 /solr/solrconf/multicore/koha/conf/solrconfig.xml


 I also tried to install solr separately, add new core to solr by using the 
 solrconfig.xml above but this problem still happened.


 I'm using koha 3.16.02 and solr version 4.10.2.

 Could you guide me how to change search engine and could you share the 
 solrconfig.xml file for solr4.10.2.

 I really appreciate your help


 Thanks,
 Phong
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.16.4 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7756

[Jonathan Druart]

Hello Hugo,

The error is raised by C4::Letter::SendAlerts.
The From address is not the one defined in the supplier data, it is
the email of the logged in user (you need to delog+relog to take the
change into account).

Jonathan

2014-11-10 11:02 GMT+01:00 Hugo Agud ha...@orex.es:
 Hello

 We are testing Koha 3.16 and we are having problems to send mail claim late
 issue.

 when we try to claim, we push to button, the serial changes into 'cliamed,
 but no mail sent, in order to make sure that somethings is wrong, we have
 checked logs from apache


 claims.pl: Bad or missing From address: '', referer:
 http://formacion-intra.orex.es/cgi-bin/koha/serials/claims.pl
 [Sat Nov 08 19:41:23 2014] [error] [client 83.55.68.172] [Sat Nov  8
 19:41:23 2014] claims.pl:  at /usr/share/koha/intranet/cgi-bin/serials/
 claims.pl line 83, referer: http://formacion-intra.orex.es/cgi


 We have checked that was a bug for 3.8 and compared the patch with the
 current files and are identical, then it should work.

 We have check that provider has contact mail, we have added also
 booksellermail directly to mysql just in case, but the issue is still there

 Before adding this potential bug to bugzilla, we would ask if anybody have
 seen this issue also on 3.16.4?

 Note: installed via packagess

 Kindest Regards
 --

 *Hugo Agud - Orex Digital *

 *www.orex.es http://www.orex.es*


 Director

 Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70
 ha...@orex.es · http://www.orex.es/



 No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
 implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



 Aviso de confidencialidad
 Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
 RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
 está autorizado a recibirlo por el remitente), no está autorizado a copiar,
 reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
 por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Email notices

[Jonathan Druart]

Hello Paul,

If I am not wrong, the DUEDGST (and DUE) is used when you set advanced
notices to 0 day, otherwise it's PREDUEDGST (and PREDUE).

To loop on items, you should use the item tag.

The default messaging preferences will only affect new patrons. But you can
use misc/maintenance/borrowers-force-messaging-defaults to update existing
ones.

Could you please open a new bug [1] and detail how you recreate the
duplicated notification?

Regards,
Jonathan

[1] http://bugs.koha-community.org/bugzilla3/enter_bug.cgi?product=Koha


2014-11-12 6:50 GMT+01:00 CTS-Programmer 3 (Paul Dokken) 
cts-pr...@sil.org.pg:

 We are running Koha version 3.16.03 and it was installed from:
 http://debian.koha-community.org/koha/.  Linux library 3.2.0.  Apache
 version 2.2.22.  Here is what I have for my HTML template (with the HTML
 message box checked)

 Dear borrowers.firstname borrowers.surname,br
 br
 br
 The following item(s) are now due:brbr
 ul
 
 libiblio.title  biblio.seriestitle  by biblio.author
 items.barcode Date Due: issues.date_due/li
 
 /ul

 br
 br
 iThank you for visiting branches.branchname./i

 I was told that I need to use --- but also told that I need to use
 item/item.  I am wondering if displaying a list of items will even work
 since the default template is:
 You have count items due

 Also, when I change the default messaging preferences for a patron
 category will Koha change all the students in this category?

 Thanks, Paul



 Paul Dokken
 Software Developer
 SIL PNG Communication and Technology Services
 Ukarumpa EHP 444 | Papua New Guinea
 cts-pr...@sil.org.pg
 +675-537-3544 x4404 {Telecom}
 +675-7081-8666 {Digicel}


 -Original Message-
 From: Arslan Farooq [mailto:arslan...@gmail.com]
 Sent: Tuesday, 11 November 2014 6:08 PM
 To: koha@lists.katipo.co.nz
 Subject: Re: [Koha] Email notices

 Hi,

 Can you share your Koha, Linux version, and install method?

 Arslan

 On Tue, Nov 11, 2014 at 12:01 PM, CTS-Programmer 3 (Paul Dokken) 
 cts-pr...@sil.org.pg wrote:

  I am trying to get email notification working correctly.  I have
  check-in and checkout notices working fine.  I even get a list of
  items when a patron checks in/out multiple items.  The problems I have
  are I get duplicate messages for overdue items.  The date and time is
  the same for both emails going out.  The other problem is that when
  the DUEDGST notice goes out it does not show details of the items that
  are due.  I am looking at the patron category where this is happening
  and I have the Advance notice set to 2 days and have Digests only
  checked.  The only other options I have set are checkout check-in.
 


 --
 Electronic Resource Librarian
 SZABIST Islamabad
 www.szabist-isb.edu.pk
 arslan.far...@szabist-isb.edu.pk
 +92 514 863 363-65

 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Check in error

[Jonathan Druart]

Hello,

I just had a quick look at the code.
What is the value of the CircControl pref?
Check the value of the branchcode for the item and the patron.

Jonathan

2014-12-05 14:58 GMT+01:00 lspitaels spita...@vki.ac.be:
 Hi everyone,

 Since I did the update to the version 3.16.04.000 of Koha, I have with some
 books an error when I do a check in. I searched for a few days but I did not
 find what is the problem.

 Here is the error message:

 Software error:
 No branchcode argument passed to Koha::Calendar-new at
 /usr/share/koha/lib/C4/Overdues.pm line 306

 Your sincerely,

 Laurent



 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/Check-in-error-tp5821232.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Export results in txt

[Jonathan Druart]

Robin,
BibTeX is already available when downloading a notice or a cart.
Bug 13345 makes it possible on sending records by email.

2015-01-22 12:40 GMT+01:00 Robin Sheat ro...@catalyst.net.nz:

 Op 22/01/15 om 22:44 schreef Hugo Agud:
  Bbitext is more closed to what I wish to see in Koha.

 Do you mean BibTeX? If so, that'd be grand.

 --
 Robin Sheat
 Catalyst IT Ltd.
 ✆ +64 4 803 2204
 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Overdue Notice Lists All Checked out Books Without -t

[Jonathan Druart]

I confirm the issue on 3.18.x and master.

2015-02-05 15:28 GMT+01:00 Kyle Noakes knoa...@egrps.org:
 Hello,

 I apologize if this should go straight to bugzilla, but I am unsure how to 
 proceed with this.

 I am running Koha 3.18.03 on SLES 11 SP3.  My Perl version is 5.10.

 I seem to be running into a similar problem as bug 13468, 
 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13468, where the 
 overdue notice will list all checked out books rather than just overdue ones. 
  The bug fix determined that it was happening when the overdue_notice.pl 
 would run in triggered mode with -t, but I do not run the overdue_notice.pl 
 in triggered mode.  I manually run the command when our schools ask me to 
 rather than running a cronjob, so I do not use triggered.  I did confirm that 
 the patched code was showing up in overdue_notice.pl, but it did not make a 
 difference when not doing triggered notices.

 Is there possibly something else that I am missing.

 Again I apologize if I should be going straight to Bugzilla with this.  If I 
 should be, just let me know whether it would be a new bug or adding to the 
 old.  I have been running Koha for 5 years or so, but have not had to add any 
 bugs yet so I am new to the process.

 Thank you,




 Kyle Noakes

 Manager of Information Systems
 East Grand Rapids Public Schools
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Overdue Notice Lists All Checked out Books Without -t

[Jonathan Druart]

I quickly let a note on bug 12529
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12529#c15

2015-02-06 10:14 GMT+01:00 Jonathan Druart jonathan.dru...@biblibre.com:
 I confirm the issue on 3.18.x and master.

 2015-02-05 15:28 GMT+01:00 Kyle Noakes knoa...@egrps.org:
 Hello,

 I apologize if this should go straight to bugzilla, but I am unsure how to 
 proceed with this.

 I am running Koha 3.18.03 on SLES 11 SP3.  My Perl version is 5.10.

 I seem to be running into a similar problem as bug 13468, 
 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13468, where the 
 overdue notice will list all checked out books rather than just overdue 
 ones.  The bug fix determined that it was happening when the 
 overdue_notice.pl would run in triggered mode with -t, but I do not run the 
 overdue_notice.pl in triggered mode.  I manually run the command when our 
 schools ask me to rather than running a cronjob, so I do not use triggered.  
 I did confirm that the patched code was showing up in overdue_notice.pl, but 
 it did not make a difference when not doing triggered notices.

 Is there possibly something else that I am missing.

 Again I apologize if I should be going straight to Bugzilla with this.  If I 
 should be, just let me know whether it would be a new bug or adding to the 
 old.  I have been running Koha for 5 years or so, but have not had to add 
 any bugs yet so I am new to the process.

 Thank you,




 Kyle Noakes

 Manager of Information Systems
 East Grand Rapids Public Schools
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Export results in txt

[Jonathan Druart]

Hello Hugo,

Is csv not a good format for unexperienced users?

Bug 13345 will permit opac users to choose the format of the file sent by
email.

Regards,
Jonathan

2015-01-22 10:21 GMT+01:00 Hugo Agud ha...@orex.es:

 Dear all

 For a long time we think that Koha missed the option to download records in
 ISBD or label marc to a txt file locally, for unexperienced users.

 More experienced users may use Zotero with firefox that works fineit is
 also possible to send the basket by mail, but still you need to send,
 receive, copy  paste and just some fields are published, , but I think it
 is not enough for our less experienced users,

 the question is, is there any development on this way? *If  not we can
 discuss to sponso*r this development if nothing is on the pipe line right
 now

 THIS IS A SAMPLE EXPORT FROM MILLENIUM, it saves the result in txt locally

 Registre 1 de 50
 LOCALITZ Biblioteca de Catalunya
 AUTORStevens, Christine, 1964-
 TÍTOLLa Música como medicina : la curación a través del sonido /
Christine Stevens ; [traducción : Alicia Sánchez Millet]
 INFO PUBLArgentina ; España [etc.] : Urano, 2014.
 DESCRIPCIO   284 p. ; 23 cm.
 SERIES   Quiero leer.
 SERIES   Quiero leer.
 NOTA Tít. orig.: Music medicine : the science and spirit of healing
yourself with sound.
 NOTA Referències bibliogràfiques.
 MATERIA  Musicoteràpia lemac.
 MATERIA  Música -- Aspectes psicològics lemac.
 BIB UTIL #   .b58632839.
 ESTANDARD9788479532369.
 CLASIFICAC   615-085:78.
 CLASIFICAC   781.1.

 Registre 2 de 50
 LOCALITZ Biblioteca Episcopal del Seminari de Barcelona / URL
 TÍTOLMúsica litúrgica.
 INFO PUBLMéxico D.F. : Obra Nacional de la Buena Prensa, 2014.
 DESCRIPCIO   152 p. ; 21 cm.
 SERIES   Manantial litúrgico ; 22.
 MATERIA  Església Catòlica -- Litúrgia lemac.
 MATERIA  Música sacra lemac.
 AUTOR SECObra Nacional de la Buena Prensa (Mèxic)
 BIB UTIL #   .b58700596.
 ESTANDARD9789700059723.

 --

 *Hugo Agud - Orex Digital *

 *www.orex.es http://www.orex.es*


 Director

 Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70
 ha...@orex.es · http://www.orex.es/



 No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
 implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



 Aviso de confidencialidad
 Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
 RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
 está autorizado a recibirlo por el remitente), no está autorizado a copiar,
 reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
 por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
 sistema.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Sandboxes enhancement

[Jonathan Druart]

Hello,

I have just updated the BibLibre' sandboxes [1] to permit to apply
patches from several bug reports.
This is useful when you want to test a bug which depends on another
one not yet pushed to master.

Regards,
Jonathan

[1] http://wiki.koha-community.org/wiki/Sandboxes
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Modify patron list

[Jonathan Druart]

Hello Paul,

No it's not possible to choose the column you want to use to sort this table.
And  not possible neither to hide some.
Note that it could be quite easy to develop (for people having
knowledge in the Koha codebase).

Regards,
Jonathan

2015-01-27 4:15 GMT+01:00 CTS-Programmer 3 (Paul Dokken) cts-pr...@sil.org.pg:
 When we pull up the patron list and click on a letter the list that comes up 
 is no longer sorted by name.  Is there a way we can change the default sort 
 order and also which columns get displayed?

 Thanks, Paul
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] debarred users

[Jonathan Druart]

Hello Hugo,

Have a look at the pref AutoRemoveOverduesRestrictions introduced by bug 2720.

Regards,
Jonathan

2015-01-28 17:45 GMT+01:00 Hugo Agud ha...@orex.es:
 Dear all

 I wish to ask a question regardind overdue resitrctions

 Koha allows to unrestric an user when it has been restricted by overdue
 notice, but it forgives the fine

 The questions is , may somebody confirm If there is not an automatic
 desrestriction when the user finish the restriction period and all overdued
 issues has been checked in, right?


 Thanks you in advance!
 --

 *Hugo Agud - Orex Digital *

 *www.orex.es http://www.orex.es*


 Director

 Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70
 ha...@orex.es · http://www.orex.es/



 No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
 implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



 Aviso de confidencialidad
 Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
 RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
 está autorizado a recibirlo por el remitente), no está autorizado a copiar,
 reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
 por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Can't add items on Koha 3.18.03 built from .tar

[Jonathan Druart]

Hello Bob,

Have a look at bug 13523, same issue as yours.

Regards,
Jonathan

2015-02-14 16:49 GMT+01:00 Bob Ewart bob-ew...@bobsown.com:
 When I try to add an item on Koha 3.18.03 built from the .tar file, I get a
 Can't call fields on undefined value at ... additem.pl line 683.

 It works on Debian based systems installed as a package.

 See bug 13711 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13711

 I can't use Debian because it fails the vulnerability checks and the Ubuntu
 based systems kept locking up hard.

 I really would like to know the difference between the Debian/Ubuntu
 packages and building it from a .tar file.

 --
 Bob Ewart
 Stonewall National Museum  Archives
 http://stonewall.dnsalias.org



 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Possible 3.18.2 Bug

[Jonathan Druart]

Hello Alex,
It seems to be introduce by bug 11331.
It only appears with perl version = 5.10.

The following change should fix your issue:

diff --git a/tools/viewlog.pl b/tools/viewlog.pl
index 9f68a8a..18eb0df 100755
--- a/tools/viewlog.pl
+++ b/tools/viewlog.pl
@@ -211,7 +211,7 @@ if ($do_it) {

 # First line with heading
 # Exporting bd id seems useless
-my @headings = grep { $_ ne 'action_id' } sort keys $data[0];
+my @headings = grep { $_ ne 'action_id' } sort keys %{ $data[0] };
 if ( $csv-combine(@headings) ) {
 $content .= $csv-string() . \n;
 }


Could you please confirm?

2014-12-29 19:54 GMT+01:00 Alex87 aleted...@gmail.com:
 Hi,

 I have just upgrade from 16.1 to 18.2, but when in go to:

 ToolsLog viewer

 I get this error:
 ...
 Type of arg 1 to keys must be hash (not array element) at
 /usr/share/koha/intranet/cgi-bin/tools/viewlog.pl line 214, near ];
 Execution of /usr/share/koha/intranet/cgi-bin/tools/viewlog.pl aborted due
 to compilation errors.
 ...

 Does anyone already experienced this?

 Thanks
 Alex



 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/Possible-3-18-2-Bug-tp5823593.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Adding orders from staged files

[Jonathan Druart]

Hello Cecil,

Have a look at the system preference MarcFieldsToOrder.

Regards,
Jonathan

2014-12-23 16:44 GMT+01:00 Hillyard, Cecil chilly...@washoecounty.us:
 Hello,

 We are looking into getting  MARC vendor records and then using that file to 
 add the orders to Koha.  The vendor can provide branch breakouts and 
 quantities for each branch.  So we've been trying to use the add orders from 
 a staged file.  What happens is that we can get 1 item record for each in the 
 total quantity but no branch breakouts.  In what MARC field does that 
 particular ordering information go into?  We have put the branch information 
 in the 952 field but that did nothing.
 The total quantity is in 969$h

 _
 Cecil Hillyard
 Technical Services-- Cataloger
 Washoe County Library
 Reno, NV  89501
 https://library.washoecounty.ushttps://library.washoecounty.us/


 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] jQuery: Change default active tab in borrower account page

[Jonathan Druart]

href.replace(pay, boraccount);
won't modify href
Try with
href = href.replace(pay, boraccount);
This should work :)

2015-03-20 12:52 GMT+01:00 Kyle Hall kyle.m.h...@gmail.com:
 This should work in theory, but my href.replace line isn't working:

 $( document ).ready(function() {
 var a = $(#menu a[href*='/cgi-bin/koha/members/pay.pl']);
 var href = a.attr('href');
 href.replace(pay, boraccount);
 a.attr('href', href );
 });

 Perhaps someone else can catch my error?

 If you get it to work, please add it to the jquery library!

 Kyle

 http://www.kylehall.info
 ByWater Solutions ( http://bywatersolutions.com )
 Meadville Public Library ( http://www.meadvillelibrary.org )
 Crawford County Federated Library System ( http://www.ccfls.org )
 Mill Run Technology Solutions ( http://millruntech.com )

 On Thu, Mar 19, 2015 at 7:17 PM, Chad Roseburg croseb...@ncrl.org wrote:

 Currently, the patron fines link in the staff interface links to:
 Eg.,
 http://koha.testing.com/cgi-bin/koha/members/pay.pl?borrowernumber=611739

 We're wondering if it's possible, through the magic of jQuery, to have it
 link to:

 http://koha.ncrl.org/cgi-bin/koha/members/boraccount.pl?borrowernumber=611739

 I looked through the jQuery library and did not find anything that could be
 coaxed to do this -- the only tricky part would be grabbing the borrower
 number. I could figure out the rest.

 Thanks!

 --
 Chad Roseburg
 Automation Dept.
 North Central Regional Library
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL report: Digests in message preferences

[Jonathan Druart]

Hello Chad,

It's stored in the borrower_message_preferences.wants_digest column.
So the following query should return what you want:
 select distinct borrowernumber from borrower_message_preferences where 
 wants_digest=1;

Regards,
Jonathan

2015-04-01 1:11 GMT+02:00 Chad Roseburg croseb...@ncrl.org:
 Does anyone have a report showing barcodes of patrons who do not have the
 Digests only? option enabled.

 I see the transport types but am not sure how the digest option is stored.

 Thank you!

 --
 Chad Roseburg
 Automation Dept.
 North Central Regional Library
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha emailing not working

[Jonathan Druart]

2015-04-21 9:35 GMT+02:00 reachsuriya reachsur...@gmail.com:
 I have koha 4.18 version and trying to find a fix for Mailing through Koha

Are you sure the version is 4.18?
This version of Koha does not exist (yet).

 I want the patron to email his cart to any Mail id he prefers. So i am tring
 to test this feature and while doing that, it gives me an error as There is
 an error sending the cart after clicking Send.
 When i checked the Opac-error.log file, this is the error i get.

 opac-sendbasket.pl: Error sending mail:  Bad recipient mail id of user:
 550 5.7.1 Unable to relay, referer:
 opac-sendbasket.pl: No valid recipient
 opac-sendbasket.pl:  at /usr/share/koha/opac/cgi-bin/opac/opac-sendbasket.pl
 line 188

 I configured Post fix with gmail as smtp to send and receive mails. It works
 fine if i echo a test mail and it reaches the recipient id.





 --
 View this message in context: 
 http://koha.1045719.n5.nabble.com/Koha-emailing-not-working-tp5836791.html
 Sent from the Koha-general mailing list archive at Nabble.com.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Acquisitions Documentation Question

[Jonathan Druart]

Hi Nicole,

I will *try* to explain :)

1/ Base-level allocated is the Amount value you defined when creating the fund
2/ Base-level ordered is the ordered amount for this fund (without child funds)
3/ Total ordered is the base-level ordered for this fund and all its child funds
4/ Base-level spent is the spent amount for this fund (without child funds)
5/ Total spent is the base-level spent for this fund and all its child funds
6/ Base-level available is 1 - 2
7/ Total available is 1 - 3

If it's not clear enough I can develop :)

Cheers,
Jonathan

2015-04-29 20:14 GMT+02:00 Nicole Engard neng...@gmail.com:
 I have been asked to define the columns on this page:

 cgi-bin/koha/admin/aqbudgets.pl?budget_period_id=34

 I'm not sure what the base level columns are supposed to be. Can
 someone break down for me what each column is so I can update the
 manual?

 Thanks
 Nicole
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Search in intranet with non-ASCII-characters

[Jonathan Druart]

Hello Beda,

I confirm that it's a bug, on master and 3.20.
Certainly caused by bug 11944.
Did you open a bug report?

Regards,
Jonathan

2015-06-20 19:41 GMT+01:00 Beda Szukics b...@kollegium-sarnen.ch:
 Hi all

 Since I upgraded to 3.20 I have a very strange search problem.

 In the intranet interface searches with a non-ASCII-character show no
 results.

 In the opac interface the results are there.

 For example:

 Schärer results in an error:

 No results match your search for 'kw,wrdl: Sch�rer' in ...

 Scherer shows some results (in my case 236 items).

 In /var/log/koha/kb/intranet-error.log I see:

 [Sat Jun 20 20:34:43.521663 2015] [cgi:error] [pid 20806] [client
 192.168.1.52:57404] AH01215: [Sat Jun 20 20:34:43 2015] search.pl:
 CGI::param called in list context from package main line 421, this can
 lead to vulnerabilities. See the warning in Fetching the value or
 values of a single named parameter at /usr/share/perl5/CGI.pm line
 436., referer:
 http://bibliotheksverwaltung.kollegi/cgi-bin/koha/catalogue/search.pl?q=Sch%C3%A4rer

 However there is also an entry for Scherer:

 [Sat Jun 20 20:37:13.234366 2015] [cgi:error] [pid 20899] [client
 192.168.1.52:59580] AH01215: [Sat Jun 20 20:37:13 2015] search.pl:
 CGI::param called in list context from package main line 421, this can
 lead to vulnerabilities. See the warning in Fetching the value or
 values of a single named parameter at /usr/share/perl5/CGI.pm line
 436., referer:
 http://bibliotheksverwaltung.kollegi/cgi-bin/koha/catalogue/search.pl?q=Scherer

 What's wrong? Any suggestions?

 Beda
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Search in intranet with non-ASCII-characters

[Jonathan Druart]

See bug 14431 for a patch (coming soon).

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14431

2015-06-22 11:22 GMT+01:00 Jonathan Druart jonathan.dru...@biblibre.com:
 Hello Beda,

 I confirm that it's a bug, on master and 3.20.
 Certainly caused by bug 11944.
 Did you open a bug report?

 Regards,
 Jonathan

 2015-06-20 19:41 GMT+01:00 Beda Szukics b...@kollegium-sarnen.ch:
 Hi all

 Since I upgraded to 3.20 I have a very strange search problem.

 In the intranet interface searches with a non-ASCII-character show no
 results.

 In the opac interface the results are there.

 For example:

 Schärer results in an error:

 No results match your search for 'kw,wrdl: Sch�rer' in ...

 Scherer shows some results (in my case 236 items).

 In /var/log/koha/kb/intranet-error.log I see:

 [Sat Jun 20 20:34:43.521663 2015] [cgi:error] [pid 20806] [client
 192.168.1.52:57404] AH01215: [Sat Jun 20 20:34:43 2015] search.pl:
 CGI::param called in list context from package main line 421, this can
 lead to vulnerabilities. See the warning in Fetching the value or
 values of a single named parameter at /usr/share/perl5/CGI.pm line
 436., referer:
 http://bibliotheksverwaltung.kollegi/cgi-bin/koha/catalogue/search.pl?q=Sch%C3%A4rer

 However there is also an entry for Scherer:

 [Sat Jun 20 20:37:13.234366 2015] [cgi:error] [pid 20899] [client
 192.168.1.52:59580] AH01215: [Sat Jun 20 20:37:13 2015] search.pl:
 CGI::param called in list context from package main line 421, this can
 lead to vulnerabilities. See the warning in Fetching the value or
 values of a single named parameter at /usr/share/perl5/CGI.pm line
 436., referer:
 http://bibliotheksverwaltung.kollegi/cgi-bin/koha/catalogue/search.pl?q=Scherer

 What's wrong? Any suggestions?

 Beda
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request for registering as a Koha Support Company

[Jonathan Druart]

Are the js files available somewhere? I would like to have look at this
simplified UI :-)
On 25 Jun 2015 11:34, Purab Gujar pu...@cameoml.com wrote:

 Hi Indranil,

 Thank you for pointing out the message in our document and I do agree the
 message needs correction. That said, an intended FUD it was not! :) I will
 pursue the correction immediately.

 Also, please note that we have not forked out Koha. C-Koha is basically a
 cloud hosted service of Koha. We also have added  javascript changes that
 simplify the UI as what we feel will make Koha more accessible for
 Libraries in our region. The possibility of adding js files is provided in
 Koha and from our experience with the community so far, I believe use of js
 files is not discouraged.

 Thanks for taking a look!

 Best,
 Purab



 On Thu, Jun 25, 2015 at 3:24 PM, Indranil Das Gupta indr...@gmail.com
 wrote:

  Hi Purab,
 
  I've a question for you - you wish your company to be listed. Quite all
  right!
 
  But why are you spreading FUD [1] about Koha in your promotional
  material - BUT, for the most part Koha has been considered to be too
  complex for use by Indian libraries – both for the students and for
  the library ­staff. C­KOHA is about to change this. C-KOHA is
  extremely simplified version of Koha. -
  http://ckoha.in/documents/CKoha_Intro.pdf
 
  In your previous emails you have claimed the changes are minimal and
  yet your own promo material says otherwise. Please understand that
  forks of Koha are fine. But once forked they do no remain Koha.
 
  [1] https://en.wikipedia.org/wiki/Fear,_uncertainty_and_doubt
 
  waiting for your reply
 
  -indranil
 
 
 
  Developed by the engineers at Cameo Media Labs, our effort has been to
  make KOHA as easy to use as Google.com For a gmail and google.com
  user, C­KOHA feels familiar and easy to learn. Typically 1 to 2 hours
  are sufficient
  for a Google.com user. Cameo has mainly used the simple­ menus and
  clean ­screen design philosophy.
 
  On Wed, Jun 24, 2015 at 8:43 AM, Purab Gujar pu...@cameoml.com wrote:
   Hi Chris,
  
   Is there any step I can take to take the process for listing our
 Company
   name further?
  
   Best,
   Purab
  
   On Wed, Jun 10, 2015 at 11:00 AM, Purab Gujar pu...@cameoml.com
 wrote:
  
   Hi Chris,
  
   Thanks for checking!
  
   The source-code for C-Koha is the same as the Koha source-code. We
 have
   not been required to make any source-code changes so far.  Although,
 we
   have added a javascript, to keep the UI simpler for local users here.
 We
   have also taken the effort to get sms to work in India- again, with no
   changes to Koha's source-code.
  
   Best,
   Purab
  
   On Wed, Jun 10, 2015 at 10:48 AM, Chris Cormack 
 chr...@catalyst.net.nz
  
   wrote:
  
   Hi
  
   Do you have the source code available for your ckoha offering?
  
   Chris
  
   --
   Chris Cormack
   Catalyst
   04 8032238
  
   - Reply message -
   From: Purab Gujar pu...@cameoml.com
   To: koha@lists.katipo.co.nz
   Subject: [Koha] Request for registering as a Koha Support Company
   Date: Wed, Jun 10, 2015 5:04 PM
  
   Company Name - Cameo Media Labs
  
   Contact Person - Koustubh Kulkarni
  
   Contact Email- koust...@cameoml.com
  
   Contact Telephone - +91 99757 42180
  
   Website - http://cameoml.com http://ckoha.in
  
   Address - 76/3 Swojas Gulmohar, Film Institute Road, Pune 411004
  
   Short Description of your Services- We have established and actively
   maintain a cloud-based Koha offering - C-Koha http://ckoha.in One of
  the
   major users for the last few years is the Gov. of India's  National
  Film
   Archives of India. We are well known amongst the local Librarian
  community
   and actively contribute in our geography in the form of
  trainings/workshops
   of Koha, and drive Koha adoption locally through numerous hands on
  demos
   for new users.
  
   Best Regards,
   Purab Gujar,
   Founder- Cameo Media Labs
   --
  
   --
   
   Purab Gujar
   Cameo Media Labswww.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
   ___
   Koha mailing list  http://koha-community.orgKoha
  @lists.katipo.co.nzhttps://lists.katipo.co.nz/mailman/listinfo/koha
  
  
  
  
   --
  
   --
   
   Purab Gujar
   Cameo Media Labs
   www.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
  
  
  
  
   --
  
   --
   
   Purab Gujar
   Cameo Media Labs
   www.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
   ___
   Koha mailing list  http://koha-community.org
   Koha@lists.katipo.co.nz
   https://lists.katipo.co.nz/mailman/listinfo/koha
 
 
 
  --
  Indranil Das Gupta
 
 

Re: [Koha] Sorting of LISTS

[Jonathan Druart]

Hello Steve,

Are you talking about
/cgi-bin/koha/virtualshelves/shelves.pl?viewshelf=42sort=titledirection=asc
If yes, it's a bug.
The pagination on this page is done using mysql (order by title).
We could use the DataTables plugin to sort the table and remove the stopwords.

You can open a new bug report :)

Regards,
Jonathan

2015-06-22 13:37 GMT+01:00 Steven Nickerson snick...@maine.rr.com:
 I think this is a bug but I wanted to know if anyone could think of a way
 around it.   In a List, book titles starting with the articles A, An and
 The appear to be sorted improperly and appear in order WITH the article
 included instead of skipping the article and sorting by the second word in
 the title.Can anyone think of an easy way to get Koha to skip the
 articles in titles in Lists?   Titles seem to sort as expected in search
 results and other places.



 I see this issue in the package version of 3.18.06, 3.18.03, and 3.16.02.



 Thanks!

 Steve

 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Vendor Module Error

[Jonathan Druart]

Joseph,
Yes, this version is buggy, see
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14440 for a fix.
Regards,
Jonathan
On 26 Jun 2015 13:20, Joseph Chacha chacha...@gmail.com wrote:

 Dear Members,

 I am trying to implement Koha 3.18.08.000 and I have made a succeful
 installation on Ubuntu 14.04 LTS

 Everything looks good so far apart from an error generated when I am
 attempting to add a vendor Software error: bad template path at
 /usr/share/koha/lib/C4/Auth.pm line 161.

 Any advise on how to address this will be highly appreciated.

 J Chacha.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Request for registering as a Koha Support Company

[jonathan druart]

Are the js files available somewhere? I would like to have look at this
simplified UI :-)
On 25 Jun 2015 11:34, Purab Gujar pu...@cameoml.com wrote:

 Hi Indranil,

 Thank you for pointing out the message in our document and I do agree the
 message needs correction. That said, an intended FUD it was not! :) I will
 pursue the correction immediately.

 Also, please note that we have not forked out Koha. C-Koha is basically a
 cloud hosted service of Koha. We also have added  javascript changes that
 simplify the UI as what we feel will make Koha more accessible for
 Libraries in our region. The possibility of adding js files is provided in
 Koha and from our experience with the community so far, I believe use of js
 files is not discouraged.

 Thanks for taking a look!

 Best,
 Purab



 On Thu, Jun 25, 2015 at 3:24 PM, Indranil Das Gupta indr...@gmail.com
 wrote:

  Hi Purab,
 
  I've a question for you - you wish your company to be listed. Quite all
  right!
 
  But why are you spreading FUD [1] about Koha in your promotional
  material - BUT, for the most part Koha has been considered to be too
  complex for use by Indian libraries – both for the students and for
  the library ­staff. C­KOHA is about to change this. C-KOHA is
  extremely simplified version of Koha. -
  http://ckoha.in/documents/CKoha_Intro.pdf
 
  In your previous emails you have claimed the changes are minimal and
  yet your own promo material says otherwise. Please understand that
  forks of Koha are fine. But once forked they do no remain Koha.
 
  [1] https://en.wikipedia.org/wiki/Fear,_uncertainty_and_doubt
 
  waiting for your reply
 
  -indranil
 
 
 
  Developed by the engineers at Cameo Media Labs, our effort has been to
  make KOHA as easy to use as Google.com For a gmail and google.com
  user, C­KOHA feels familiar and easy to learn. Typically 1 to 2 hours
  are sufficient
  for a Google.com user. Cameo has mainly used the simple­ menus and
  clean ­screen design philosophy.
 
  On Wed, Jun 24, 2015 at 8:43 AM, Purab Gujar pu...@cameoml.com wrote:
   Hi Chris,
  
   Is there any step I can take to take the process for listing our
 Company
   name further?
  
   Best,
   Purab
  
   On Wed, Jun 10, 2015 at 11:00 AM, Purab Gujar pu...@cameoml.com
 wrote:
  
   Hi Chris,
  
   Thanks for checking!
  
   The source-code for C-Koha is the same as the Koha source-code. We
 have
   not been required to make any source-code changes so far.  Although,
 we
   have added a javascript, to keep the UI simpler for local users here.
 We
   have also taken the effort to get sms to work in India- again, with no
   changes to Koha's source-code.
  
   Best,
   Purab
  
   On Wed, Jun 10, 2015 at 10:48 AM, Chris Cormack 
 chr...@catalyst.net.nz
  
   wrote:
  
   Hi
  
   Do you have the source code available for your ckoha offering?
  
   Chris
  
   --
   Chris Cormack
   Catalyst
   04 8032238
  
   - Reply message -
   From: Purab Gujar pu...@cameoml.com
   To: koha@lists.katipo.co.nz
   Subject: [Koha] Request for registering as a Koha Support Company
   Date: Wed, Jun 10, 2015 5:04 PM
  
   Company Name - Cameo Media Labs
  
   Contact Person - Koustubh Kulkarni
  
   Contact Email- koust...@cameoml.com
  
   Contact Telephone - +91 99757 42180
  
   Website - http://cameoml.com http://ckoha.in
  
   Address - 76/3 Swojas Gulmohar, Film Institute Road, Pune 411004
  
   Short Description of your Services- We have established and actively
   maintain a cloud-based Koha offering - C-Koha http://ckoha.in One of
  the
   major users for the last few years is the Gov. of India's  National
  Film
   Archives of India. We are well known amongst the local Librarian
  community
   and actively contribute in our geography in the form of
  trainings/workshops
   of Koha, and drive Koha adoption locally through numerous hands on
  demos
   for new users.
  
   Best Regards,
   Purab Gujar,
   Founder- Cameo Media Labs
   --
  
   --
   
   Purab Gujar
   Cameo Media Labswww.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
   ___
   Koha mailing list  http://koha-community.orgKoha
  @lists.katipo.co.nzhttps://lists.katipo.co.nz/mailman/listinfo/koha
  
  
  
  
   --
  
   --
   
   Purab Gujar
   Cameo Media Labs
   www.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
  
  
  
  
   --
  
   --
   
   Purab Gujar
   Cameo Media Labs
   www.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
   ___
   Koha mailing list  http://koha-community.org
   Koha@lists.katipo.co.nz
   https://lists.katipo.co.nz/mailman/listinfo/koha
 
 
 
  --
  Indranil Das Gupta
 
 

Re: [Koha] Request for registering as a Koha Support Company

[jonathan druart]

Do the js files available somewhere? I would like to have look at this
simplified UI :-)
On 25 Jun 2015 11:34, Purab Gujar pu...@cameoml.com wrote:

 Hi Indranil,

 Thank you for pointing out the message in our document and I do agree the
 message needs correction. That said, an intended FUD it was not! :) I will
 pursue the correction immediately.

 Also, please note that we have not forked out Koha. C-Koha is basically a
 cloud hosted service of Koha. We also have added  javascript changes that
 simplify the UI as what we feel will make Koha more accessible for
 Libraries in our region. The possibility of adding js files is provided in
 Koha and from our experience with the community so far, I believe use of js
 files is not discouraged.

 Thanks for taking a look!

 Best,
 Purab



 On Thu, Jun 25, 2015 at 3:24 PM, Indranil Das Gupta indr...@gmail.com
 wrote:

  Hi Purab,
 
  I've a question for you - you wish your company to be listed. Quite all
  right!
 
  But why are you spreading FUD [1] about Koha in your promotional
  material - BUT, for the most part Koha has been considered to be too
  complex for use by Indian libraries – both for the students and for
  the library ­staff. C­KOHA is about to change this. C-KOHA is
  extremely simplified version of Koha. -
  http://ckoha.in/documents/CKoha_Intro.pdf
 
  In your previous emails you have claimed the changes are minimal and
  yet your own promo material says otherwise. Please understand that
  forks of Koha are fine. But once forked they do no remain Koha.
 
  [1] https://en.wikipedia.org/wiki/Fear,_uncertainty_and_doubt
 
  waiting for your reply
 
  -indranil
 
 
 
  Developed by the engineers at Cameo Media Labs, our effort has been to
  make KOHA as easy to use as Google.com For a gmail and google.com
  user, C­KOHA feels familiar and easy to learn. Typically 1 to 2 hours
  are sufficient
  for a Google.com user. Cameo has mainly used the simple­ menus and
  clean ­screen design philosophy.
 
  On Wed, Jun 24, 2015 at 8:43 AM, Purab Gujar pu...@cameoml.com wrote:
   Hi Chris,
  
   Is there any step I can take to take the process for listing our
 Company
   name further?
  
   Best,
   Purab
  
   On Wed, Jun 10, 2015 at 11:00 AM, Purab Gujar pu...@cameoml.com
 wrote:
  
   Hi Chris,
  
   Thanks for checking!
  
   The source-code for C-Koha is the same as the Koha source-code. We
 have
   not been required to make any source-code changes so far.  Although,
 we
   have added a javascript, to keep the UI simpler for local users here.
 We
   have also taken the effort to get sms to work in India- again, with no
   changes to Koha's source-code.
  
   Best,
   Purab
  
   On Wed, Jun 10, 2015 at 10:48 AM, Chris Cormack 
 chr...@catalyst.net.nz
  
   wrote:
  
   Hi
  
   Do you have the source code available for your ckoha offering?
  
   Chris
  
   --
   Chris Cormack
   Catalyst
   04 8032238
  
   - Reply message -
   From: Purab Gujar pu...@cameoml.com
   To: koha@lists.katipo.co.nz
   Subject: [Koha] Request for registering as a Koha Support Company
   Date: Wed, Jun 10, 2015 5:04 PM
  
   Company Name - Cameo Media Labs
  
   Contact Person - Koustubh Kulkarni
  
   Contact Email- koust...@cameoml.com
  
   Contact Telephone - +91 99757 42180
  
   Website - http://cameoml.com http://ckoha.in
  
   Address - 76/3 Swojas Gulmohar, Film Institute Road, Pune 411004
  
   Short Description of your Services- We have established and actively
   maintain a cloud-based Koha offering - C-Koha http://ckoha.in One of
  the
   major users for the last few years is the Gov. of India's  National
  Film
   Archives of India. We are well known amongst the local Librarian
  community
   and actively contribute in our geography in the form of
  trainings/workshops
   of Koha, and drive Koha adoption locally through numerous hands on
  demos
   for new users.
  
   Best Regards,
   Purab Gujar,
   Founder- Cameo Media Labs
   --
  
   --
   
   Purab Gujar
   Cameo Media Labswww.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
   ___
   Koha mailing list  http://koha-community.orgKoha
  @lists.katipo.co.nzhttps://lists.katipo.co.nz/mailman/listinfo/koha
  
  
  
  
   --
  
   --
   
   Purab Gujar
   Cameo Media Labs
   www.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
  
  
  
  
   --
  
   --
   
   Purab Gujar
   Cameo Media Labs
   www.cameoml.com
   India Mobile : +91 98609 44424
   India Office Phone: +91 20 3061 9960
   U.S. VOIP Phone  : +1 408 601 0925
   ___
   Koha mailing list  http://koha-community.org
   Koha@lists.katipo.co.nz
   https://lists.katipo.co.nz/mailman/listinfo/koha
 
 
 
  --
  Indranil Das Gupta
 
  

Re: [Koha] Vendor Module Error

[jonathan druart]

Joseph,
Yes, this version is buggy, see
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14440 for a fix.
Regards,
Jonathan
On 26 Jun 2015 13:20, Joseph Chacha chacha...@gmail.com wrote:

 Dear Members,

 I am trying to implement Koha 3.18.08.000 and I have made a succeful
 installation on Ubuntu 14.04 LTS

 Everything looks good so far apart from an error generated when I am
 attempting to add a vendor Software error: bad template path at
 /usr/share/koha/lib/C4/Auth.pm line 161.

 Any advise on how to address this will be highly appreciated.

 J Chacha.
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Software error at the time of checkin

[Jonathan Druart]

Yes, but should have been fixed by 3.07.00.002:
  UPDATE borrowers SET debarred=NULL WHERE debarred='-00-00';


2015-07-15 9:13 GMT+01:00 Chris Cormack chr...@catalyst.net.nz:
 * Sahadeo Taware (sahadeo.taw...@gmail.com) wrote:
 Dear friends

 I got software error at the time of checkin

 Can't call method truncate on an undefined value at
 /usr/share/koha/lib/C4/Circulation.pm line 1966
 For help, please send mail to the webmaster ([no address given]),
 giving this error message
 and the time and date of the error.

 KINDLY HELP ME TO SOLVE THE ERROR

 Did your capslock key get stuck? I'd get a new keyboard for that, or
 people might think you are yelling at them.

 For the Koha error, can you check in your database, the debarred
 column in the borrowers table. If you have any rows that have
 -00-00 as the date, please set them to NULL

 Thank should fix that error

 Chris

 --
 Chris Cormack
 Catalyst IT Ltd.
 +64 4 803 2238
 PO Box 11-053, Manners St, Wellington 6142, New Zealand

 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table

[Jonathan Druart]

See all bug 13526 and the discussion on bug 5366
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5366

2015-10-29 8:16 GMT+00:00 Jonathan Druart
<jonathan.dru...@bugs.koha-community.org>:
> Hello Pedro,
>
> You should not use MySQL 5.6, some bugs are known: bug 13669 and bug
> 14637, and certainly some others.
> Until now nobody has shown a special interest for these issues.
>
> Regards,
> Jonathan
>
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637
>
> 2015-10-28 16:17 GMT+00:00 Pedro Amorim <pjamori...@gmail.com>:
>> Also, some other thing to note:
>>
>> The mysql I'm running is 5.6.25.
>>
>> 2015-10-28 15:14 GMT-01:00 Pedro Amorim <pjamori...@gmail.com>:
>>
>>> Hello,
>>>
>>> Version: Koha 3.2002000
>>>
>>> My name is Pedro Amorim and I've been implementing Koha for the first time
>>> for the past couple of days now.
>>>
>>> This is a fresh package install.
>>>
>>> This is a bug (I think) I stumbled upon and this is how I solved it:
>>> When performing a Z39.50 search I kept getting no records found despite
>>> the fact that I knew there were records (doing a yaz-client search and
>>> using the online demo returned results, so why didn't it return in my
>>> installation?).
>>>
>>> So I found out that the records should've been inserted in the
>>> import_records table but they weren't. Because marcxml_old wasn't being
>>> defined and it expected some value (NULL = NO), so I went in and changed
>>> the database structure to NULL = YES and everything is now working as
>>> expected.
>>>
>>> I think this also has something to do with mysql STRICT_TRANS_TABLES but I
>>> would like some confirmation on that.
>>>
>>> I'm new in the whole Koha scene and don't yet know how to submit bugs.
>>> I'm sending this mail in the hopes that someone confirms that this is
>>> indeed a bug and document the given solution.
>>>
>>> Cheers
>>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table

[Jonathan Druart]

Hello Pedro,

You should not use MySQL 5.6, some bugs are known: bug 13669 and bug
14637, and certainly some others.
Until now nobody has shown a special interest for these issues.

Regards,
Jonathan

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637

2015-10-28 16:17 GMT+00:00 Pedro Amorim :
> Also, some other thing to note:
>
> The mysql I'm running is 5.6.25.
>
> 2015-10-28 15:14 GMT-01:00 Pedro Amorim :
>
>> Hello,
>>
>> Version: Koha 3.2002000
>>
>> My name is Pedro Amorim and I've been implementing Koha for the first time
>> for the past couple of days now.
>>
>> This is a fresh package install.
>>
>> This is a bug (I think) I stumbled upon and this is how I solved it:
>> When performing a Z39.50 search I kept getting no records found despite
>> the fact that I knew there were records (doing a yaz-client search and
>> using the online demo returned results, so why didn't it return in my
>> installation?).
>>
>> So I found out that the records should've been inserted in the
>> import_records table but they weren't. Because marcxml_old wasn't being
>> defined and it expected some value (NULL = NO), so I went in and changed
>> the database structure to NULL = YES and everything is now working as
>> expected.
>>
>> I think this also has something to do with mysql STRICT_TRANS_TABLES but I
>> would like some confirmation on that.
>>
>> I'm new in the whole Koha scene and don't yet know how to submit bugs.
>> I'm sending this mail in the hopes that someone confirms that this is
>> indeed a bug and document the given solution.
>>
>> Cheers
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fwd: Koha Offline Circulation Tool - Development

[Jonathan Druart]

Hi Balaji,

Your help is welcomed :)
The code is in the koct
directory:http://git.koha-community.org/gitweb/?p=contrib/global.git;a=tree;f=koct;h=92a2e069e5c752dff4ccd28b3551cd67aa8afe23;hb=HEAD

This tool is mainly developed/supported by BibLibre's guys, you can
contact Claire (aka clrh) or Fridolin on the irc channel.

See you there!

Jonathan

2015-10-28 4:29 GMT+00:00 Balaji Ravichandran :
> -- Forwarded message --
> From: Balaji Ravichandran 
> Date: 28 October 2015 at 02:12
> Subject: Koha Offline Circulation Tool - Development
> To: dev-add...@mozilla.org
>
>
> Hi all,
>
> I am interested in doing the development process for the Koha Offline
> Circulation Tool - addon for firefox. I have noticed that this addon is not
> working well in the latest versions of firefox and I am very much in the
> need to fix it for the use by community.
>
> Can somebody guide me on how to start with it? I have searched for the
> repository for the addon but couldn't help after that.Where to go after
> that? How to make changes and notify the developer with it?
>
> Reference Links :-
> http://wiki.koha-community.org/wiki/Offline_circulation_firefox_plugin
> https://addons.mozilla.org/en-US/firefox/addon/koct/
> http://git.koha-community.org/gitweb/?p=contrib/global.git;a=summary
>
> Thank You!!!
>
>
> --
> Regards,
> Balaji Ravichandran ( பாலாஜி ) ,
> Volunteer at Free Software Foundation - Tamilnadu,
> Mobile : 9790528505
> My Blog - balogic.wordpress.com
>
>
>
> --
> Regards,
> Balaji Ravichandran ( பாலாஜி ) ,
> Volunteer at Free Software Foundation - Tamilnadu,
> Mobile : 9790528505
> My Blog - balogic.wordpress.com
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] batch record modification question

[Jonathan Druart]

Hello Hugo,

No, it cannot work at the moment, but it could work very easily.
I can provide a patch if you open a bug report.

Regards,
Jonathan

2015-11-12 12:49 GMT+00:00 Hugo Agud :
> Good Morning
>
> We're testing 'Batch record modification' using the samples in the manual,
> but It is not working on fields 952 (items fields)
>
> I mean in fact all the info from items are stored in items table, and
> biblio info is stored in biblioitems, The  tool works fine with biblio
> records, but we didn't expeted that it also works with items, becuase the
> info is located in other table, but we wished to check the manual samples
>
> We have tried to copy the 090 field from biblio to items without success as
> we expected, the question is .. it should work also with items? is our
> install failing or is the doc a little wrong?
>
> thanks you in advance
> Hugo
>
> --
>
> *Hugo Agud - Orex Digital *
>
> *www.orex.es *
>
>
> Director
>
> Passatge de la Llançadera, 3 · 08338 Premià de Dalt - Tel: 93 539 40 70
> ha...@orex.es · http://www.orex.es/
>
>
>
> No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
> implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
>
>
>
> Aviso de confidencialidad
> Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
> RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
> está autorizado a recibirlo por el remitente), no está autorizado a copiar,
> reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
> por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table

[Jonathan Druart]

Pedro,

Please answer to the list.
Yes it's the easy and lazy solution.
If you want to use MySQL 5.6, you must disable STRICT_TRANS_TABLES,
otherwise you will encounter some errors.
But we should take care of these errors and fix them.

Regards,
Jonathan

2015-10-29 16:51 GMT+00:00 Pedro Amorim <pjamori...@gmail.com>:
> Hello Jonathan,
>
> Thank you for your reply.
>
> I have removed STRICT_TRANS_TABLES in both usr/my.cnf and etc/mysql/my.cnf
> and solved the following detected bugs:
> 1) Z39.50 import_records table insertion;
> 2) Z30.50 server creation with empty values on timeout and order;
> 3) Creating new category for patron -> Category already exists.
>
> And ( I imagine ) countless others.
>
> Let me know what you think about this, please.
>
> Thank you,
>
> Pedro Amorim
>
>
>
> 2015-10-29 7:20 GMT-01:00 Jonathan Druart
> <jonathan.dru...@bugs.koha-community.org>:
>>
>> See all bug 13526 and the discussion on bug 5366
>> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523
>> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5366
>>
>> 2015-10-29 8:16 GMT+00:00 Jonathan Druart
>> <jonathan.dru...@bugs.koha-community.org>:
>> > Hello Pedro,
>> >
>> > You should not use MySQL 5.6, some bugs are known: bug 13669 and bug
>> > 14637, and certainly some others.
>> > Until now nobody has shown a special interest for these issues.
>> >
>> > Regards,
>> > Jonathan
>> >
>> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13669
>> > http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14637
>> >
>> > 2015-10-28 16:17 GMT+00:00 Pedro Amorim <pjamori...@gmail.com>:
>> >> Also, some other thing to note:
>> >>
>> >> The mysql I'm running is 5.6.25.
>> >>
>> >> 2015-10-28 15:14 GMT-01:00 Pedro Amorim <pjamori...@gmail.com>:
>> >>
>> >>> Hello,
>> >>>
>> >>> Version: Koha 3.2002000
>> >>>
>> >>> My name is Pedro Amorim and I've been implementing Koha for the first
>> >>> time
>> >>> for the past couple of days now.
>> >>>
>> >>> This is a fresh package install.
>> >>>
>> >>> This is a bug (I think) I stumbled upon and this is how I solved it:
>> >>> When performing a Z39.50 search I kept getting no records found
>> >>> despite
>> >>> the fact that I knew there were records (doing a yaz-client search and
>> >>> using the online demo returned results, so why didn't it return in my
>> >>> installation?).
>> >>>
>> >>> So I found out that the records should've been inserted in the
>> >>> import_records table but they weren't. Because marcxml_old wasn't
>> >>> being
>> >>> defined and it expected some value (NULL = NO), so I went in and
>> >>> changed
>> >>> the database structure to NULL = YES and everything is now working as
>> >>> expected.
>> >>>
>> >>> I think this also has something to do with mysql STRICT_TRANS_TABLES
>> >>> but I
>> >>> would like some confirmation on that.
>> >>>
>> >>> I'm new in the whole Koha scene and don't yet know how to submit bugs.
>> >>> I'm sending this mail in the hopes that someone confirms that this is
>> >>> indeed a bug and document the given solution.
>> >>>
>> >>> Cheers
>> >>>
>> >> ___
>> >> Koha mailing list  http://koha-community.org
>> >> Koha@lists.katipo.co.nz
>> >> https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difficulty filling out accounting info

[Jonathan Druart]

Hi Ann,

I confirm that it seems to work for me using 3.20.4 so it certainly
comes from your data.
Could you please make a screenshot of the form when you get the NaN
and give us the rate for the currency you use?

Regards,
Jonathan

2015-10-29 22:27 GMT+00:00 library :
> Good morning
>
> Ever since we were upgraded to 3.20.4 I have had difficulty filling out the
> accounting information for each item. I have found a work around for the
> books as I can can fill them out using the Uncertain Prices page then edit
> each item later, but I cannot do this for the subscriptions.
>
> Basically as soon as I enter the vendor price the rest of the price fields
> change to NaN (have no idea what this means) but the Budgeted cost and
> total cost fields are not editable. Then I cannot save because I get the
> error message -Total must be a number.
>
> Could anyone give me a hint as to what is wrong so I can tell our tech
> support where to look.
>
> Gratefully
>
> Ann Murphy
> Katikati College
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Difficulty filling out accounting info

[Jonathan Druart]

Ann,

The problem certainly comes from the $ in the currency code.
If you have access to the database, you could try and change "$NZ"
with "NZ". I am pretty sure it will fix the issue.
It's a bug, you can open a new bug report on bugs.koha-community.org.

Regards,
Jonathan


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

Re: [Koha] DB errors during upgrade from 3.18.09 to 3.20.04

[Jonathan Druart]

Thanks for reporting this, it is a problem in the fresh 3.18.12
release, see http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14820#c8
where I have just reported the issue to Liz.

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

Re: [Koha] Koha Date and Time

[Jonathan Druart]

Hello,

The date and time depend on the local time zone of your system.
For more information, have a look at this doc
http://search.cpan.org/~drolsky/DateTime-TimeZone-1.93/lib/DateTime/TimeZone/Local/Unix.pm

Regards,
Jonathan

2015-10-15 6:49 GMT+01:00 Nasiru Yakubu :
> Hi
>
> Can anyone advise me on how to change the date and time in Koha?
>
> Or does Koha get these values from the Operating System
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Circulation Problem

[Jonathan Druart]

Should have been fixed by bug 13242 and bug 14494

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13242
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14494

2015-10-13 23:42 GMT+01:00 Robin Sheat :
> Sebastian Hierl schreef op di 13-10-2015 om 09:28 [+0200]:
>> I need to get to updating the wiki...  we experienced a similar
>> timeout issue, with the checkout and check-in commands performing with
>> success, because of the expiration date ("enrollment period") of our
>> patrons.  We set some patrons such as staff to expire in  -- it
>> took Koha up to 1 minute to calculate the due date when checking out a
>> book, which led to the time out.  The problem was solved when we set
>> the expiration date to 2032 in the Patron Category Administration (in
>> the Koha admin. interface).
>
> If you can get it to the point where someone could test it, then it's
> worth filing a bug on. It shouldn't happen and is certainly fixable.
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha installation on Ubuntu 14.04.3

[Jonathan Druart]

Where are you stuck? Do you get an error?

Please answer to the list, I don't provide personal support.

2015-10-06 9:04 GMT+01:00 Decka David <dda...@lib.unitech.ac.pg>:
> Hello Jonathan,
>
>
>
> My answer is  Yes, I did which I had read over many times to get this
> project installed and seems to fail. But I wish to get some simple
> instructions on how to really install and setup Koha. Beside I already have
> successfully install Ubuntu 14.04 LTS and tried using terminal commands to
> install Koha but seems failing. Internet and proxy is fine to get debian
> packages.
>
>
>
> Could you assist with you expertise skills?
>
>
>
> Many thanks
>
>
>
> Decka
>
>
>
> -Original Message-
> From: Jonathan Druart [mailto:jonathan.dru...@bugs.koha-community.org]
> Sent: Tuesday, October 06, 2015 5:38 PM
> To: Decka David
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Koha installation on Ubuntu 14.04.3
>
>
>
> Hello,
>
>
>
> Did you follow this doc
> wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages ?
>
>
>
> Regards,
>
> Jonathan
>
>
>
> 2015-10-06 8:08 GMT+01:00 Decka David <dda...@lib.unitech.ac.pg>:
>
>> Dear Koha Developers
>
>>
>
>> I am new to Ubuntu OS as well as Koha ILS . I have read about Koha
>
>> which I am interested to use for my university library however I tried
>
>> installing Koha (old stable) on Ubuntu 14.04 LTS and not many
>
>> information on the wiki Koha. Is there anyone who wish to assist me
>
>> with simple instructions on how to setup Koha on Ubuntu 14.04 LTS behind
>> proxy setup.
>
>>
>
>> Many thanks in advance.
>
>>
>
>> Decka David
>
>> PNG Unitech
>
>> Library Systems
>
>> ___
>
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha glacially slow

[Jonathan Druart]

Hello,

2015-10-08 19:40 GMT+01:00 Mark Tompsett :
> Greetings,
>
> I wrote:
>>
>> "Version 3.22 is still a month or so away from release.
>> Because from a software perspective,
>> I think Koha running Plack is your only hope.
>> And that will be a feature available out of the box, if I am not
>> mistaken."
>
>
> Craig Butosi replied:
>>
>> Really?
>
>
> -- Really.
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13791
> Status: PUSHED TO MASTER.
>
>
> Craig Butosi exclaimed:
>>
>> This is fantastic.
>
>
> -- Indeed!

Which is a bit less fantastic is that our dear RM has asked for people
to test the packages with Plack and did not get any answer
(http://lists.koha-community.org/pipermail/koha-devel/2015-September/041811.html).
So we don't really know if it works or not.
Last time a Koha running Plack has been tested in a stress session, it
was not a real success as far as I know (see
http://lists.koha-community.org/pipermail/koha-devel/2015-April/041375.html).

So without confirmation that someone has been using it (intranet side)
in production for more than 1 week without getting any problems, we
cannot really say it is fantastic.

> GPML,
> Mark Tompsett
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Software error at the time of checkin

[Jonathan Druart]

Please provide the value of borrowers.debarred for this patron.

2015-07-04 8:02 GMT+01:00 Vimal Kumar V. vimal0...@gmail.com:
 Dear Friends,
 I got following error message when checkin a book,
 Software error:
 Can't call method truncate on an undefined value at
 /usr/share/koha/lib/C4/Circulation.pm line 1966.
 For help, please send mail to the webmaster ([no address given]), giving
 this error message and the time and date of the error.

 Version of Koha is 3.20.1
 Ubuntu 14.04.

 Request guidance to solve this problem.
 Regards,

 --
 Vimal Kumar V.
 Technical Assistant
 Mahatma Gandhi University Library
 Kottayam, Kerala- 686 560
 Web: http://www.vimalkumar.info
 Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
 http://moovandan.blogspot.in
 ---
 I forget what I was taught. I only remember what I have learnt
 -Patrick White
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Upgrade problem from 3.8.9 to 3.20.2

[Jonathan Druart]

Hi Vinod,

As it said in the error, you already had a primary key defined on the table.
old_reserves shouldn't have a primary key on old_reserves before 3.09.00.025.

Note that there was a bug in this update database entry, have a look
at bug 10185. But it exists in 3.20.*

Regards,
Jonathan

2015-08-29 14:26 GMT+01:00 vinod mishra :
> Dear All,
>
> When i am trying to restore the database of Koha 3.8.9 to on 3.20.2 it
> gives following error after running* koha-upgrade-schema library* command.
>
>
> Upgrade to 3.09.00.023 done (Add system preference SearchEngine )
> Upgrade to 3.09.00.024 done (Add system preference IntranetSlipPrinterJS))
> DBD::mysql::db do failed: Multiple primary key defined at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 5549.
> DBD::mysql::db do failed: Column count doesn't match value count at row 1
> at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 5550.
> DBD::mysql::db do failed: Incorrect table definition; there can be only one
> auto column and it must be defined as a key at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 5569.
> DBD::mysql::db do failed: Column count doesn't match value count at row 1
> at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 5570.
> Failed to add reserve_id to reserves tables, please refresh the page to try
> again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
> updatedatabase.pl line 5586.
>
> Any solution please? if its a bug than i will file on bugzilla?
>
> --
>
>
>
>
> *With Regards,Vinod Kumar Mishra,Assistant Librarian,Biju Patnaik Central
> Library (BPCL),*
>
> *NIT Rourkela,*
>
> *Sundergadh-769008,*
>
> *Odisha,*
>
> *India.*
>
> *Mob:91+9439420860*
> *Website: http://mishravk.com/ *
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Upgrade problem from 3.8.9 to 3.20.2

[Jonathan Druart]

Could you have a look at the DB backup you did before the update and
confirm there is a primary key on the reserve table?

2015-09-01 11:42 GMT+01:00 vinod mishra <mishrav...@gmail.com>:
> Thanks Dear Jonathan,
>
> So may i know what exactly to do step by step to overcome the situation as i
> am trying nut due to my technical limitations i could not able to do.
>
> Thanking You.
>
> On Tue, Sep 1, 2015 at 2:12 PM, Jonathan Druart
> <jonathan.dru...@bugs.koha-community.org> wrote:
>>
>> Hi Vinod,
>>
>> As it said in the error, you already had a primary key defined on the
>> table.
>> old_reserves shouldn't have a primary key on old_reserves before
>> 3.09.00.025.
>>
>> Note that there was a bug in this update database entry, have a look
>> at bug 10185. But it exists in 3.20.*
>>
>> Regards,
>> Jonathan
>>
>> 2015-08-29 14:26 GMT+01:00 vinod mishra <mishrav...@gmail.com>:
>> > Dear All,
>> >
>> > When i am trying to restore the database of Koha 3.8.9 to on 3.20.2 it
>> > gives following error after running* koha-upgrade-schema library*
>> > command.
>> >
>> >
>> > Upgrade to 3.09.00.023 done (Add system preference SearchEngine )
>> > Upgrade to 3.09.00.024 done (Add system preference
>> > IntranetSlipPrinterJS))
>> > DBD::mysql::db do failed: Multiple primary key defined at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5549.
>> > DBD::mysql::db do failed: Column count doesn't match value count at row
>> > 1
>> > at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5550.
>> > DBD::mysql::db do failed: Incorrect table definition; there can be only
>> > one
>> > auto column and it must be defined as a key at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5569.
>> > DBD::mysql::db do failed: Column count doesn't match value count at row
>> > 1
>> > at
>> > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
>> > line 5570.
>> > Failed to add reserve_id to reserves tables, please refresh the page to
>> > try
>> > again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/
>> > updatedatabase.pl line 5586.
>> >
>> > Any solution please? if its a bug than i will file on bugzilla?
>> >
>> > --
>> >
>> >
>> >
>> >
>> > *With Regards,Vinod Kumar Mishra,Assistant Librarian,Biju Patnaik
>> > Central
>> > Library (BPCL),*
>> >
>> > *NIT Rourkela,*
>> >
>> > *Sundergadh-769008,*
>> >
>> > *Odisha,*
>> >
>> > *India.*
>> >
>> > *Mob:91+9439420860*
>> > *Website: http://mishravk.com/ <http://mishravk.com/>*
>> > ___
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
>
> --
> With Regards,
> Vinod Kumar Mishra,
> Assistant Librarian,
> Biju Patnaik Central Library (BPCL),
> NIT Rourkela,
> Sundergadh-769008,
> Odisha,
> India.
> Mob:91+9439420860
> Website: http://mishravk.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Raspberry Pi

[Jonathan Druart]

Hello Fred,

Have a look at this wiki page:
http://wiki.koha-community.org/wiki/Koha_on_a_Raspberry_Pi

Cheers,
Jonathan

2015-08-25 13:04 GMT+01:00 King, Fred fred.k...@medstar.net:
 I posted this to MEDLIB-L, the medical librarians' listserv, last Friday, and 
 I'm reposting it to the Koha list in hopes that some of you may find it 
 interesting. I thought about taking out some of the medical-library-related 
 material and US references, but that would mean redoing most of the 
 footnotes. Too complicated.

 Does anyone here use a Raspberry Pi as a Koha production server? It seems 
 possible for a small library, but it looks so improbable. However, it's as 
 much RAM and hard drive space as you'd get on one of Digital Ocean's 
 lower-priced options. Is my mostly-pulled-out-of-the-air estimate of $75USD 
 for an entire Koha system (just the hardware and software--technical 
 expertise not included) accurate? Does everybody else already know about this 
 and I'm doing the equivalent of exclaiming over the invention of the wheel? 
 Comments invited.

 Cheers,

 Fred King
 Medical Librarian, MedStar Washington Hospital Center
 fred.k...@medstar.netmailto:fred.k...@medstar.net
 202-877-6221
 ORCID -0001-5266-0279

 Sometimes research is mostly documenting the obvious.
 --Frazz


 +
 Disclaimer: I'm about to mention a few computer-related products, so I should 
 probably say that I have no financial interest in any of them--I just think 
 they're interesting. I do have an interest in seeing more libraries use Koha: 
 the more users, the more people and money available to improve the system. 
 And it should go without saying, though I will anyway, that I'm speaking only 
 for myself, not my employer.

 Upon re-reading this, it does sound rather like an infomercial. Sorry--it 
 didn't start out to be. If the idea offends you, please accept my apologies 
 and hit the delete key.

 Furthermore: we've had about two weeks' share of off-topic banter in the past 
 few days, and I've contributed more than my share. However, I wanted to write 
 about this before it melts out of my aging brain like an ice cream cone on a 
 hot day. Besides, as the rapper Tupat Zobutta said, I'm on a roll this 
 week. (1)

 On with the show:

 Has anyone here heard of/used the Raspberry Pi? I was at the Koha North 
 America Users' Group meeting a couple of weeks ago, and someone passed one 
 around for us to look at. It's a 900MHz quad-core computer with 1GB RAM, 4 
 usb ports, HDMI port, 100 MBS ethernet port, 3.5mm audio/composite video 
 jack, Micro SD slot, and a few other features.

 Cost: $35.00.

 Naturally, me being a computer geek and all (2) I ordered one from a Large 
 Online Retailer as soon as the session was over. I splurged and got the 
 computer, a case, and a power supply (micro USB; it won't run off a standard 
 computer USB port--not enough power) for $50.00. I also got a 32GB Micro SD 
 card for a few dollars more. It supports a variety of Linux operating 
 systems; I installed the one designed for the card (Raspbian).  (You can also 
 buy a card with the operating system already installed.)

 All of this comes from the Raspberry Pi Foundation (4), a UK-based 
 educational charity. From their web site: It is a capable little device that 
 enables people of all ages to explore computing, and to learn how to program 
 in languages like Scratch and Python. It's capable of doing everything you'd 
 expect a desktop computer to do, from browsing the internet and playing 
 high-definition video, to making spreadsheets, word-processing, and playing 
 games.

 If you want to see a picture of mine, go to http://www.philobiblios.net/pi. I 
 persuaded my cat to pose with it to give an idea of how big it is. (5)

 So, how does this fit in with medical libraries? Well, there may be some 
 libraries here who are so flush with money that they don't need an 
 inexpensive computer, but for the rest of us, I have some ideas.

 Presentations

 Anybody here give presentations, or lend out computers for 
 doctors/nurses/teachers to do them? We have computers and projectors, but 
 sometimes we run out. I installed Libre Office (6) on my Raspberry Pi and 
 tried running my library orientation PowerPoint show on it. Libre Office can 
 read pptx files, and it worked well. My presentation had full-screen photos, 
 which displayed perfectly. The cockroach crawling across the screen didn't 
 work perfectly, but I think that would be easy to fix. I haven't tried more 
 complicated videos such as 4D ultrasound yet, but for simple files, it does 
 the job.

 Or, if you want to set up a rotating slide show for an exhibit, a small 
 computer is a lot easier to carry around--you can roll it up in your t-shirt 
 sleeve. And if you drop it or it gets stolen, it's a lot cheaper to replace 
 than a laptop. (Though unlike most laptops, it can't be fitted with a 
 security cable.)

 Internet Demos

 You can get a wireless USB 

Re: [Koha] Koha 3.20.3 UTF-8 Problems

[Jonathan Druart]

See bug 14813 and bug 14817.

2015-09-08 6:35 GMT+01:00 Abdulsalam Yousef :
> Hello All,
>
> Koha 3.20.3 suffers from UTF-8 Problems in some pages such as, When trying
> to edit help in
> Arabic interface
> it shows garbage like this:
>
> ٠رحباً بك٠٠ي ÙƒÙiˆÙ‡Ø§
>
> إذا كانت هذه هي ال٠رة الأولى
> الأخرى ال٠وجودة ٠ي الإدارة.
>
> Although it shows help good in Arabic when reading help.
> Also when trying to import borrowers form tools > Import patrons
>
> Default values like (Salutation:, Surname, ...etc) looks like (تحية:)
> in Arabic interface, Although it's ok in Arabic interface columns.def file,
> Also the same thing when trying to build new Guided reports from Guided
> reports wizard.
>
> Thanks
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Wrong shortcuts in Koha menu "Cataloging"

[Jonathan Druart]

Hi Michael,

I have attached a patch to the bug report.

Regards,
Jonathan

2015-09-15 23:53 GMT+01:00 Michael Kuhn :
> Hi Liz
>
>> This is, actually, how it is. And yes, I think it's confusing. Please
>>
>> file a bug at http://bugs.koha-community.org.
>>
>> Probably we need to add a shortcut to this screen because it's got extra
>> tabs.
>
>
> Thanks for your answer! I just filed the bug
>
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14829
>
>
> Kind regards, Michael
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Intranet Edit help encoding problem

[Jonathan Druart]

It's a bug, I have just submitted a patch on bug 14813. Please test.

2015-09-07 11:11 GMT+01:00 Abdulsalam Yousef :
> Hello all,
>
> We have installed koha 3.20.3, When trying to edit help in Arabic interface
> it shows garbage like this:
>
> ٠رحباً بك٠٠ي ÙƒÙiˆÙ‡Ø§
>
> إذا كانت هذه هي ال٠رة الأولى التي تقوÙ
> ٠يها بتسجيل الدخول إلى كوها، يجب عليك
> الذهاب إلى إدارة كوها وتنصيب ج٠يع ٠٠ضلات
> النظا٠، ٠ئات ال٠ست٠يد، أنواع ال٠ادة والÙ
> كتبات. ك٠ا يجب عليك ٠راجعة الإعدادات
> الأخرى ال٠وجودة ٠ي الإدارة.
>
> Although it shows help good in Arabic when reading help.
>
> Any suggestions???
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] software error

[Jonathan Druart]

Sorry, you have provided all details before!
If you manage to reproduce the error on-demand it would be good to
test with the master branch and with the patch on bug 14778 (not in
master yet).

2015-09-28 17:26 GMT+01:00 Scott Owen <so...@edzone.net>:
> Nope, SQL runs on the same server.
>
>
> On Mon, Sep 28, 2015 at 12:14 PM, Jonathan Druart <
> jonathan.dru...@bugs.koha-community.org> wrote:
>
>> Does your mysql server run on another server?
>> If so, it should be defined in the koha-conf.xml, search the config
>> section, then hostname.
>>
>> 2015-09-28 16:44 GMT+01:00 Scott Owen <so...@edzone.net>:
>> > Looks like here is where things go south
>> >
>> > **
>> >
>> > [Fri Sep 25 15:20:03 2015] Auth.pm: DBI
>> > connect('dbname=koha_dlpms;host=localhost;port=3306','koha_dlpms',...)
>> > failed: Lost connection to MySQL server at 'sending authentication
>> > information', system error: 32 at /usr/share/perl5/DBIx/Connector.pm
>> > line 32
>> >
>> > 
>> >
>> >
>> >
>> > Could i just have a typo somewhere 
>> >
>> > *
>> >
>> > opac-search.pl?q=middol+school
>> >
>> > **
>> >
>> >
>> >
>> > Rather than "localhost" should I hardcode in the system IP ??
>> >
>> > ***
>> >
>> > 'dbname=koha_dlpms;host=localhost;port=3306'
>> >
>> > 
>> >
>> >
>> >
>> > _log
>> > snip__
>> >
>> > [Fri Sep 25 15:19:40.358978 2015] [cgi:error] [pid 6777] [client
>> > 10.1.1.111:36648] AH01215: [Fri Sep 25 15:19:18 2015] opac-user.pl:
>> > BEGIN failed--compilation aborted at
>> > /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 25., referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:27.363750 2015] [cgi:warn] [pid 6424] [client
>> > 10.1.1.111:15692] AH01220: Timeout waiting for output from CGI script
>> > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:40.317727 2015] [cgi:warn] [pid 6427] [client
>> > 10.1.1.111:15697] AH01220: Timeout waiting for output from CGI script
>> > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:40.418439 2015] [cgi:error] [pid 6424] [client
>> > 10.1.1.111:15692] Script timed out before returning headers:
>> > opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:40.523899 2015] [cgi:error] [pid 6427] [client
>> > 10.1.1.111:15697] Script timed out before returning headers:
>> > opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:40.751819 2015] [cgi:error] [pid 6414] [client
>> > 10.1.1.111:15685] Script timed out before returning headers:
>> > opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:40.318628 2015] [cgi:warn] [pid 6432] [client
>> > 10.1.1.111:15700] AH01220: Timeout waiting for output from CGI script
>> > /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:19:41.062151 2015] [cgi:error] [pid 6432] [client
>> > 10.1.1.111:15700] Script timed out before returning headers:
>> > opac-search.pl, referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> > [Fri Sep 25 15:20:03.586683 2015] [cgi:error] [pid 6847] [client
>> > 10.1.1.111:36745] AH01215: ., referer:
>> > http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>> >
>> >
>> ___
>> >
>> >
>> > Thanks for any pointers of where to go from here 
>> >
>> > -S
>> >
>> >
>> >
>> > On Tue, Sep 22, 2015 at 10:48 PM, Robin Sheat <ro...@catalyst.net.nz>
>> wrote:
>> >
>> >&

Re: [Koha] software error

[Jonathan Druart]

Does your mysql server run on another server?
If so, it should be defined in the koha-conf.xml, search the config
section, then hostname.

2015-09-28 16:44 GMT+01:00 Scott Owen :
> Looks like here is where things go south
>
> **
>
> [Fri Sep 25 15:20:03 2015] Auth.pm: DBI
> connect('dbname=koha_dlpms;host=localhost;port=3306','koha_dlpms',...)
> failed: Lost connection to MySQL server at 'sending authentication
> information', system error: 32 at /usr/share/perl5/DBIx/Connector.pm
> line 32
>
> 
>
>
>
> Could i just have a typo somewhere 
>
> *
>
> opac-search.pl?q=middol+school
>
> **
>
>
>
> Rather than "localhost" should I hardcode in the system IP ??
>
> ***
>
> 'dbname=koha_dlpms;host=localhost;port=3306'
>
> 
>
>
>
> _log
> snip__
>
> [Fri Sep 25 15:19:40.358978 2015] [cgi:error] [pid 6777] [client
> 10.1.1.111:36648] AH01215: [Fri Sep 25 15:19:18 2015] opac-user.pl:
> BEGIN failed--compilation aborted at
> /usr/share/koha/opac/cgi-bin/opac/opac-user.pl line 25., referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:27.363750 2015] [cgi:warn] [pid 6424] [client
> 10.1.1.111:15692] AH01220: Timeout waiting for output from CGI script
> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:40.317727 2015] [cgi:warn] [pid 6427] [client
> 10.1.1.111:15697] AH01220: Timeout waiting for output from CGI script
> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:40.418439 2015] [cgi:error] [pid 6424] [client
> 10.1.1.111:15692] Script timed out before returning headers:
> opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:40.523899 2015] [cgi:error] [pid 6427] [client
> 10.1.1.111:15697] Script timed out before returning headers:
> opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:40.751819 2015] [cgi:error] [pid 6414] [client
> 10.1.1.111:15685] Script timed out before returning headers:
> opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:40.318628 2015] [cgi:warn] [pid 6432] [client
> 10.1.1.111:15700] AH01220: Timeout waiting for output from CGI script
> /usr/share/koha/opac/cgi-bin/opac/opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:19:41.062151 2015] [cgi:error] [pid 6432] [client
> 10.1.1.111:15700] Script timed out before returning headers:
> opac-search.pl, referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
> [Fri Sep 25 15:20:03.586683 2015] [cgi:error] [pid 6847] [client
> 10.1.1.111:36745] AH01215: ., referer:
> http://10.1.1.37/cgi-bin/koha/opac-search.pl?q=middol+school
>
> ___
>
>
> Thanks for any pointers of where to go from here 
>
> -S
>
>
>
> On Tue, Sep 22, 2015 at 10:48 PM, Robin Sheat  wrote:
>
>> Scott Owen schreef op di 22-09-2015 om 22:25 [-0400]:
>> > Hummm.database is located on the same boxso I think a
>> > conductivity
>> > issue is unlikely. Guess I'll start digging through logs in my free
>> > timeany particular log that might be a good place to start? any
>> > key
>> > words I should be looking for ?
>>
>> Nothing in particular, but I'd look for anything odd in syslog, perhaps
>> turn the mysql logging level up a bit and see what it says, and so
>> forth. Note that I'm not 100% sure that this is the cause of your issue,
>> but it looks like it from the surface.
>>
>> --
>> Robin Sheat
>> Catalyst IT Ltd.
>> ✆ +64 4 803 2204
>> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fwd: Re: slow check out/check in

[Jonathan Druart]

Hello Sebastian,

What version of Koha are you using?
What you describe should be fixed in recent versions (>=3.16), see
bugs 14494 and 13242.

Regards,
Jonathan

2015-09-23 8:03 GMT+01:00 Sebastian Hierl :
> Also be sure to check that patron expiration dates are not too far ahead,
> but in the fairly recent future (10 years or so).  For select patrons we
> had  as the date and that led to 1 min. delays, as Koha was calculating
> when books would be due.
>
> -Sebastian
>
> --
> Sebastian Hierl, Ph.D.
> Drue Heinz Librarian, Arthur & Janet C. Ross Library
> American Academy in Rome
> Via Angelo Masina 5
> 00153 Rome
> Italy
>
> T: +39 06 5846 417
> F: +39 06 5810 788
>
> On Wed, Sep 23, 2015 at 4:28 AM, Scott Owen  wrote:
>
>> Dang.I thought I was specialgetting personal attention and all.
>>
>> Guess I'll address the list as well
>>
>> I was coming to the same conclusion..about an upgrade
>>
>> Happen to know of any good "how to" upgrade link/PDF/directions.
>>
>> to bad though...this box has run for a number of years without ANY type of
>> hiccup...until now   :-(
>>
>> -S
>>
>>
>>
>> On Tue, Sep 22, 2015 at 7:49 PM, Liz Rea  wrote:
>>
>> > I failed at email addressing. This should have gone to the list.
>> >
>> >
>> > Hi Scott,
>> >
>> > Is that really Koha 3.01?
>> >
>> > The solution to this is probably "upgrade Koha," as this version is no
>> > longer supported.
>> >
>> > Cheers,
>> > Liz
>> >
>> > On 23/09/15 06:21, Scott Owen wrote:
>> > > Patrons seem to pull up fine, but, there seems to be a 30 second delay
>> in
>> > > any part of the circulation module.
>> > >
>> > > Mass checking in a stack of books is taking huge amounts of time due to
>> > the
>> > > 30 second delay between scanning and the ability to do the next scan.
>> > >
>> > > Anything I can try for a quick fix on this ??
>> > >
>> > > Using Firefox as the web browser,
>> > >
>> > >
>> > >
>> > > Server informationKoha version:3.01.00.145OS version ('uname -a'):Linux
>> > > koha3 2.6.26-2-686 #1 SMP Thu Aug 19 03:44:10 UTC 2010 i686
>> GNU/LinuxPerl
>> > > interpreter:/usr/bin/perlPerl version:5.010001Perl
>> > @INC:/usr/share/koha/lib
>> > > /etc/perl
>> > > /usr/local/lib/perl/5.10.1
>> > > /usr/local/share/perl/5.10.1
>> > > /usr/lib/perl5
>> > > /usr/share/perl5
>> > > /usr/lib/perl/5.10
>> > > /usr/share/perl/5.10
>> > > /usr/local/lib/site_perl
>> > > /usr/local/lib/perl/5.10.0
>> > > /usr/local/share/perl/5.10.0
>> > > .
>> > > MySQL version:mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu
>> > (i486)
>> > > using readline 5.2Apache version:Server version: Apache/2.2.16
>> > (Debian)Zebra
>> > > version:Zebra 2.0.44 (C) 1994-2010, Index Data ApS Zebra is free
>> > software,
>> > > covered by the GNU General Public License, and you are welcome to
>> change
>> > it
>> > > and/or distribute copies of it under certain conditions. SHA1 ID:
>> > > 419ad759807269fdfa379799a051ed3a551c6541 Using ICU
>> > > ___
>> > > Koha mailing list  http://koha-community.org
>> > > Koha@lists.katipo.co.nz
>> > > https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>> > --
>> > --
>> > Liz Rea
>> > Catalyst.Net Limited
>> > Level 6, Catalyst House,
>> > 150 Willis Street, Wellington.
>> > P.O Box 11053, Manners Street,
>> > Wellington 6142
>> >
>> > GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> > ___
>> > Koha mailing list  http://koha-community.org
>> > Koha@lists.katipo.co.nz
>> > https://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>> >
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] batch item modification problem

[Jonathan Druart]

Hello,

It will certainly not be fixed.
You should use the 3.20 version to fix these kind of encoding issues.

Regards,
Jonathan

2015-09-22 23:41 GMT+01:00 Liz Rea :
> Hi,
>
> Please file a bug for this issue at http://bugs.koha-community.org, with
> the information you've provided here. Thanks!
>
> Liz
>
> On 23/09/15 10:30, www retive wrote:
>> hi,
>>
>> yes, all authorised values have descriptions, including those that are not 
>> displayed.
>> And yes, the authorised values that are not displayed have diacritics in the 
>> description.
>>
>> i found out that when there are diacritics the generated html is missing the 
>> description :
>>
>> Histoire / Afrique / Colonialisme & 
>> Anti-colonialisme
>> --> no diacritics, generated html ok
>>
>>
>> 
>> --> with "e accute", the generated html is missing the description
>>
>> cheers
>> philippe
>>
>>
>>
>> Le Mercredi 23 septembre 2015 0h07, Liz Rea  a écrit :
>> Hi,
>>
>> Do all of the authorised values have descriptions attached to them? Or
>> do they possibly have diacritics in the description?
>>
>> Cheers,
>> Liz
>>
>>
>> On 23/09/15 09:50, www retive wrote:
>>> hi,
>>>
>>>
>>> i run koha 3.18.10 on debian wheezy.
>>>
>>> when i want to use the "batch item modification" tool, some authorized 
>>> values
>>> don't display correctly.
>>> there is a screenshot at
>>> https://laretive.info/wp-content/uploads/2015/09/screenshot-authorized-values-display-problem.png
>>>
>>> any ideas ?
>>> ___
>>> Koha mailing list  http://koha-community.org
>>> Koha@lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
> --
> --
> Liz Rea
> Catalyst.Net Limited
> Level 6, Catalyst House,
> 150 Willis Street, Wellington.
> P.O Box 11053, Manners Street,
> Wellington 6142
>
> GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] batch item modification problem

[Jonathan Druart]

You could try this: http://pastebin.com/EqtnnPPU

2015-09-22 23:30 GMT+01:00 www retive :
> hi,
>
> yes, all authorised values have descriptions, including those that are not 
> displayed.
> And yes, the authorised values that are not displayed have diacritics in the 
> description.
>
> i found out that when there are diacritics the generated html is missing the 
> description :
>
> Histoire / Afrique / Colonialisme & 
> Anti-colonialisme
> --> no diacritics, generated html ok
>
>
> 
> --> with "e accute", the generated html is missing the description
>
> cheers
> philippe
>
>
>
> Le Mercredi 23 septembre 2015 0h07, Liz Rea  a écrit :
> Hi,
>
> Do all of the authorised values have descriptions attached to them? Or
> do they possibly have diacritics in the description?
>
> Cheers,
> Liz
>
>
> On 23/09/15 09:50, www retive wrote:
>> hi,
>>
>>
>> i run koha 3.18.10 on debian wheezy.
>>
>> when i want to use the "batch item modification" tool, some authorized values
>> don't display correctly.
>> there is a screenshot at
>> https://laretive.info/wp-content/uploads/2015/09/screenshot-authorized-values-display-problem.png
>>
>> any ideas ?
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>
> --
> --
> Liz Rea
> Catalyst.Net Limited
> Level 6, Catalyst House,
> 150 Willis Street, Wellington.
> P.O Box 11053, Manners Street,
> Wellington 6142
>
> GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Batch patron deletion/anonymization issue page: Restricted dropdown menu

[Jonathan Druart]

Hi Charlotte,

It's a bug, the patron categories with a category code or category
type equal to 'S' are not displayed.
The tool should only hide patron categories with a category type
equals to 'S', which is used for Staff patrons.
Could you please open a bug report on bugs.koha-community.org?

Regards,
Jonathan

2015-12-18 8:50 GMT+00:00 Charlotte Stock :
> The dropdown menu for "whose patron category is" does not display the full 
> set of patron types; annoyingly, it is the 'student' category that I need to 
> select! In case the menu is limited to a specific number of lines, I then 
> deleted a disused category in the hope that it would allow the 'student' 
> category to be displayed but this has not happened. I have checked each 
> patron category and there is no branch limitation. Can anyone suggest why 
> this dropdown menu does not supply all patron categories, and what the 
> workaround solution will be?
>
> Thanks
> Charlotte
> ---
> This email message has been delivered safely and archived online by Mimecast.
> For more information please visit http://www.mimecast.com
> ---
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Custom Header

[Jonathan Druart]

Hello,

Have a look at the 'opacheader' system preferences.

Regards,
Jonathan

2016-01-06 5:43 GMT+00:00 Chrispin Simasiku Sitali :
> Happy New Year. I would like to place a custom header to the opac. I am
> using Ubun tu 14.04 LTS and Koha 3.22.01 and installed it using this
> method:
> http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
>
> My new year would be meaningful if someone pointed me in the right direction
>
> Thank you
>
> --
> Charles Lwanga College of Education,
> P. O. Box 660193,
> Monze,
> ZAMBIA.
>
> Mobile: +26 0979 869471
> +26 0966 869471
> SKYPE: Libsitali
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Batch patron deletion/anonymization issue page: Restricted dropdown menu

[Jonathan Druart]

Patch attached on bug 15398.

2015-12-18 8:50 GMT+00:00 Charlotte Stock :
> The dropdown menu for "whose patron category is" does not display the full 
> set of patron types; annoyingly, it is the 'student' category that I need to 
> select! In case the menu is limited to a specific number of lines, I then 
> deleted a disused category in the hope that it would allow the 'student' 
> category to be displayed but this has not happened. I have checked each 
> patron category and there is no branch limitation. Can anyone suggest why 
> this dropdown menu does not supply all patron categories, and what the 
> workaround solution will be?
>
> Thanks
> Charlotte
> ---
> This email message has been delivered safely and archived online by Mimecast.
> For more information please visit http://www.mimecast.com
> ---
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] "DataTables warning" on detail.pl (Staff Interface)

[Jonathan Druart]

grex sent me a screenshot and I reproduced the issue.
A patch is available for testing on bug 15256.
This affects 3.18.x, 3.20.x and master.

2015-11-25 12:30 GMT+00:00 Jonathan Druart
<jonathan.dru...@bugs.koha-community.org>:
> Could you take a screenshot of the page where you get the warning message?
>
> 2015-11-25 10:58 GMT+00:00 le-grex <p...@grex.is-lost.org>:
>> Am 25.11.2015 um 09:35 schrieb Jonathan Druart:
>>
>>> Hi grex,
>>
>> Hi Jonathan,
>>
>>>
>>> I don't get this error with a patron having only the catalogue permission.
>>> Are you sure you have correctly refreshed the page to update the JS code?
>>
>> Not sure how to do it correctly, but i have it in different Browsers and
>> also my colleagues do see this.
>>
>>> Which columns do you have on the items table?
>>
>> There are:
>>
>> itemnumber
>> biblionumber
>> biblioitemnumber
>> barcode
>> dateaccessioned
>> booksellerid
>> homebranch
>> price
>> replacementprice
>> replacementpricedate
>> datelastborrowed
>> datelastseen
>> stack
>> notforloan
>> damaged
>> itemlost
>> itemlost_on
>> withdrawn
>> withdrawn_on
>> itemcallnumber
>> coded_location_qualifier
>> issues
>> renewals
>> reserves
>> restricted
>> itemnotes
>> itemnotes_nonpublic
>> holdingbranch
>> paidfor
>> timestamp
>> location
>> permanent_location
>> onloan
>> cn_source
>> cn_sort
>> ccode
>> materials
>> uri
>> itype
>> more_subfields_xml
>> enumchron
>> copynumber
>> stocknumber
>>
>>> Confirm that you are running Koha 3.20.05.
>>
>> I confirm that: koha-common_3.20.05.
>>
>> And as addendum:
>>
>> The problem is happening if there is more than 1 item for one
>> bibliographic record. Like 2 in one Library or one in each of 2
>> libraries. But since this is no problem in a different instance, it's
>> not the main clue...
>>
>>>
>>> Regards,
>>> Jonathan
>>
>> Thank you,
>>
>> grex
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] "DataTables warning" on detail.pl (Staff Interface)

[Jonathan Druart]

Hi grex,

I don't get this error with a patron having only the catalogue permission.
Are you sure you have correctly refreshed the page to update the JS code?
Which columns do you have on the items table?
Confirm that you are running Koha 3.20.05.

Regards,
Jonathan

2015-11-24 16:40 GMT+00:00 le-grex :
> Hey,
>
> i have a problem i have no solution for:
>
> A user played (indeed on a "sandbox", latest Stable Koha) with user
> permissions and misc. settings in the Administration menu. And yes it's
> totally unclear, what exactly made this effect happen or what he did,
> but here it is:
>
> If you now search for books in the opac staff interface as a user who is
> not superlibrarian, i got a error message:
>
> "DataTables warning: table id=DataTables_Table_1 - Requested unknown
> parameter '8' for row0."
>
> There i can click OK and it's all working, i don't see any problem,
> besides this annoying error message.
>
> A Superlibrarian doesn't see this error. And it's only on the detail.pl
> view, so i.e. not on MARCdetail.pl and so on.
>
> There are two other Koha-Instances on this, they don't have this
> problem. I even tried to restore an older Version of the Database of
> this Instance with no effect.
>
> So i'm lost for now, not sure where to start.
>
> I hope you have an idea.
>
> Thank you,
>
> grex
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] "DataTables warning" on detail.pl (Staff Interface)

[Jonathan Druart]

Could you take a screenshot of the page where you get the warning message?

2015-11-25 10:58 GMT+00:00 le-grex <p...@grex.is-lost.org>:
> Am 25.11.2015 um 09:35 schrieb Jonathan Druart:
>
>> Hi grex,
>
> Hi Jonathan,
>
>>
>> I don't get this error with a patron having only the catalogue permission.
>> Are you sure you have correctly refreshed the page to update the JS code?
>
> Not sure how to do it correctly, but i have it in different Browsers and
> also my colleagues do see this.
>
>> Which columns do you have on the items table?
>
> There are:
>
> itemnumber
> biblionumber
> biblioitemnumber
> barcode
> dateaccessioned
> booksellerid
> homebranch
> price
> replacementprice
> replacementpricedate
> datelastborrowed
> datelastseen
> stack
> notforloan
> damaged
> itemlost
> itemlost_on
> withdrawn
> withdrawn_on
> itemcallnumber
> coded_location_qualifier
> issues
> renewals
> reserves
> restricted
> itemnotes
> itemnotes_nonpublic
> holdingbranch
> paidfor
> timestamp
> location
> permanent_location
> onloan
> cn_source
> cn_sort
> ccode
> materials
> uri
> itype
> more_subfields_xml
> enumchron
> copynumber
> stocknumber
>
>> Confirm that you are running Koha 3.20.05.
>
> I confirm that: koha-common_3.20.05.
>
> And as addendum:
>
> The problem is happening if there is more than 1 item for one
> bibliographic record. Like 2 in one Library or one in each of 2
> libraries. But since this is no problem in a different instance, it's
> not the main clue...
>
>>
>> Regards,
>> Jonathan
>
> Thank you,
>
> grex
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] System treating patron secondary email as mandatory and complaining even with valid email address

[Jonathan Druart]

Hello Admire,
With "it's not mandatory", you mean you have checked the system
preference "BorrowerMandatoryField "?

2016-01-12 14:21 GMT+00:00 Admire Mutsikiwa :
>
>
> Hi All
>
> I have upgraded my Koha instance from version 3.18 to 3.22. Now when
> updating patron records that have expired, the system is complaining if the
> secondary email is empty and yet it is not mandatory. In addition, if there
> is valid email, it is also complaining that it is invalid until you edit it
> somehow, that is when it will save the record. Any pointers to resolve this.
>
>
>
>
>
>
>
> Kind Regards,
>
>
>
> Admire Mutsikiwa (Mr)
>
> ICT Manager
>
> Libraries
>
> University of Zimbabwe
>
> Tel:+263-4-303276
>
> Mob:+26377111
>
>
>
> "It is easy to dodge our responsibilities, but we cannot dodge the
> consequences of dodging our responsibilities."  Josiah Charles Stamp
> 
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)

[Jonathan Druart]

Hi Craig,
It seems to work for me (dev install on master).
Could you check the logs file and check if it's clear or not?
If everything looks ok in the logs, could you try on a sandbox to make
sure it's a bug?
Regards,
Jonathan

2016-06-09 14:49 GMT+01:00 Craig Butosi :
> Hi all,
>
> Update:
>
> Problem with Notice & Status Triggers (Tools › Notice triggers)
>
> I just discovered that when I attempt to save my notice trigger configuration 
> after (1) setting a delay integer, (2) selecting an overdue notice template, 
> and then choosing a delivery type (Email, SMS, etc.), the configuration saves 
> but without the any of the delivery method types saving - they reset to an 
> unchecked status. I do get a "changes saved" confirmation overall, but my 
> selections disappear for Email, Print, and SMS after clicking the Save 
> Changes button.
>
> The only column that does stick is Restrict.
>
> I think this might be why my overdue notices aren't sending. Anyone 
> experience this? Does anyone know how to correct this?
>
> Many thanks!
>
> C
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West Toronto, ON  M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
> 
> From: Craig Butosi
> Sent: Wednesday, June 08, 2016 2:24 PM
> To: koha
> Subject: Koha 16.05 - Manually send overdue notices from command-line?
>
> Hi all,
>
> Koha 16.05
> Ubuntu 14.04 LTS
> Package install
>
> After one properly sets up overdue notices (i.e., correct HTML markup in ODUE 
> notice, triggers set, enhanced messaging enabled, MTA installed, patron 
> categories set to receive overdue notices, etc.), can you manually compile 
> and push out overdue notices from the command-line? I’ve successfully tested 
> the Advanced Notice, Password Reset, Hold Placed, Check-out and Check-in 
> notices this way; however, I can’t seem to push out overdue notices no matter 
> what I do. (Nor for that matter do I receive overdue notices at all despite 
> crons being set, etc.).
>
> Command-line Method:
>
> # export PERL5LIB=/usr/share/koha/lib
> # export KOHA_CONF=/etc/koha/sites/library/koha-conf.xml
> #/usr/share/koha/bin/cronjobs/overdue_notices.pl
> #/usr/share/koha/bin/cronjobs/process_message_queue.pl
>
> I’m just wondering if a Koha overdue setting is preventing the manual method 
> from succeeding. Or, if it’s more likely something else that’s preventing OD 
> notices from being pushed out.
>
> Thanks all!
>
> C
>
>
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
>
>
>
> Note: This email message and any attachments are intended only for the use of 
> the individual to which it is addressed, and may contain information that is 
> privileged, confidential and exempt from disclosure under applicable law. If 
> the recipient of this email is not the intended recipient (or the employee or 
> agent responsible for delivering the email to the intended recipient), you 
> are hereby notified that any review, dissemination, distribution or copying 
> or other use of this message is strictly prohibited. If you have received 
> this communication in error, please notify the sender immediately by return 
> email and delete this message and attachments from your system, thank you.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha-dev list problems

[Jonathan Druart]

Hi Barry,

BibLibre hosts the ML and has access to the admin area (maybe others have?).
You should ask them what's wrong (the common mistake is to use an
email address different from the one registered, but it seems that you
excluded this possibility).

Regards,
Jonathan

2016-06-10 10:46 GMT+01:00 Barry Cannon :
> Hi,
>   Is anyone having issues posting to koha-devel? I have tried to post 3 
> times in the last two days. I've even un-subscribed and re-subscribed. I have 
> also tried different email accounts but I can't seem to get a successfully 
> post!
>
> Regards
> Barry Cannon
> Interleaf Technology
> http://www.interleaf.ie
> Tel: +35312865855
> Email: b...@interleaf.ie
> Skype: bar.cannon
>
>
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)

[Jonathan Druart]

You have something (very) wrong with your schema.
A foreign key is refering to an old_overduerules table. But there is
no such table in Koha.
If you have a look at the DB entry 3.23.00.007 (updatedatabase.pl) you
will find a reference to this table.
You certainly got a sql error when updating, any chances to find it?

2016-06-09 17:16 GMT+01:00 Craig Butosi <craig.but...@rcmusic.ca>:
> Hi Jonathan,
>
> Bingo. I think the following is the issue. Found it in intranet-error.log:
>
> =
> [Thu Jun 09 11:17:43.711438 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl: 
> DBD::mysql::st execute failed: Cannot add or update a child row: a foreign 
> key constraint fails (`koha_library`.`overduerules_transport_types`, 
> CONSTRAINT `overduerules_transport_types_ibfk_1` FOREIGN KEY 
> (`overduerules_id`) REFERENCES `old_overduerules` (`overduerules_id`) ON 
> DELETE CASC) [for Statement ", referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711521 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:   
>   INSERT INTO overduerules_transport_types(, referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711577 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:   
>   overduerules_id, letternumber, message_transport_type, referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711604 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:   
>   ) VALUES (, referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711674 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:   
>   (SELECT overduerules_id FROM overduerules WHERE branchcode = ? AND 
> categorycode = ?), ?, ?, referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711697 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:   
>   ), referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> [Thu Jun 09 11:17:43.711762 2016] [cgi:error] [pid 2943] [client 
> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:   
>   " with ParamValues: 0="MAIN", 1='BOR', 2=1, 3="email"] at 
> /usr/share/koha/intranet/cgi-bin/tools/overduerules.pl line 200., referer: 
> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
> =
>
>
> I wonder if this might have something to do with upgrading to 3.22-->16.05 on 
> my end.
>
> Any ideas?
>
> C
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> the royal conservatory
> TELUS Centre for Performance and Learning
> 273 Bloor Street West Toronto, ON  M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
>
> 
> From: Jonathan Druart [jonathan.dru...@bugs.koha-community.org]
> Sent: Thursday, June 09, 2016 11:50 AM
> To: Craig Butosi
> Cc: koha
> Subject: Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not 
> Saving! (Was: Manually send overdue notices from command-line?)
>
> Hi Craig,
> It seems to work for me (dev install on master).
> Could you check the logs file and check if it's clear or not?
> If everything looks ok in the logs, could you try on a sandbox to make
> sure it's a bug?
> Regards,
> Jonathan
>
> 2016-06-09 14:49 GMT+01:00 Craig Butosi <craig.but...@rcmusic.ca>:
>> Hi all,
>>
>> Update:
>>
>> Problem with Notice & Status Triggers (Tools › Notice triggers)
>>
>> I just discovered that when I attempt to save my notice trigger 
>> configuration after (1) setting a delay integer, (2) selecting an overdue 
>> notice template, and then choosing a delivery type (Email, SMS, etc.), the 
>> configuration saves but without the any of the delivery method types saving 
>> - they reset to an unchecked status. I do get a "changes saved" confirmation 
>> overall, but my selections disappear for Email, Print, and SMS after 
>> clicking the Save Changes button.
>>
>> The only column that does stick is Restrict.
>>
>> I think this might be why my overdue notices aren't sending. Anyone 
>> experien

Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not Saving! (Was: Manually send overdue notices from command-line?)

[Jonathan Druart]

Your log file is scary :)
It seems that you have done something wrong with your database. I'd
say you used a DB created with the current version (16.05 or master)
and executed all the updates since 3.23.00.000. But it's weird because
the "Version" system preference should prevent this manipulation
problem.
So yes, if you do not care of your install, restart with a new one :)

2016-06-10 18:05 GMT+01:00 Craig Butosi <craig.but...@rcmusic.ca>:
> Hi Jonathan, all,
>
> Thanks for confirming. I'm looking at the koha log file now and there are 2 
> files labeled as updatedatabase-error. Yes, something horrible happened 
> during 3.22-->16.05. My fault for ignoring this immediately after the Web 
> installer ran. Looks like write errors after updatedatabase.pl ran, duplicate 
> columns warnings, etc.
>
> File 1
> https://www.dropbox.com/s/h72huzxa9m88hhk/updatedatabase_2016-06-06T135642_3.2206000_16.050.txt?dl=0
>
> File2
> https://www.dropbox.com/s/tybsmb8ytwtjyv3/updatedatabase-error_2016-06-06T135642_3.2206000_16.050.txt?dl=0
>
>
> Would dropping koha db and then creating an empty sql db correct this, or 
> should I remove our koha instance completely and do a fresh install? I'm 
> dealing with an empty Koha instance, other than some jquery and css 
> modifications. So, it's not a big deal to start fresh.
>
> Recommendations? (Thank you for your time, btw!)
>
> C
>
>
> Craig Butosi, MA, MLIS, B Mus (Hons.)
> LIBRARY SERVICES MANAGER
> THE ROYAL CONSERVATORY
> TELUS Centre for Performance and Learning
> 273 Bloor Street West
> Toronto, ON M5S 1W2
> 416.408.2824 x338
> www.rcmusic.ca
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
> Druart
> Sent: June-10-16 7:49 AM
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Koha 16.05 - Notice Triggers Issue: Delivery Options Not 
> Saving! (Was: Manually send overdue notices from command-line?)
>
> You have something (very) wrong with your schema.
> A foreign key is refering to an old_overduerules table. But there is no such 
> table in Koha.
> If you have a look at the DB entry 3.23.00.007 (updatedatabase.pl) you will 
> find a reference to this table.
> You certainly got a sql error when updating, any chances to find it?
>
> 2016-06-09 17:16 GMT+01:00 Craig Butosi <craig.but...@rcmusic.ca>:
>> Hi Jonathan,
>>
>> Bingo. I think the following is the issue. Found it in intranet-error.log:
>>
>> =
>> [Thu Jun 09 11:17:43.711438 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl: 
>> DBD::mysql::st execute failed: Cannot add or update a child row: a foreign 
>> key constraint fails (`koha_library`.`overduerules_transport_types`, 
>> CONSTRAINT `overduerules_transport_types_ibfk_1` FOREIGN KEY 
>> (`overduerules_id`) REFERENCES `old_overduerules` (`overduerules_id`) ON 
>> DELETE CASC) [for Statement ", referer: 
>> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
>> [Thu Jun 09 11:17:43.711521 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:  
>>INSERT INTO overduerules_transport_types(, referer: 
>> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
>> [Thu Jun 09 11:17:43.711577 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:  
>>overduerules_id, letternumber, message_transport_type, referer: 
>> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
>> [Thu Jun 09 11:17:43.711604 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:  
>>) VALUES (, referer: 
>> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
>> [Thu Jun 09 11:17:43.711674 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:  
>>(SELECT overduerules_id FROM overduerules WHERE branchcode = ? 
>> AND categorycode = ?), ?, ?, referer: 
>> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
>> [Thu Jun 09 11:17:43.711697 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 2016] overduerules.pl:  
>>), referer: 
>> https://library.craigbutosi.ca/cgi-bin/koha/tools/overduerules.pl
>> [Thu Jun 09 11:17:43.711762 2016] [cgi:error] [pid 2943] [client 
>> 174.113.255.196:52914] AH01215: [Thu Jun  9 11:17:43 

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

[Jonathan Druart]

http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/updatedatabase.pl;h=950ed2067dac0edd51cf5e49ff25862c6f53ecdb;hb=refs/heads/3.20.x#l10576

It exploded because you already had the constraint
(course_reserves_ibfk_2), so everything is fine.

2016-01-11 17:01 GMT+00:00 Bortel, Gary <gary.bor...@sos.wa.gov>:
> Hmmm...
>
> Using "SHOW CREATE TABLE course_reserves" returns...
>
> .
> .
> .
>   PRIMARY KEY (`cr_id`),
>   UNIQUE KEY `pseudo_key` (`course_id`,`ci_id`),
>   KEY `course_id` (`course_id`),
>   KEY `course_reserves_ibfk_2` (`ci_id`),
>   CONSTRAINT `course_reserves_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES 
> `courses` (`course_id`),
>   CONSTRAINT `course_reserves_ibfk_2` FOREIGN KEY (`ci_id`) REFERENCES 
> `course_items` (`ci_id`) ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
>
> The course reserves function is not enabled on this instance and both 
> course_reserves and course_items are empty. Could it be updatedatabase.pl is 
> expecting that function to be enabled and those tables to contain at least 
> one item? I hate to admit it, but I don't see a line 10584 in 
> updatedatabase.pl so it's difficult for me to determine what is throwing the 
> error.
>
>
> gcb
> __
>
> Gary C. Bortel
> Office of the Secretary of State, Washington State Library
> gary.bor...@sos.wa.gov
> 360.570.5588
>
> Washington State Library: Empowering 21st Century Washington
>
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Jonathan 
> Druart
> Sent: Monday, January 11, 2016 8:24 AM
> To: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07
>
> Hi Gary,
>
>> DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' 
>> (errno: 121) at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10584.
>
> I would say that the foreign key on course_reserves has not been created.
> You should check the data in course_items (some don't have a correspondence 
> in course_reserves).
>
>> DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 
>> 'PRIMARY' at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10614.
>
> You can forget this one, you already had the self_checkout syspref in your 
> database.
>
> Regards,
> Jonathan
>
> 2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bor...@sos.wa.gov>:
>> I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 
>> 3.20.07. Are these benign or something about which concern should be raised?
>>
>> The installation here is Ubuntu 14.04.3 with a multi-tenant package
>> install of Koha. Mysql  Ver 14.14 Distrib 5.5.46, for debian-linux-gnu
>> (x86_64) using readline 6.3
>>
>> .
>> .
>> .
>> .
>> Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include
>> protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Upgrade to
>> 3.20.01.001 done (Bug 9942: Privacy is correctly set) Upgrade to
>> 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred
>> orders) Upgrade to 3.20.02.000 done (Koha 3.20.2) Upgrade to
>> 3.20.03.000 done (Koha 3.20.3) DBD::mysql::db do failed: Can't create
>> table 'koha_library.#sql-4b9_42' (errno: 121) at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10584.
>> Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does
>> not remove link to course reserve) Upgrade to 3.20.03.002 done (Bug
>> 14717: Prevent -00-00 dates in patron data) DBD::mysql::db do failed: 
>> Duplicate entry '1-self_checkout' for key 'PRIMARY' at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10614.
>> Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should
>> only be able to access SCO ) Upgrade to 3.20.04.000 done (Koha 3.20.4)
>> Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and
>> SMSSendPassword are not listed in the system preferences) Upgrade to
>> 3.20.05.000 done (Koha 3.20.4) Upgrade to 3.20.06.000 done (Koha
>> 3.20.5) Upgrade to 3.20.06.001 done (Bug 14978: Make sure
>> issues.itemnumber is a unique key) Upgrade to 3.20.07.000 done (3.20.7
>> release)
>>
>> gcb
>> __
>>
>> Gary C. Bortel
>> IT Services Manager, Library Development Program Office of the
>> Secretary of State, Washington State Library
>> 6880 Capitol Boulevard Southeast
>> P.O. Box 42460
>> Olympia, WA  98

Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07

[Jonathan Druart]

Correction:
It comes from bug 14205 which has been pushed to 3.18.x and 3.20.x, so
you already have the constraint (but double check!).
You can also forget this one :)

2016-01-11 16:24 GMT+00:00 Jonathan Druart
<jonathan.dru...@bugs.koha-community.org>:
> Hi Gary,
>
>> DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' 
>> (errno: 121) at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10584.
>
> I would say that the foreign key on course_reserves has not been created.
> You should check the data in course_items (some don't have a
> correspondence in course_reserves).
>
>> DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 
>> 'PRIMARY' at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10614.
>
> You can forget this one, you already had the self_checkout syspref in
> your database.
>
> Regards,
> Jonathan
>
> 2016-01-11 16:02 GMT+00:00 Bortel, Gary <gary.bor...@sos.wa.gov>:
>> I am seeing two MySQL errors thrown when trying to update from 3.18.11 --> 
>> 3.20.07. Are these benign or something about which concern should be raised?
>>
>> The installation here is Ubuntu 14.04.3 with a multi-tenant package install 
>> of Koha. Mysql  Ver 14.14 Distrib 5.5.46, for debian-linux-gnu (x86_64) 
>> using readline 6.3
>>
>> .
>> .
>> .
>> .
>> Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol)
>> Upgrade to 3.20.01.000 done (Koha 3.20.1)
>> Upgrade to 3.20.01.001 done (Bug 9942: Privacy is correctly set)
>> Upgrade to 3.20.01.002 done (Bug 13993: Correct orderstatus for transferred 
>> orders)
>> Upgrade to 3.20.02.000 done (Koha 3.20.2)
>> Upgrade to 3.20.03.000 done (Koha 3.20.3)
>> DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_42' 
>> (errno: 121) at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10584.
>> Upgrade to 3.20.03.001 done (Bug 14205: Deleting an Item/Record does not 
>> remove link to course reserve)
>> Upgrade to 3.20.03.002 done (Bug 14717: Prevent -00-00 dates in patron 
>> data)
>> DBD::mysql::db do failed: Duplicate entry '1-self_checkout' for key 
>> 'PRIMARY' at 
>> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 
>> 10614.
>> Upgrade to 3.20.03.003 done (Bug 14298: AutoSelfCheckID user should only be 
>> able to access SCO )
>> Upgrade to 3.20.04.000 done (Koha 3.20.4)
>> Upgrade to 3.20.04.001 done (Bug 14820: SMSSendUsername and SMSSendPassword 
>> are not listed in the system preferences)
>> Upgrade to 3.20.05.000 done (Koha 3.20.4)
>> Upgrade to 3.20.06.000 done (Koha 3.20.5)
>> Upgrade to 3.20.06.001 done (Bug 14978: Make sure issues.itemnumber is a 
>> unique key)
>> Upgrade to 3.20.07.000 done (3.20.7 release)
>>
>> gcb
>> __
>>
>> Gary C. Bortel
>> IT Services Manager, Library Development Program
>> Office of the Secretary of State, Washington State Library
>> 6880 Capitol Boulevard Southeast
>> P.O. Box 42460
>> Olympia, WA  98501-2460
>> gary.bor...@sos.wa.gov<mailto:gbor...@secstate.wa.gov>
>> voice: 360.570.5588
>> fax: 360.586.7575
>>
>> Washington State Library: Empowering 21st Century Washington
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] ERROR LOADING MODULE: Date::Manip::DM6

[Jonathan Druart]

Hi Federico,

The error said that you don't have the Date::Manip module installed,
try to install it.

Regards,
Jonathan

2016-02-01 11:43 GMT+00:00 Federico Leva (Nemo) :
> Hello! I'm trying Koha on a small fedora 23 virtual machine for testing (500
> MB RAM, 1 core) and I often get this error in the web interface:
>
> 
>
> Software error:
>
> ERROR LOADING MODULE: Date::Manip::DM6 at
> /usr/share/perl5/vendor_perl/Date/Manip.pm line 34.
> Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Overdues.pm
> line 25.
> BEGIN failed--compilation aborted at
> /usr/share/perl5/vendor_perl/C4/Overdues.pm line 25.
> Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Members.pm
> line 29.
> BEGIN failed--compilation aborted at
> /usr/share/perl5/vendor_perl/C4/Members.pm line 29.
> Compilation failed in require at /usr/share/perl5/vendor_perl/C4/Search.pm
> line 28.
> BEGIN failed--compilation aborted at
> /usr/share/perl5/vendor_perl/C4/Search.pm line 28.
> Compilation failed in require at
> /usr/share/perl5/vendor_perl/C4/AuthoritiesMarc.pm line 24.
> BEGIN failed--compilation aborted at
> /usr/share/perl5/vendor_perl/C4/AuthoritiesMarc.pm line 24.
> Compilation failed in require at
> /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 32.
> BEGIN failed--compilation aborted at
> /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 32.
>
> 
>
> The error is always identical and goes away with a refresh. When it happens
> I see I have less than 10 MB free memory so it really just seems a resource
> issue. I'll give Koha more memory :) but let me know if I missed something
> obvious.
>
> Federico (BEIC)
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 500 error message appears when i add item with non latin content i. The field NOTE

[Jonathan Druart]

Hello Rania,

You should have an error in your log file.
Have a look and report the error here.

Regards,
Jonathan

2016-02-28 6:27 GMT+00:00 Rania.azad :
> Dear
>
> our koha version is 3.20 (not 3.2 sorry for that), any suggestions?
>
>
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/500-error-message-appears-when-i-add-item-with-non-latin-content-i-The-field-NOTE-tp5876141p5876161.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 500 error message appears when i add item with non latin content i. The field NOTE

[Jonathan Druart]

You have uploaded the log file for the opac, not the staff interface.
Do not upload the entire file, just copy the error generated by additem.pl

2016-02-29 10:27 GMT+00:00 Rania.azad :
> opac-error_(1).log
> 
>
>
> Dear,
>
> I did upload the log file as well as screenshot for the error that appears
> when I do enter the data manually to koha.
>
> Is it related to the non-latin content ? because with english books I do not
> have any issue 500_error_message.png
> 
>
>
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/500-error-message-appears-when-i-add-item-with-non-latin-content-i-The-field-NOTE-tp5876141p5876250.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha