[Koha] 3M self check error information with “Account” option

[Peter Lau]

In one of the options on 3M self check, I can set to display Account 
information.

Under the Account option, when I tried to list my loan record, there’s an error 
message referring me to the counter for help.

Thanks & regards,
Peter Lau
Librarian
Tel: (852) 3977 9868 | Email: peter@yccece.edu.hk | Fax: (852) 23384320 
 

2 Tin Wan Hill Road, Tin Wan, Aberdeen
YCCECE, Here We Grow Our Future | www.yccece.edu.hk
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] OPAC research does not work

[Caroline Cyr-La-Rose]

Hi David,

I didn't notice if someone already answered you.

You need to build your search indexes before being able to find anything 
in the OPAC.


Do you have access to your server?

If you use Zebra (you probably do, but just to make sure, check the 
system preference SearchEngine in Administration > Global system 
preferences), you need to run the script rebuild_zebra.pl on your 
server. The script has the following arguments :


-b to index bibliographic record

-a to index authority records

-r to reset your indexes (this will erase everything and rebuild from zero)

-v for verbose

-z to rebuild only what was changed since the last indexing

So for a first run, I would do ./rebuild_zebra.pl -a -b -r -v

Then you need to add rebuild_zebra in your crontab so that it runs 
regularly (on our servers we run it every minute) . In the crontab, you 
need to use the -a -b and -z arguments.


I hope that makes sense. :)

Good luck!

Caroline

Caroline Cyr La Rose, M.L.I.S.
Product Manager, inLibro

Le 19-02-22 à 12 h 21, Davide Spanu a écrit :

Hello,
I'm having problems configuring Koha. I've uselessly tried solving the issue on 
my own and also browsing forums. After the install I started cataloging, 
inserting titles and texts. However once inserted for some reason they don't 
appear in the OPAC. I can't figure out what I'm doing wrong and need assistance.
Thank you in advance

___
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] Report for items held by 2 out of 3 branches

[Cab Vinton]

Hi, All --

Think the version below should do what we're looking for. (Thank you, Barton!)

All best,

Cab Vinton

SELECT
b.biblionumber,
SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
b.title,
i.homebranch,
i.itemcallnumber
FROM
items i
LEFT JOIN biblioitems m USING (biblioitemnumber)
LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
WHERE
i.itype = 'NEWBOOK'
AND exists(
select * from items where items.itemnumber = i.itemnumber AND
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned
)
GROUP BY
b.biblionumber
HAVING
isbn != ""
AND count(i.homebranch) > 1
ORDER BY rand()
LIMIT 7
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 18.05.09 released

[Michael Kuhn]

Hi Jesse and Lucas

> The Koha community is proud to announce the release of 18.05.09.
>
> This is a maintenance release and contains many bugfixes and
> enhancements.
>
> It includes 3 enhancements, 62 bugfixes.
>
> As always you can download the release from here:
>
> http://download.koha-community.org/koha-18.05.09.tar.gz
> Thank you very much to everyone involved in this release.

Great!

By the way: I found the release notes are available at

https://koha-community.org/koha-18-05-09-release/

(it would be cool if the release notes could always have the same kind 
of URL - the last two release notes of Koha 18.05 had the form 
https://koha-community.org/koha-18-05-09-released/ with a "d" at the 
end, now they are back again without the "d"...)


Best wishes: Michael
--
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Error restoring Koha-Instance

[Alvaro Cornejo]

Hi

It said there is a  Unknown column 'me.damaged_on' ... this usually means
that your DB schema has changed. Probably when updated/upgarded your koha
install.

There is a koha command to upgrade the schema but I don't know if that will
solve the issue on a restore.

Regards

Alvaro



|-|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
  Visitenos en www.perusms.com


Le ven. 22 févr. 2019 à 11:31, Beda Szukics  a
écrit :

> Hi all
>
> I try to restore a koha-instance wiht koha-restore and I get the
> following messages:
>
> error retrieving biblio 1669 at
> /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
> DBD::mysql::st execute failed: Unknown column 'me.damaged_on' in 'field
> list' [for Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`,
> `me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`,
> `me`.`booksellerid`, `me`.`homebranch`, `me`.`price`,
> `me`.`replacementprice`, `me`.`replacementpricedate`,
> `me`.`datelastborrowed`, `me`.`datelastseen`, `me`.`stack`,
> `me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, `me`.`itemlost`,
> `me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`,
> `me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`,
> `me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`,
> `me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`paidfor`,
> `me`.`timestamp`, `me`.`location`, `me`.`permanent_location`,
> `me`.`onloan`, `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`,
> `me`.`materials`, `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`,
> `me`.`enumchron`, `me`.`copynumber`, `me`.`stocknumber`,
> `me`.`new_status` FROM `items` `me` WHERE ( `me`.`itemnumber` = ? )"
> with ParamValues: 0=2262] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm
> line 1836.
>
> Maybe my dump is too old? The one I have is from Juni 2018. Koha is
> 18.11.02.000.
>
> It shows:
> System Maintenance
>
> The Koha online catalog is offline for system maintenance. We'll be back
> soon! If you have any questions, please contact the site administrator
>
> What can I do?
>
> 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

[Koha] OPAC research does not work

[Davide Spanu]

Hello,
I'm having problems configuring Koha. I've uselessly tried solving the issue on 
my own and also browsing forums. After the install I started cataloging, 
inserting titles and texts. However once inserted for some reason they don't 
appear in the OPAC. I can't figure out what I'm doing wrong and need assistance.
Thank you in advance

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

Re: [Koha] Report for items held by 2 out of 3 branches

[Barton Chittenden]

Good point, I removed that logic.

SELECT
b.biblionumber,
SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
b.title,
i.homebranch,
i.itemcallnumber
FROM
items i
LEFT JOIN biblioitems m USING (biblioitemnumber)
LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
WHERE
i.itype = 'NEWBOOK'
AND DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned
GROUP BY
b.biblionumber
HAVING
isbn != ""
AND count(items.homebranch) > 1
ORDER BY rand()
LIMIT 7


On Fri, Feb 22, 2019 at 11:23 AM Cab Vinton  wrote:

> Unless I'm missing the thread somehow, I don't think that will work as
> the prior conditions for all 3 branches are still present in the WHERE
> statement.
>
> If we eliminate those, then we still need to include the acquisition
> date condition somehow.
>
> Thanks,
>
> Cab
>
>
> On Fri, Feb 22, 2019 at 11:11 AM Barton Chittenden
>  wrote:
> >
> > you could add
> >
> > count(distinct homebranch) > 1
> >
> > to your HAVING statement
> >
> > On Fri, Feb 22, 2019 at 9:03 AM Cab Vinton  wrote:
> >>
> >> Hi, All --
> >>
> >> We have a report (see below) that generates a random list of items
> >> held by all 3 of our branches & purchased within the past 30 days.
> >>
> >> To generate more titles we'd like to loosen the criteria by specifying
> >> that the titles should be held by just 2 of the 3 branches.
> >>
> >> I know how I'd approach this outside of Koha's SQL-based reporting
> >> tool, but not sure how to write this without repeating a whole bunch
> >> of code ((A or B) or (A or C) or (B or C)). The code is used to
> >> populate a carousel on our OPAC's home page & it's already a bit
> >> "pokey", so efficient code is an important factor.
> >>
> >> Anyone have suggestions on how best to write this report?
> >>
> >> Many thanks in advance,
> >>
> >> Cab Vinton, Director
> >> Plaistow Public Library
> >> Plaistow, NH
> >> https://catalog.southernnh.bywatersolutions.com
> >>
> >>
> >> SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
> >> b.title, i.homebranch, i.itemcallnumber
> >>   FROM items i
> >>   LEFT JOIN biblioitems m USING (biblioitemnumber)
> >>   LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
> >>   WHERE i.itype = 'NEWBOOK'
> >>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
> >> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
> >> homebranch='KIMBALL')
> >>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
> >> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
> >> homebranch='PLAISTOW')
> >>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
> >> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
> >> homebranch='SANDOWN')
> >>   GROUP BY b.biblionumber
> >>   HAVING isbn != ""
> >>   ORDER BY rand()
> >>   LIMIT 7
> >> ___
> >> 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] Error restoring Koha-Instance

