Re: [Koha] Problem with opac address

2017-11-23 Thread Bob Birchall
We've also noticed that sometimes but not always, memcached needs a 
restart before a change to a sys pref takes effect. We have not yet 
identified the pattern.

Bob Birchall
Calyx

On 23/11/17 20:53, Magnus Enger wrote:

Hi!

I am the service provider for Lukasz and Alingsås. The site is using
Plack and memcached.

As Lukasz said, the problem is that when e.g. the opaccredits syspref
is changed, the change shows imediately on
https://kohaopac.alingsas.se/cgi-bin/koha/opac-main.pl but not on
https://kohaopac.alingsas.se/. Restarting memcached (not reindexing,
that is a misunderstanding) makes the change show up in both places.

It definitely looks like memcached is being a bit too aggressive in
its caching, but it also seems weird that this is not something more
sites have been running into.

Best regards,
Magnus

On 7 November 2017 at 19:10, Chris Cormack  wrote:

Also if you are already using plack. You should make sure you are using 
memcached.

Chris

On 8 November 2017 6:22:35 AM NZDT, Pedro Amorim  wrote:

Hello lukasz,

What do you mean exactly by your IT "reindexing" the site?

Could it perhaps be related to template cache? In the following
discussion
they talk about "About Koha" -> "System Information" and the directory
for
template caching. You might try removing it if you have it configured.
https://lists.katipo.co.nz/public/koha/2017-March/047438.html

I would also consider enabling Plack for your instance:
https://wiki.koha-community.org/wiki/Plack



On 7 November 2017 at 12:10,  wrote:


Hello,



We've started to show new books at our OPAC site and at some point

after

refreshing our main site stopped to show the changes.

When we ask our IT, he reindexed our site and then all the changes

were

shown.

When we change something again at https://kohaopac.alingsas.se/

without

reindexing there is no effect.

But when we click on Koha logo in the upper left corner of the

screen,

which has this address https://kohaopac.alingsas.se/
cgi-bin/koha/opac-main.pl all the changes are updated and shows
immediately.

It seems as we need reindexing every time we change something at our

OPAC

site, to have main address https://kohaopac.alingsas.se/ to work.

Should we ask our IT to set reindexing for every night or is there

any

other sollution to this problem?


Best regards
Lukasz Mesek
Vuxenbibliotekarie
Alingsås bibliotek
lukasz.me...@alingsas.se
___
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

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
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] Problems with the renewals

2017-11-23 Thread Bob Birchall
The problem is almost certainly in your circulation rules. For the 
precise library/borrower/item type combination, are renewals allowed and 
if so what period is specified?


Always remember that Koha applies the rules from the most specific to 
the most general. So look for 'hidden' exceptions. For example, 
sometimes rules exist for a specific library but you may be examining 
the 'all libraries' rules.


I hope this helps,
Bob Birchall
Calyx

On 24/11/17 01:24, vanda koha wrote:

Hi everybody,

I'm having some problems with the renewals. When I make a loan the date is
automatically calculate by the system (30 days for books, for instance),
but when I make a renewal I have to put the new date due myself, because
the system does not do it automatically: it actually assumes the date of
the day the renweal is made and not the new date due (that is 30 more days)

We are using 16.11.04 Koha version.

What did I do wrong?

Many thanks in advance

Vanda
___
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] OPAC Search Report

2017-11-23 Thread schnydszch
Hi! Looking at the database schema of Koha ILS and Koha mysql report
https://wiki.koha-community.org/wiki/SQL_Reports_Library, you can use this
report:
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Most_Popular_Searches,
the mysql code below:

SELECT COUNT(*) AS Count,
   RIGHT(
  query_desc, 
  Length(query_desc) - Instr(query_desc, ':')
   ) AS 'Search string'
FROM   search_history
GROUP  BY RIGHT(query_desc, Length(query_desc) - Instr(query_desc, ':'))
ORDER  BY COUNT(*) DESC

Mabuhay and HTH!



--
Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Problems with the renewals

2017-11-23 Thread vanda koha
Hi everybody,

I'm having some problems with the renewals. When I make a loan the date is
automatically calculate by the system (30 days for books, for instance),
but when I make a renewal I have to put the new date due myself, because
the system does not do it automatically: it actually assumes the date of
the day the renweal is made and not the new date due (that is 30 more days)

We are using 16.11.04 Koha version.

What did I do wrong?

Many thanks in advance

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


Re: [Koha] OAI-PMH Set Question

2017-11-23 Thread Pedro Amorim
Hello Alphie,

That database error is expected (I think) because the script will always
attempt to insert the records matching your mappings, regardless or already
being in the set or not, unless you run with the -r *reset* flag.

So just so I'm understanding correctly in the future, when will I need to
run build_oai_sets.pl? Is it anytime I create a new set or anytime I load
new records into Koha? Or is it both?

Look for *OAI-PMH:AutoUpdateSets* syspref and enable it. I haven't tested
this but it seems to me it' what you're looking for.
What I'd do is I'd update a biblio record after enabling the syspref and
check if it's working, i.e. the record matching the mapping would
automatically be inserted in the set.

Have a good one,

Pedro Amorim

On 22 November 2017 at 23:24, Alphie Garcia  wrote:

> Thanks, Mark. It gave me a different set of errors this time, but testing
> the sets in OAI, I see that the records are now displaying which is great.
>
> On the errors:
>
> Running perl /usr/share/koha/bin/migration_tools/build_oai_sets.pl in
> koha-shell gave me a 100 of these SQL errors:
>
> DBD::mysql::st execute failed: Duplicate entry '100-3' for key 'PRIMARY'
> [for Statement "
> INSERT INTO oai_sets_biblios (set_id, biblionumber)
> VALUES (?,?)
> " with ParamValues: 0='3', 1='100'] at /usr/share/koha/lib/C4/OAI/
> Sets.pm
> line 597.
>
> Again, the records seem to be populating when I look at the OAI output so I
> guess it's good?
>
> So just so I'm understanding correctly in the future, when will I need to
> run build_oai_sets.pl? Is it anytime I create a new set or anytime I load
> new records into Koha? Or is it both?
>
>
>
> On Wed, Nov 22, 2017 at 1:01 PM, Mark Alexander  wrote:
>
> > Excerpts from Alphie Garcia's message of 2017-11-22 09:56:03 -1000:
> > > When I'm in Linux and type:
> > >
> > > perl /usr/share/koha/bin/migration_tools/build_oai_sets.pl
> > >
> > >
> > > I get the following error:
> > >
> > > Can't locate C4/Context.pm in @INC (you may need to install the
> > C4::Context
> > > module) (@INC contains: /etc/perl
> >
> > Try running this command first:
> >
> >   koha-shell INSTANCE
> >
> > where INSTANCE is the name of your Koha instance.  That should set up
> > the environment so that the build_oai_sets.pl script will run correctly.
> >
> ___
> 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-devel] Koha 16.11.14 released

2017-11-23 Thread Tomas Cohen Arazi
Well done, Katrin!

El jue., 23 de nov. de 2017 4:29 a. m., Katrin Fischer <
katrin.fischer...@web.de> escribió:

> The Koha community is proud to announce the release of Koha 16.11.14.
>
> This is a maintenance release of 16.11 and includes 5 enhancements and
> 23 bugfixes.
>
> The full release notes are available at
> https://koha-community.org/koha-16-11-14-release/
>
> Packages are already available.
>
>
> This is my last release as the 16.11.x Release Maintainer. Thanks to
> everyone involved in getting these 14 releases out!
>
> ___
> 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/
>
-- 
Tomás Cohen Arazi
Theke Solutions (https://theke.io )
✆ +54 9351 3513384
GPG: B2F3C15F
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem with opac address

2017-11-23 Thread Magnus Enger
Hi!

I am the service provider for Lukasz and Alingsås. The site is using
Plack and memcached.

As Lukasz said, the problem is that when e.g. the opaccredits syspref
is changed, the change shows imediately on
https://kohaopac.alingsas.se/cgi-bin/koha/opac-main.pl but not on
https://kohaopac.alingsas.se/. Restarting memcached (not reindexing,
that is a misunderstanding) makes the change show up in both places.

It definitely looks like memcached is being a bit too aggressive in
its caching, but it also seems weird that this is not something more
sites have been running into.

Best regards,
Magnus

On 7 November 2017 at 19:10, Chris Cormack  wrote:
> Also if you are already using plack. You should make sure you are using 
> memcached.
>
> Chris
>
> On 8 November 2017 6:22:35 AM NZDT, Pedro Amorim  wrote:
>>Hello lukasz,
>>
>>What do you mean exactly by your IT "reindexing" the site?
>>
>>Could it perhaps be related to template cache? In the following
>>discussion
>>they talk about "About Koha" -> "System Information" and the directory
>>for
>>template caching. You might try removing it if you have it configured.
>>https://lists.katipo.co.nz/public/koha/2017-March/047438.html
>>
>>I would also consider enabling Plack for your instance:
>>https://wiki.koha-community.org/wiki/Plack
>>
>>
>>
>>On 7 November 2017 at 12:10,  wrote:
>>
>>> Hello,
>>>
>>>
>>>
>>> We've started to show new books at our OPAC site and at some point
>>after
>>> refreshing our main site stopped to show the changes.
>>>
>>> When we ask our IT, he reindexed our site and then all the changes
>>were
>>> shown.
>>>
>>> When we change something again at https://kohaopac.alingsas.se/
>>without
>>> reindexing there is no effect.
>>>
>>> But when we click on Koha logo in the upper left corner of the
>>screen,
>>> which has this address https://kohaopac.alingsas.se/
>>> cgi-bin/koha/opac-main.pl all the changes are updated and shows
>>> immediately.
>>>
>>> It seems as we need reindexing every time we change something at our
>>OPAC
>>> site, to have main address https://kohaopac.alingsas.se/ to work.
>>>
>>> Should we ask our IT to set reindexing for every night or is there
>>any
>>> other sollution to this problem?
>>>
>>>
>>> Best regards
>>> Lukasz Mesek
>>> Vuxenbibliotekarie
>>> Alingsås bibliotek
>>> lukasz.me...@alingsas.se
>>> ___
>>> 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
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
> ___
> 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] Koha 17.05.06 released

2017-11-23 Thread Fridolin SOMERS

The Koha community is proud to announce the release of Koha 17.05.06.

This is a maintainance release.

The full release notes are available at 
https://koha-community.org/koha-17-05-06-release/


17.11 will soon be released so 17.05 will become old-stable branch.

Regards,

--
Fridolin SOMERS 
BibLibre - software and system maintainer
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha