Re: [Koha] Koha upgrade from 17.11 to 18.05

[takan bhatt]

It is working under Debian 9. I also upgraded. Thanks Koha Team.

On Tue, May 29, 2018 at 6:39 AM, Father Vlasie  wrote:

> I used apt-get rather than apt:
>
> apt-get update
> apt-get upgrade
> apt-get install koha-common
>
> That is what worked for me on Debian 9.
>
> It may be superstition but I do not trust apt without the get!
>
> Hoping this helps,
>
> Father Vlasie
>
> St. Photios Orthodox Theological Seminary
> 510 Collier Way, Etna, CA 96027, U.S.A.
>
> Website: www.spots.school
>
>
>
> > On 28 May 2018, at 07:32, koha-requ...@lists.katipo.co.nz wrote:
> >
> > Date: Mon, 28 May 2018 10:25:11 +0200
> > From: Narcis Garcia mailto:informat...@actiu.net
> >>
> > To: koha@lists.katipo.co.nz 
> > Subject: Re: [Koha] Koha upgrade from 17.11 to 18.05
> > Message-ID:  bc0f9293-745d-8846-fc10-37c7fb3c0...@actiu.net>>
> > Content-Type: text/plain; charset=utf-8
> >
> > This rare method (no apt upgrade), is not working for me in Debian 9 +
> > Koha 17.11 :
> >
> > $ sudo apt install koha-common
> > Reading package lists... Done
> > Building dependency tree
> > Reading state information... Done
> > Some packages could not be installed. This may mean that you have
> > requested an impossible situation or if you are using the unstable
> > distribution that some required packages have not yet been created
> > or been moved out of Incoming.
> > The following information may help to resolve the situation:
> >
> > The following packages have unmet dependencies:
> > koha-common : Depends: libnet-oauth2-authorizationserver-perl but it is
> > not going to be installed
> > E: Unable to correct problems, you have held broken packages.
> >
> > When I try normal method; any of:
> > apt upgrade
> > apt full-upgrade
> > apt-get upgrade
> > apt-get dist-upgrade
> > ; general packages can't be upgraded without uninstalling koha-common
>
> ___
> 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] percent of reindexing

[Arayik Manukyan]

Hi List,

We have 200 records in Koha  17.11.04.

When we reindexing zebra we only can see  the number of exported  records,

but we want to see the percent of reindexing too. 

How can we do it ?

Thanks,

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

Re: [Koha] Listing all biblio records

[Father Vlasie]

Dear Ah Win,

The SQL examples from this page: 
https://wiki.koha-community.org/wiki/SQL_Reports_Library 


Can be copied and pasted into the custom SQL reports in Home › Reports 
(your-koha-install/cgi-bin/koha/reports/reports-home.pl)

1) Copy the SQL from the sample

2) On the Reports page choose + Create from SQL

3) Enter a name for the report

4) Paste in the sample in the SQL box and click Save.

5) Click Saved Reports in the left hand column

6) Click Run on the report you would like.

Let us know if it works.

Father Vlasie

St. Photios Orthodox Theological Seminary
510 Collier Way, Etna, CA 96027, U.S.A.

Website: www.spots.school


> On 28 May 2018, at 20:29, Ah Win  wrote:
> 
> Dear Indranil,
> 
> I am new to the list and librarian from Myanmar.
> 
> Please help me the way if we are not handy with SQL.
> For both import and export, please.
> 
> Many thanks.
> Ah Win
> 
> 
> 
> 
> 
> 
> On 27 May 2018 at 03:37, Indranil Das Gupta  > wrote:
> On Sun 27 May, 2018, 2:33 AM Father Vlasie,  wrote:
> 
> > Hello everyone,
> >
> > Is there an easy way to export a list of all items in a Koha database?
> >
> 
> If you are handy with SQL, take a look at
> https://wiki.koha-community.org/wiki/SQL_Reports_Library 
> 
> 
> Particularly at the section Bibliographic / Catalogue reports.
> 
> 
> 
> > TIA
> > FV
> > ___
> > 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] Listing all biblio records

[Ah Win]

Dear Indranil,

I am new to the list and librarian from Myanmar.

Please help me the way if we are not handy with SQL.
For both import and export, please.

Many thanks.
Ah Win






On 27 May 2018 at 03:37, Indranil Das Gupta  wrote:

> On Sun 27 May, 2018, 2:33 AM Father Vlasie,  wrote:
>
> > Hello everyone,
> >
> > Is there an easy way to export a list of all items in a Koha database?
> >
>
> If you are handy with SQL, take a look at
> https://wiki.koha-community.org/wiki/SQL_Reports_Library
>
> Particularly at the section Bibliographic / Catalogue reports.
>
>
>
> > TIA
> > FV
> > ___
> > 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] Koha upgrade from 17.11 to 18.05

[Father Vlasie]

I used apt-get rather than apt:

apt-get update
apt-get upgrade
apt-get install koha-common

That is what worked for me on Debian 9.

It may be superstition but I do not trust apt without the get!

Hoping this helps,

Father Vlasie

St. Photios Orthodox Theological Seminary
510 Collier Way, Etna, CA 96027, U.S.A.

Website: www.spots.school



> On 28 May 2018, at 07:32, koha-requ...@lists.katipo.co.nz wrote:
> 
> Date: Mon, 28 May 2018 10:25:11 +0200
> From: Narcis Garcia mailto:informat...@actiu.net>>
> To: koha@lists.katipo.co.nz 
> Subject: Re: [Koha] Koha upgrade from 17.11 to 18.05
> Message-ID:  >
> Content-Type: text/plain; charset=utf-8
> 
> This rare method (no apt upgrade), is not working for me in Debian 9 +
> Koha 17.11 :
> 
> $ sudo apt install koha-common
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> Some packages could not be installed. This may mean that you have
> requested an impossible situation or if you are using the unstable
> distribution that some required packages have not yet been created
> or been moved out of Incoming.
> The following information may help to resolve the situation:
> 
> The following packages have unmet dependencies:
> koha-common : Depends: libnet-oauth2-authorizationserver-perl but it is
> not going to be installed
> E: Unable to correct problems, you have held broken packages.
> 
> When I try normal method; any of:
> apt upgrade
> apt full-upgrade
> apt-get upgrade
> apt-get dist-upgrade
> ; general packages can't be upgraded without uninstalling koha-common

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

[Koha] Fwd: OPAC Page not available and login credentials don't work

[Bedanta Borah]

From: Bedanta Borah 
Date: Mon, May 28, 2018 at 10:42 AM
Subject: OPAC Page not available and login credentials don't work
To: koha-requ...@lists.katipo.co.nz


Hello there. My name is Bedanta. I am currently using Virtualbox to install
Koha on Ubuntu 18.04 and Koha liveDVD. I have faced problems in both
installations.

1) In case of Ubuntu,  I have installed Koha using instructions given in
this page (  https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages
). The Staff Login page works fine and I can use all the library functions.
But the OPAC Page doesn't appear. All that appears is the Apache home page.
# Staff Client : 127.0.1.1:8080 or 127.0.0.1:8080
#  Instead of OPAC Page, the apache home page appears in
the these addresses  :  127.0.1.1  or   127.0.0.1

Q) How can I manage to appear the OPAC Page?


2) In case of  koha livedvd, all features were doing fine untill I updated
the system and the koha-common packages. After the update, my root user and
password (koha_library & koha123) stopped working. But I can login with
another patron which I had created before the update was done. Why I loose
database user access after updating the software?

Q) How can I regain the database user access?

Please help me with the above two queries. Thank you.


Yours faithfully
Bedanta
Nagaon, Assam, India
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL query on number of days to get a book

[Katrin Fischer]

Thank you for sharing your reports! Maybe you'd like to add them to the 
reports library on the wiki too?


https://wiki.koha-community.org/wiki/SQL_Reports_Library

Katrin


On 28.05.2018 16:25, Suresh Kumar Tejomurtula wrote:

Hi,

Query on orders(books) which are received in library and an email is
triggered to members. This report may be useful in calculating number of
days we are taking to get a suggested book. Here iam considering mail sent
to a member as a value for calculating the number of days taken to get a
book.


SELECT aqorders.ordernumber,
aqorders.biblionumber,aqorders.datereceived,aqorders.basketno,
biblio.title,biblio.author,
items.barcode,suggestions.date,
suggestions.suggesteddate,
message_queue.time_queued,(TO_DAYS(message_queue.time_queued)-TO_DAYS(suggestions.suggesteddate))
as days
FROM aqorders
LEFT JOIN biblio on (aqorders.biblionumber=biblio.biblionumber)
LEFT JOIN items on (biblio.biblionumber=items.biblionumber)
LEFT JOIN suggestions on (suggestions.biblionumber=items.biblionumber)
LEFT JOIN borrowers on (borrowers.borrowernumber=suggestions.suggestedby)
LEFT JOIN message_queue on
(message_queue.borrowernumber=suggestions.suggestedby)
where suggestions.status='Available' and items.itype='BK'
GROUP by suggestions.title

Hope this is useful for other members.


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

Re: [Koha] 18.05.00 - do not upgrade if itemtype defined at biblio level

[Michael Kuhn]

Hi Hector

> Hi Michael, I have this as biblio record, can I change it to "specific
> item"?

I would assume so. If you're not sure what setting is correct for you, 
the manual may help:


https://koha-community.org/manual/18.05/en/html/02_administration.html#item-level-itypes

> Is there a procedure to do that?

Koha system preferences can directly be changed as a Koha user with 
superlibrarian rights. You'll find this preference in in Koha ,menu 
"Administration > Global system preferences > Cataloging > Record 
Structure".


> I don't remember changing this preference, is it the default?

The default in Koha 18.05 is "specific item".

Hope that helps.

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] 18.05.00 - do not upgrade if itemtype defined at biblio level

[Hector Gonzalez]

Hi Michael, I have this as biblio record, can I change it to "specific 
item"?  Is there a procedure to do that?


I don't remember changing this preference, is it the default?


On 05/28/2018 10:17 AM, Michael Kuhn wrote:

Hi Narcis

Am 28.05.2018 um 17:11 schrieb Narcis Garcia:
> How can I check if my Koha instance is affected?

Check if your Koha system preference "item-level_itypes" is set to 
"biblio record" (affected) or "specific item" (not affected).


Hope this helps.

Best wishes: Michael


--
Héctor González
ca...@genac.org

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

Re: [Koha] To whom it may concern: Introducing Koha 18.05

[Jonathan Druart]

We usually wait for .01 or .02 to update it.

On Mon, 28 May 2018 at 12:37 Michael Kuhn  wrote:

> Hi
>
> To whom it may concern: The webpage https://koha-community.org/ still
> says "Introducing Koha 17.11" instead of "Introducing Koha 18.05".
>
> 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 <+41%2061%20261%2055%2061> · 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
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] To whom it may concern: Introducing Koha 18.05

[Michael Kuhn]

Hi

To whom it may concern: The webpage https://koha-community.org/ still 
says "Introducing Koha 17.11" instead of "Introducing Koha 18.05".


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] 18.05.00 - do not upgrade if itemtype defined at biblio level

[Michael Kuhn]

Hi Narcis

Am 28.05.2018 um 17:11 schrieb Narcis Garcia:
> How can I check if my Koha instance is affected?

Check if your Koha system preference "item-level_itypes" is set to 
"biblio record" (affected) or "specific item" (not affected).


Hope this helps.

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] 18.05.00 - do not upgrade if itemtype defined at biblio level

[Narcis Garcia]

How can I check if my Koha instance is affected?


El 28/05/18 a les 16:31, Jonathan Druart ha escrit:
> Hi all,
> 
> A critical bug has been found in 18.05.00 (bug 20825).
> If item types are defined at biblio level (item-level_itypes=biblio), you
> should *not* upgrade to 18.05.00.
> 
> Sorry about that.
> 
> Regards,
> Jonathan
> 
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20825
> ___
> 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] 18.05.00 - do not upgrade if itemtype defined at biblio level

[Jonathan Druart]

Hi all,

A critical bug has been found in 18.05.00 (bug 20825).
If item types are defined at biblio level (item-level_itypes=biblio), you
should *not* upgrade to 18.05.00.

Sorry about that.

Regards,
Jonathan

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

[Koha] SQL query on number of days to get a book

[Suresh Kumar Tejomurtula]

Hi,

Query on orders(books) which are received in library and an email is
triggered to members. This report may be useful in calculating number of
days we are taking to get a suggested book. Here iam considering mail sent
to a member as a value for calculating the number of days taken to get a
book.


SELECT aqorders.ordernumber,
aqorders.biblionumber,aqorders.datereceived,aqorders.basketno,
biblio.title,biblio.author,
items.barcode,suggestions.date,
suggestions.suggesteddate,
message_queue.time_queued,(TO_DAYS(message_queue.time_queued)-TO_DAYS(suggestions.suggesteddate))
as days
FROM aqorders
LEFT JOIN biblio on (aqorders.biblionumber=biblio.biblionumber)
LEFT JOIN items on (biblio.biblionumber=items.biblionumber)
LEFT JOIN suggestions on (suggestions.biblionumber=items.biblionumber)
LEFT JOIN borrowers on (borrowers.borrowernumber=suggestions.suggestedby)
LEFT JOIN message_queue on
(message_queue.borrowernumber=suggestions.suggestedby)
where suggestions.status='Available' and items.itype='BK'
GROUP by suggestions.title

Hope this is useful for other members.
-- 
Regards
T. Suresh Kumar
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] MySQL query for serials late issues

[Suresh Kumar Tejomurtula]

Hi,

Below is my updated version of serials query for finding late issues based
on the already existing query in koha sql reports library.
Hope is it useful for other members.

SELECT @kp:=@kp+1 as S_No,serial.serialseq,
DATE_FORMAT(serial.planneddate, "%d %b %Y" ) as Planneddate,
DATE_FORMAT(subscription.startdate, "%d %b %Y" ) as Startdate,
DATE_FORMAT(serial.publisheddate, "%d %b %Y" ) as publisheddate,
biblio.title,
CASE WHEN serial.status = '3' or serial.status = '7' THEN 'LATE'
WHEN serial.status = '1' THEN 'EXPECTED'
END  AS STATUS,
CASE WHEN subscription.periodicity = '4' THEN 'Weekly'
WHEN subscription.periodicity = '5' THEN 'Fortnightly'
WHEN subscription.periodicity = '7' THEN 'Monthly'
WHEN subscription.periodicity = '8' THEN 'Bi-Monthly'
WHEN subscription.periodicity = '9' THEN 'Quarterly'
WHEN subscription.periodicity = '10' THEN 'Semi-Annual'
WHEN subscription.periodicity = '13' THEN 'Irregular'
END as Frequency,
CASE WHEN subscription.periodicity = '4' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>7 THEN 'Late'
WHEN subscription.periodicity = '4' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))<7 THEN 'Expected'
WHEN subscription.periodicity = '5' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>14 THEN 'Late'
WHEN subscription.periodicity = '5' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))<14 THEN 'Expected'
WHEN subscription.periodicity = '7' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>30 THEN 'Late'
WHEN subscription.periodicity = '7' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))<30 THEN 'Expected'
WHEN subscription.periodicity = '7' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>30 THEN 'Late'
WHEN subscription.periodicity = '9' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))<90 THEN 'Expected'
WHEN subscription.periodicity = '9' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>90 THEN 'Late'
WHEN subscription.periodicity = '10' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>180 THEN 'Late'
WHEN subscription.periodicity = '10' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))<180 THEN 'Expected'
WHEN subscription.periodicity = '13' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))>30 THEN 'Late'
WHEN subscription.periodicity = '13' and (TO_DAYS(curdate())-TO_DAYS(
publisheddate))<30 THEN 'Expected'
END as Status_calculated,
DATE_FORMAT(subscription.enddate, "%d %b %Y" ) as enddate,
(TO_DAYS(curdate())-TO_DAYS( publisheddate)) AS 'Delay Days',
left(aqbasket.basketname,7)) as PONumber,
CASE WHEN subscription.aqbooksellerid = 'xx' THEN 'Vendor1'
WHEN subscription.aqbooksellerid = 'XX' THEN 'Vendor2'
END as Vendor
FROM serial
LEFT JOIN serialitems on (serial.serialid=serialitems.serialid)
LEFT JOIN subscription on
(serial.subscriptionid=subscription.subscriptionid)
LEFT JOIN subscriptionhistory on
(serial.subscriptionid=subscriptionhistory.subscriptionid)
LEFT JOIN subscriptionroutinglist on
(serial.subscriptionid=subscriptionroutinglist.subscriptionid)
LEFT JOIN biblioitems on (biblioitems.biblionumber=serial.biblionumber)
LEFT JOIN biblio on (biblio.biblionumber=biblioitems.biblionumber)
LEFT JOIN aqbooksellers on (subscription.aqbooksellerid=aqbooksellers.id)
LEFT JOIN aqbasket on (subscription.aqbooksellerid=aqbasket.booksellerid),
(select @kp:= 0) AS kp
WHERE serial.planneddate < CURDATE() AND serial.STATUS NOT IN
('2','5','8','42','7') and
(serial.planneddate>=subscription.startdate and
serial.planneddate<=subscription.enddate) and subscription.closed='0'
order by biblio.title

-- 
Regards
T. Suresh Kumar
___
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.00 Debian package released

[Mirko Tietgen]

This may be the result of some local apt configuration. It works for
me (and others) with default configuration.

What you could do is
- make a backup (!!!)
- upgrade, allow koha-common and libhttp-oai-perl to be removed
- if koha-common 18.05 is not installed automatically afterwards,
install koha-common (18.05) again

Unless you remove with --purge, your installation should still work
and your Koha DB should be upgraded like normal. But as I said, make
a backup first.

HTH,

Mirko



Narcis Garcia schrieb am 25.05.2018
> El 25/05/18 a les 11:22, Mirko Tietgen ha escrit:
>> thanks a lot for your feedback. I understand you are on 17.11.06 and
>> then try to upgrade to 18.05.00, is that correct?
> 
> Correct.
> 
>>
>> Narcis Garcia schrieb am 25.05.2018
>>> *The following packages will be REMOVED:**
>>> **  koha-common libhttp-oai-perl*
>>
>> This indicates there is a problem with libhttp-oai-perl. The version
>> in Stretch (4.03) is broken. To provide the OAI functionality of
>> Koha, there is a backported version libhttp-oai-3.27-perl for
>> systems that ship libhttp-oai-perl 4.x. This version conflicts with
>> the systems libhttp-oai-perl.
>>
>> However I can't reproduce the problem. On upgrade I get warnings,
>> but libhttp-oai-3.27-perl is installed and Koha is upgraded.
>>
>> Could you share the output of
>>
>> apt-cache policy koha-common
> 
> koha-common:
>   Installed: 17.11.06-1
>   Candidate: 18.05.00-1
>   Version table:
>  18.05.00-1 500
> 500 http://debian.koha-community.org/koha stable/main i386 Packages
>  *** 17.11.06-1 100
> 100 /var/lib/dpkg/status
> 
>> apt-cache policy libhttp-oai-perl
> 
> libhttp-oai-perl:
>   Installed: 4.03-2
>   Candidate: 4.03-2
>   Version table:
>  *** 4.03-2 500
> 500 http://mirrors.ircam.fr/pub/debian stretch/main i386 Packages
> 100 /var/lib/dpkg/status
> 
>> apt-cache policy libhttp-oai-3.27-perl
> 
> libhttp-oai-3.27-perl:
>   Installed: (none)
>   Candidate: 3.27-1~koha+1
>   Version table:
>  3.27-1~koha+1 500
> 500 http://debian.koha-community.org/koha stable/main i386 Packages
> ___
> 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 upgrade from 17.11 to 18.05

[Narcis Garcia]

This rare method (no apt upgrade), is not working for me in Debian 9 +
Koha 17.11 :

$ sudo apt install koha-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 koha-common : Depends: libnet-oauth2-authorizationserver-perl but it is
not going to be installed
E: Unable to correct problems, you have held broken packages.

When I try normal method; any of:
apt upgrade
apt full-upgrade
apt-get upgrade
apt-get dist-upgrade
; general packages can't be upgraded without uninstalling koha-common


El 26/05/18 a les 23:00, Father Vlasie ha escrit:
> I found out how to do it.
> 
> The method was listed in the Ubuntu install instructions:
> 
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Instructions
> 
> I like answering my own questions, it gives me a sense of progress. :)
> 
> FV
> ___
> 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