[Beda Szukics]

Hi all

I try to restore a koha-instance wiht koha-restore and I get the
following messages:

error retrieving biblio 1669 at
/usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 680.
DBD::mysql::st execute failed: Unknown column 'me.damaged_on' in 'field
list' [for Statement "SELECT `me`.`itemnumber`, `me`.`biblionumber`,
`me`.`biblioitemnumber`, `me`.`barcode`, `me`.`dateaccessioned`,
`me`.`booksellerid`, `me`.`homebranch`, `me`.`price`,
`me`.`replacementprice`, `me`.`replacementpricedate`,
`me`.`datelastborrowed`, `me`.`datelastseen`, `me`.`stack`,
`me`.`notforloan`, `me`.`damaged`, `me`.`damaged_on`, `me`.`itemlost`,
`me`.`itemlost_on`, `me`.`withdrawn`, `me`.`withdrawn_on`,
`me`.`itemcallnumber`, `me`.`coded_location_qualifier`, `me`.`issues`,
`me`.`renewals`, `me`.`reserves`, `me`.`restricted`, `me`.`itemnotes`,
`me`.`itemnotes_nonpublic`, `me`.`holdingbranch`, `me`.`paidfor`,
`me`.`timestamp`, `me`.`location`, `me`.`permanent_location`,
`me`.`onloan`, `me`.`cn_source`, `me`.`cn_sort`, `me`.`ccode`,
`me`.`materials`, `me`.`uri`, `me`.`itype`, `me`.`more_subfields_xml`,
`me`.`enumchron`, `me`.`copynumber`, `me`.`stocknumber`,
`me`.`new_status` FROM `items` `me` WHERE ( `me`.`itemnumber` = ? )"
with ParamValues: 0=2262] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm
line 1836.

Maybe my dump is too old? The one I have is from Juni 2018. Koha is
18.11.02.000.

It shows:
System Maintenance

The Koha online catalog is offline for system maintenance. We'll be back
soon! If you have any questions, please contact the site administrator

What can I do?

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

Re: [Koha] Report for items held by 2 out of 3 branches

[Cab Vinton]

Unless I'm missing the thread somehow, I don't think that will work as
the prior conditions for all 3 branches are still present in the WHERE
statement.

If we eliminate those, then we still need to include the acquisition
date condition somehow.

Thanks,

Cab


On Fri, Feb 22, 2019 at 11:11 AM Barton Chittenden
 wrote:
>
> you could add
>
> count(distinct homebranch) > 1
>
> to your HAVING statement
>
> On Fri, Feb 22, 2019 at 9:03 AM Cab Vinton  wrote:
>>
>> Hi, All --
>>
>> We have a report (see below) that generates a random list of items
>> held by all 3 of our branches & purchased within the past 30 days.
>>
>> To generate more titles we'd like to loosen the criteria by specifying
>> that the titles should be held by just 2 of the 3 branches.
>>
>> I know how I'd approach this outside of Koha's SQL-based reporting
>> tool, but not sure how to write this without repeating a whole bunch
>> of code ((A or B) or (A or C) or (B or C)). The code is used to
>> populate a carousel on our OPAC's home page & it's already a bit
>> "pokey", so efficient code is an important factor.
>>
>> Anyone have suggestions on how best to write this report?
>>
>> Many thanks in advance,
>>
>> Cab Vinton, Director
>> Plaistow Public Library
>> Plaistow, NH
>> https://catalog.southernnh.bywatersolutions.com
>>
>>
>> SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
>> b.title, i.homebranch, i.itemcallnumber
>>   FROM items i
>>   LEFT JOIN biblioitems m USING (biblioitemnumber)
>>   LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
>>   WHERE i.itype = 'NEWBOOK'
>>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
>> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
>> homebranch='KIMBALL')
>>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
>> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
>> homebranch='PLAISTOW')
>>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
>> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
>> homebranch='SANDOWN')
>>   GROUP BY b.biblionumber
>>   HAVING isbn != ""
>>   ORDER BY rand()
>>   LIMIT 7
>> ___
>> 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 18.05.09 released

[Barton Chittenden]

+1

On Fri, Feb 22, 2019 at 9:29 AM Tomas Cohen Arazi 
wrote:

> Great!
>
> El vie., 22 feb. 2019 a las 11:27, Jesse Maseto (<
> je...@bywatersolutions.com>)
> escribió:
>
> > The Koha community is proud to announce the release of 18.05.09.
> >
> > This is a maintenance release and contains many bugfixes and
> enhancements.
> >
> > It includes 3 enhancements, 62 bugfixes.
> >
> > As always you can download the release from here:
> >
> > http://download.koha-community.org/koha-18.05.09.tar.gz
> > Thank you very much to everyone involved in this release.
> >
> > Best regards,
> > -Jesse and Lucas
> >
> > 
> > Jesse Maseto
> > Dev/Ops Support
> > ByWater Solutions
> > Support & Consulting for OSS
> > Office - Stratford,CT
> > T/F 888.900.8944
> > http://bywatersolutions.com
> > je...@bywatersolutions.com
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
>
>
> --
> Tomás Cohen Arazi
> Theke Solutions (http://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
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report for items held by 2 out of 3 branches

[Barton Chittenden]

you could add

count(distinct homebranch) > 1

to your HAVING statement

On Fri, Feb 22, 2019 at 9:03 AM Cab Vinton  wrote:

> Hi, All --
>
> We have a report (see below) that generates a random list of items
> held by all 3 of our branches & purchased within the past 30 days.
>
> To generate more titles we'd like to loosen the criteria by specifying
> that the titles should be held by just 2 of the 3 branches.
>
> I know how I'd approach this outside of Koha's SQL-based reporting
> tool, but not sure how to write this without repeating a whole bunch
> of code ((A or B) or (A or C) or (B or C)). The code is used to
> populate a carousel on our OPAC's home page & it's already a bit
> "pokey", so efficient code is an important factor.
>
> Anyone have suggestions on how best to write this report?
>
> Many thanks in advance,
>
> Cab Vinton, Director
> Plaistow Public Library
> Plaistow, NH
> https://catalog.southernnh.bywatersolutions.com
>
>
> SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
> b.title, i.homebranch, i.itemcallnumber
>   FROM items i
>   LEFT JOIN biblioitems m USING (biblioitemnumber)
>   LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
>   WHERE i.itype = 'NEWBOOK'
>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
> homebranch='KIMBALL')
>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
> homebranch='PLAISTOW')
>   AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
> DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
> homebranch='SANDOWN')
>   GROUP BY b.biblionumber
>   HAVING isbn != ""
>   ORDER BY rand()
>   LIMIT 7
> ___
> 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 18.05.09 released

[Tomas Cohen Arazi]

Great!

El vie., 22 feb. 2019 a las 11:27, Jesse Maseto ()
escribió:

> The Koha community is proud to announce the release of 18.05.09.
>
> This is a maintenance release and contains many bugfixes and enhancements.
>
> It includes 3 enhancements, 62 bugfixes.
>
> As always you can download the release from here:
>
> http://download.koha-community.org/koha-18.05.09.tar.gz
> Thank you very much to everyone involved in this release.
>
> Best regards,
> -Jesse and Lucas
>
> 
> Jesse Maseto
> Dev/Ops Support
> ByWater Solutions
> Support & Consulting for OSS
> Office - Stratford,CT
> T/F 888.900.8944
> http://bywatersolutions.com
> je...@bywatersolutions.com
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Tomás Cohen Arazi
Theke Solutions (http://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

[Koha] Koha 18.05.09 released

[Jesse Maseto]

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

This is a maintenance release and contains many bugfixes and enhancements.

It includes 3 enhancements, 62 bugfixes.

As always you can download the release from here:

http://download.koha-community.org/koha-18.05.09.tar.gz
Thank you very much to everyone involved in this release.

Best regards,
-Jesse and Lucas


Jesse Maseto
Dev/Ops Support
ByWater Solutions
Support & Consulting for OSS
Office - Stratford,CT
T/F 888.900.8944
http://bywatersolutions.com
je...@bywatersolutions.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report for items held by 2 out of 3 branches

[Cab Vinton]

Hi, All --

We have a report (see below) that generates a random list of items
held by all 3 of our branches & purchased within the past 30 days.

To generate more titles we'd like to loosen the criteria by specifying
that the titles should be held by just 2 of the 3 branches.

I know how I'd approach this outside of Koha's SQL-based reporting
tool, but not sure how to write this without repeating a whole bunch
of code ((A or B) or (A or C) or (B or C)). The code is used to
populate a carousel on our OPAC's home page & it's already a bit
"pokey", so efficient code is an important factor.

Anyone have suggestions on how best to write this report?

Many thanks in advance,

Cab Vinton, Director
Plaistow Public Library
Plaistow, NH
https://catalog.southernnh.bywatersolutions.com


SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn,
b.title, i.homebranch, i.itemcallnumber
  FROM items i
  LEFT JOIN biblioitems m USING (biblioitemnumber)
  LEFT JOIN biblio b ON i.biblionumber = b.biblionumber
  WHERE i.itype = 'NEWBOOK'
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='KIMBALL')
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='PLAISTOW')
  AND b.biblionumber IN (SELECT biblionumber FROM items WHERE
DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND
homebranch='SANDOWN')
  GROUP BY b.biblionumber
  HAVING isbn != ""
  ORDER BY rand()
  LIMIT 7
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha 18.11.03 release

[Renvoize, Martin]

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

This is a maintenance release.

The full release notes are available at
https://koha-community.org/koha-18-11-03-release/

Debian packages will be uploaded in a few days.

Best regards and thanks to all those who have contributed to this release.

*Martin Renvoize*



Development Team Manager





*Phone:* +44 (0) 1483 378728

*Mobile:* +44 (0) 7725 985 636

*Email:* martin.renvo...@ptfs-europe.com

*Fax:* +44 (0) 800 756 6384


www.ptfs-europe.com







Registered in the United Kingdom No. 06416372   VAT Reg No. 925 7211 30

The information contained in this email message may be privileged,
confidential and protected from disclosure. If you are not the intended
recipient, any dissemination, distribution or copying is strictly
prohibited. If you think that you have received this email message in
error, please email the sender at i...@ptfs-europe.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] z39.50 search does not return results

[Sebastian Krieg]

Hi Hauke,

ich hatte das gleiche Problem zweimal in der Vergangenheit und ebenfalls keine 
Hinweise auf Fehlermeldungen in den Logfiles. Ich vermute jetzt auch noch 
irgendein Rechteproblem oder eine Inkosistenz durch ein Softwareupdate im 
Perl-Umfeld.

Versuche mal, ob eine "händische Suche" per yaz-client auf der Konsole 
funktioniert (https://wiki.koha-community.org/wiki/Troubleshooting_Zebra, 
Abschnitt "Manually searching with yaz-client". Bei mir haben diese Suchen 
immer funktioniert.

Letztendlich konnte mir hier niemand helfen, ich habe dann, durch eine neue 
Perl-Version bedingt, koha neu installiert und dann ging es komischerweise 
wieder.

Gruß

Sebastian

> Hauke Altmann mailto:ha...@haukepauke.de > hat am 22. 
> Februar 2019 um 13:43 geschrieben:
> 
> 
> Hey there,
> 
> I have another issue after moving Koha to a new server:
> 
> The Z39.50/SRU search is no longer returning results
> (/cgi-bin/koha/cataloguing/z3950_search.pl). Settings are the same as on
> the old system, where everything works fine. There are no indications of
> errors in the logs.
> 
> Can anyone give me an idea, where to look for a solution of the problem?
> Is there an option to make Koha more talkative to get an idea what
> causes this problem?
> 
> Thanks for any help,
> 
> Hauke
> 
> 
> ___
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz mailto: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] z39.50 search does not return results

[Hauke Altmann]

Hey there,

I have another issue after moving Koha to a new server:

The Z39.50/SRU search is no longer returning results
(/cgi-bin/koha/cataloguing/z3950_search.pl). Settings are the same as on
the old system, where everything works fine. There are no indications of
errors in the logs.

Can anyone give me an idea, where to look for a solution of the problem?
Is there an option to make Koha more talkative to get an idea what
causes this problem?

Thanks for any help,

Hauke


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