Re: [Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

It working, Thanks you Jonathan and all supports 🙏. On Wed, 7 Jun 2023, 12:48 pm Jonathan Druart, < jonathan.dru...@bugs.koha-community.org> wrote: > Hey, put a proper key there! Not "__ENCRYPTION_KEY__"! > It can be generated using the following command `pwgen 32` > > Le mer. 7 juin 2023 à 07:41

Re: [Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

Hey, put a proper key there! Not "__ENCRYPTION_KEY__"! It can be generated using the following command `pwgen 32` Le mer. 7 juin 2023 à 07:41, Сычев Игорь Алексеевич a écrit : > Hi! > > I added the lines: > > __ENCRYPTION_KEY__ > > The update went through without a problem. > > https://github

Re: [Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

Hi! I added the lines: __ENCRYPTION_KEY__ The update went through without a problem. https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml Good Luck! Igor A. Sychev Tomsk Polytechnic University https://lib.tpu.ru ___ Koha mailing

Re: [Koha] koha-upgrade-schema

Hi, I've reported the problem on bug 30649. You should edit the $KOHA_CONF file and add a new encryption_key entry with a key (that can be generated with `pwgen 32`). Le lun. 5 juin 2023 à 05:47, Сычев Игорь Алексеевич a écrit : > Hello! > > Koha 23.05 > After the update. > How to fix the error?

Re: [Koha] Koha upgrade error

hi folks the new package should fix this problem 🎁 On 30/05/23 12:23 am, Tomas Cohen Arazi wrote: We are about to roll a new package with that fixed. Thanks for reporting. El lun, 29 may 2023 a las 8:11, Daniel F. Twum () escribió: Upgrade to 22.11.05.010 [10:48:17]: Bug 3348

Re: [Koha] Koha upgrade error

We are about to roll a new package with that fixed. Thanks for reporting. El lun, 29 may 2023 a las 8:11, Daniel F. Twum () escribió: > > > > > > > Upgrade to 22.11.05.010 [10:48:17]: Bug 33489 - Add indices to > default patron search fields > ERROR: {UNKNOWN}: DBI Exception: DBD:

Re: [Koha] KOHA upgrade from V20.05 to V22.11 (Browse by last name error)

This has been raised on IRC yesterday, please have a look at the log: https://irc.koha-community.org/koha/2023-04-26#i_2483964 The problem is some borrowers.date_renewed that would be -00-00 Le mer. 26 avr. 2023 à 06:09, zen zenitram a écrit : > > Hello > > I finished upgrading koha version 2

Re: [Koha] KOHA Upgrade fails from v20.05 to v22.11

Hi, all I found was your bug report :( *Bug 32762* - Duplicate entry '10434' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 Maybe someone else has an idea? Katrin On 13.03.23 06:16, zen zenitram wrote: Good

Re: [Koha] KOHA upgrade error

Hi, I believe it's probably the same error here: *Bug 32762* - Duplicate entry '10434' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 739 Unfortunately, I doesn't have a fix or solution yet. Hope that helps, Katr

Re: [Koha] Koha upgrade error from 1905 to 21.11

Hi Thanks for the reply. I had asked today on IRC as well and had got answer from mtj and could solve the error. Thanks for your reply. reg Sunita Barve On Thu, Sep 15, 2022 at 3:39 PM Mason James wrote: > hi Sunita > you seem to have a problem with OpenAPI, perhaps installed via CPAN? > >

Re: [Koha] Koha upgrade error from 1905 to 21.11

hi Sunita you seem to have a problem with OpenAPI, perhaps installed via CPAN? follow this guide... https://wiki.koha-community.org/wiki/REST_API_Debug take a look at the following section   1.4 Check 3 API packages are not installed via CPAN On 14/09/22 11:01 pm, Sunita Barve wrote: I want

Re: [Koha] Koha upgrade error from 1905 to 21.11

Hello issuingrules table do not exist and it has been replaced with circulation_rules in new versions On Wed, 14 Sep, 2022, 16:32 Sunita Barve, wrote: > I wanted to upgrade my koha to latest version. > While upgrading when I ran upgrade directly it threw error hence ?I tried > upgrading from 1

Re: [Koha] Koha upgrade schema issue

This is fixed in 22.05.03, see https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899 Le 19/07/2022 à 00:42, Katrin Fischer a écrit : Hi, what error did you get? Katrin On 19.07.22 10:56, Sami M. Rasheed wrote: Kindly, Koha Group Please let me know how to correct the Koha upgrade

Re: [Koha] Koha upgrade schema issue

Hi Sami, this is just feedback about a database update that has been run, not an error. The only thing strange about it is that it's a DEV update and not a regular one. Which exact version did you update to? (21.11.?) Hope this helps, Katrin On 20.07.22 06:55, Sami M. Rasheed wrote: Dear K

Re: [Koha] Koha upgrade schema issue

Hi, what error did you get? Katrin On 19.07.22 10:56, Sami M. Rasheed wrote: Kindly, Koha Group Please let me know how to correct the Koha upgrade schema issue. The system displays the following error while I'm using the (koha-upgrade-schema library) to upgrade the Koha system: DEV atomi

Re: [Koha] Koha Upgrade Error 21.11

Ah good idea :D Le 04/03/2022 à 18:10, Mason James a écrit : hi folks i added a test for this problem here...  https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19169 On 5/03/22 8:05 am, Fridolin SOMERS wrote: Ohhh good catch DEV atomic updates should not exist in releases. I've a

Re: [Koha] Koha Upgrade Error 21.11

hi folks i added a test for this problem here...  https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19169 On 5/03/22 8:05 am, Fridolin SOMERS wrote: Ohhh good catch DEV atomic updates should not exist in releases. I've added a comment on Bug report : https://bugs.koha-community.org/b

Re: [Koha] Koha Upgrade Error 21.11

Ohhh good catch DEV atomic updates should not exist in releases. I've added a comment on Bug report : https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29596#c16 Best regards, Le 03/03/2022 à 21:28, Chief Librarian, SAIACS a écrit : Hi Friends I was testing koha (on ubuntu 20.04) upgr

Re: [Koha] Koha upgrade from 3.2 to 19.05

Hello Walid, It should be as simple as: - Backup your DB - Create a new Koha installation using the debian packages - Restore the DB dump - Login and execute the upgrade using the web interface Regards, Jonathan Le jeu. 22 août 2019 à 09:44, Sultan Qaboos Cultural Center Library a écrit : > > H

Re: [Koha] Koha upgrade from 3.20.00.000 (2015) to any latest and stable version

Hello, I just migrated a 3.20 installation to the latest version (I think it is 19.05?). Here is what I did: * Backup of the Koha database, from the 3.20 installation. * New Server, where i was going to deploy the new installation. * Install Koha on the new server, with the latest version. I made

Re: [Koha] Koha upgrade from 3.20.00.000 (2015) to any latest and stable version

Hi > Another thing, what are the Koha 18.11 new features comparing with the > Koha 3.20.00? You will find them reading through the release notes since Koha 3.22: * https://koha-community.org/koha-3-22-released/ * https://koha-community.org/koha-16-05-released/ * https://koha-community.org/koha-

Re: [Koha] Koha upgrade from 3.20.00.000 (2015) to any latest and stable version

Thank you for your quick response. Another thing, what are the Koha 18.11 new features comparing with the Koha 3.20.00 ? Best, Walid On Mon, Aug 26, 2019 at 10:23 AM Tomas Cohen Arazi wrote: > You should be able to upgrade directly into the latest 18.11 version. > I suggest you follow the inst

Re: [Koha] Koha upgrade from 3.20.00.000 (2015) to any latest and stable version

You should be able to upgrade directly into the latest 18.11 version. I suggest you follow the instructions in the Wiki [1]. I suggest you do it on a clean server, and take notes on possible errors you might get in the process. Deal with those, and then proceed to a final migration. Kind regards

Re: [Koha] Koha upgrade from 3.2 to 19.05

UP ! On Thu, Aug 22, 2019 at 9:59 AM Sultan Qaboos Cultural Center Library < libr...@sqcc.org> wrote: > Dear Joel, > > Thank you for your quick answer ! Do you have any tutorials/links to > suggest me to make the upgrade successful ? > > Best, > Walid > > On Thu, Aug 22, 2019 at 9:52 AM Coehoorn,

Re: [Koha] Koha upgrade from 3.2 to 19.05

Dear Joel, Thank you for your quick answer ! Do you have any tutorials/links to suggest me to make the upgrade successful ? Best, Walid On Thu, Aug 22, 2019 at 9:52 AM Coehoorn, Joel wrote: > 3.2 is **very** old now... going back to at least 2012 if not further. > > Koha is designed to be upda

Re: [Koha] Koha upgrade from 3.2 to 19.05

Version 3.20 On Thu, Aug 22, 2019 at 9:53 AM Indranil Das Gupta wrote: > Hi, > > On Thu 22 Aug, 2019, 7:16 PM Sultan Qaboos Cultural Center Library, < > libr...@sqcc.org> wrote: > >> Hello, >> >> Our library is planning to upgrade Koha from the version 3.2 to 19.05 >> (latest). >> > > Just a qui

Re: [Koha] Koha upgrade from 3.2 to 19.05

Hi, On Thu 22 Aug, 2019, 7:16 PM Sultan Qaboos Cultural Center Library, < libr...@sqcc.org> wrote: > Hello, > > Our library is planning to upgrade Koha from the version 3.2 to 19.05 > (latest). > Just a quick query : 3.02 or 3.20 ? Cheers Indranil Das Gupta L2C2 Technologies ___

Re: [Koha] Koha upgrade from 3.2 to 19.05

3.2 is **very** old now... going back to at least 2012 if not further. Koha is designed to be updated in place, in smaller increments at a time. You will find this larger jump exceedingly difficult. It will almost certainly break things for you, but going back that far it's impossible for me to sa

Re: [Koha] Koha Upgrade

See bug 20826 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20826 On Thu, 20 Sep 2018 at 07:07 Ashok Francis wrote: > Dear All, > > I am running koha17.05.04 on Lubuntu i386. WHen I try to upgrade koha, I am > getting the following error. Can you please help me what is missing here?

Re: [Koha] Koha upgrade from 17.11 to 18.05

Hi, The same error reported for me on L-Ubuntu 16.04 Desktop today. I have changed stable to oldstable (ie, 17.11) in /etc/apt/sources.list.d/koha.list and this works for installing koha-common successfuly. Is it with OS Package problem or Package related to current Koha Stable Version (18.05)

Re: [Koha] Koha upgrade from 17.11 to 18.05

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 <mailto:koha@lists.katipo.co.nz> > > Subject: Re: [Koha] Koha upgrade from 17.1

Re: [Koha] Koha upgrade from 17.11 to 18.05

, 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 <mailto:koha@lists.katipo.co.nz>

Re: [Koha] Koha upgrade from 17.11 to 18.05

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 situ

Re: [Koha] Koha upgrade from 17.11 to 18.05

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

Re: [Koha] Koha upgrade issues - from Koha 3.12 to Koha 17.11

It is quite possible that update had already been processed through some fix in your 3.12.x sub-version. Having done quite a few upgrades over the years, I don't remember one where I didn't get one update error or another.  But always there was a logical explanation, and the end result was per

Re: [Koha] Koha upgrade issues - from Koha 3.12 to Koha 17.11

​Thanks for your feedback. Please see below the errors from updatedatabase.pl Regards, Sekhar Mallampati +++ Updating database structure Update report : - Status: 500 - Content-type: text/html - - Software error: - DBD::mysql::db do failed: Ca

Re: [Koha] Koha upgrade issues - from Koha 3.12 to Koha 17.11

Hi Sekhar, Upgrading from 3.12 is usually ok.   Could you detail the errors you encounter? Exporting/importing the biblios also theoratically works fine, but some versions have had glitches preventing it.  Still, updatedatabase.pl should work unless you have customized the DB. Philippe Bl

Re: [Koha] Koha upgrade from 3.16 to 16.11

Hey Jonathan, Hey Hugo, we also have trouble in 16.11 with tax calculation : mysql> select unitprice_tax_excluded, unitprice_tax_included from aqorders join aqinvoices on aqinvoices.invoiceid = aqorders.invoiceid where aqinvoices.invoiceid = 2674 limit 10; ++--

Re: [Koha] Koha upgrade from 3.16 to 16.11

Nick did open one, there is a patch to signoff, see bug 18471. On Thu, 20 Apr 2017 at 11:38 Jonathan Druart < jonathan.dru...@bugs.koha-community.org> wrote: > Yes indeed, the formatting should be done template side. > They are the only 2 occurrences of this kind apparently. > Did you open a bug

Re: [Koha] Koha upgrade from 3.16 to 16.11

Yes indeed, the formatting should be done template side. They are the only 2 occurrences of this kind apparently. Did you open a bug report? On Thu, 20 Apr 2017 at 05:59 Nicolas Legrand wrote: > I think I now have something in invoice.pl : > > $line->{total_tax_excluded} = Koha::Number::Pric

Re: [Koha] Koha upgrade from 3.16 to 16.11

I think I now have something in invoice.pl : $line->{total_tax_excluded} = Koha::Number::Price->new( $line->{unitprice_tax_excluded} * $line->{quantity} )->format; $line->{total_tax_included} = Koha::Number::Price->new( $line->{unitprice_tax_included} * $line->{quantity} )->format; Forma

Re: [Koha] Koha upgrade from 3.16 to 16.11

Nicolas, what you describe can be ok, if the tax rate is 0. You need to provide ALL the price values from aqorders (quantity, listprice, unitprice, unitprice_tax_excluded, unitprice_tax_included, quantityreceived, rrp, rrp_tax_excluded, rrp_tax_included, ecost, ecost_tax_excluded, ecost_tax_include

Re: [Koha] Koha upgrade from 3.16 to 16.11

Sorry, it seems to be a problem with our conf, we avec a 0 taxes rate, since we buy from the whole world. 2017-04-19 17:16 GMT+02:00 Nicolas Legrand : > Hey Jonathan, Hey Hugo, > > we also have trouble in 16.11 with tax calculation : > > mysql> select unitprice_tax_excluded, unitprice_tax_included

Re: [Koha] Koha upgrade from 3.16 to 16.11

Hi Hugo, A big work has been done in price calculation in 16.11, see bug 13321 and related. It certainly comes from these patches. I guess you can see differences in orders as well? If you find one, would you be able to give us the vendor and order tax configuration as well as the prices and quant

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

Perfect and thanks to all! We're in business again... gcb -Original Message- From: frederic.demi...@gmail.com [mailto:frederic.demi...@gmail.com] On Behalf Of Frédéric Demians Sent: Tuesday, January 12, 2016 10:57 PM To: Bortel, Gary Cc: koha@lists.katipo.co.nz Subject: Re:

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

> I assume checkouts and returns continue to work. (There's no way to verify > since the checkout information doesn't appear.) This does, however, make it > difficult for them to renew materials for patrons. Yes, no visual feedback but it works. > Any suggestions? The 3.20 package will be update

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

: 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 9:14 AM To: > koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 > --> 3

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

...@lists.katipo.co.nz] On Behalf Of Jonathan Druart Sent: Monday, January 11, 2016 9:14 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] Koha upgrade 3.18.11 --> 3.20.07 http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=installer/data/mysql/updatedatabase.pl;h=950ed2067dac0edd51cf5e49

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

t; 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: [Ko

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

ent: 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

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

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 : > Hi Gary, > >> DBD::mysql::db do failed: Can't create table 'koha_library.#sql-4b9_4

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 co

Re: [Koha] koha upgrade 3.14 to 3.16

Hi Sunita, On Sat, Jul 5, 2014 at 6:42 PM, Sunita Barve wrote: > While we tried to upgrade koha from 3.14 to 3.16 the web installation > after running upgrade command threw following error Question : Which specific 3.14 version were on you? 3.14.8 or earlier? Please confirm. If you were on 3.14.

Re: [Koha] Koha Upgrade to 3.12

t 17, 2013 3:01 AM To: Manos PETRIDIS Cc: Koha list; SAIACS, Chief Librarian; Systems Administrator Subject: Re: [Koha] Koha Upgrade to 3.12 On Fri, Aug 16, 2013 at 10:18 AM, Manos PETRIDIS wrote: As I have the same question, should I open a new thread? My installation was installed us

Re: [Koha] Koha Upgrade- git

* SANDEEP BHAVSAR (sandeep.bhav...@gmail.com) wrote: > Dear All > > I have upgraded the Koha through git on 23/01/2013. and today I have > changed the IP address ( Koha.httpd.conf) but after that when I > searched in OPAC, I am getting only the No. of books available for > specific term is (257)

Re: [Koha] Koha Upgrade- git

wait.. On Mon, Jan 28, 2013 at 10:53 AM, SANDEEP BHAVSAR wrote: > Dear All > > I have upgraded the Koha through git on 23/01/2013. and today I have > changed the IP address ( Koha.httpd.conf) but after that when I > searched in OPAC, I am getting only the No. of books available for > specifi

Re: [Koha] Koha Upgrade

Dear All, We are using Koha version: 3.00.05.003 Acquisitions Module, ILL Suggestions/ Pending suggestions we are getting nearly 1000-1500 blogs Please someone guide us. Advance thanks Pandu On Fri, Jan 18, 2013 at 4:24 PM, mifantrax wrote: > HI all, i need your help. > > I am very new to ko

Re: [Koha] Koha Upgrade

At 05:27 AM 1/23/2013 -0800, mifantrax wrote: Thanks again for you help, I have been able to move further, however i got to the point of rebuild_zebra.pl It might be that your env vars are not properly set. To see if that is the case $ su koha $ cd usr/share/koha $ export KOHA_CONF=/etc/koha/s

Re: [Koha] Koha Upgrade

Thanks again for you help, I have been able to move further, however i got to the point of rebuild_zebra.pl and i get an error Can't locate Koha/DateUtils.pm in @INC (@INC contains: /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.

Re: [Koha] Koha Upgrade

Dear David, thank you. I was finally able to find all the info about the server and dumped the database. I had to delete all the logs to be able to free some space. Yes i saw today that i was wrong about the version. This makes my life easier. I will try to post updates as soon as I finish the

Re: [Koha] Koha Upgrade

Thanks all for your ideas, I will play tomorrow and let you know about my success. -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-Upgrade-tp5739511p5739662.html Sent from the Koha-general mailing list archive at Nabble.com.

Re: [Koha] Koha Upgrade

Hi again. I have inherited a koha installation version 2.~ with many problems on the > server, old version of ubuntu, full disk, and other issues. > If the Koha installation you are upgrading is the one here: http://library.tcmi.edu/ then you are actually on version 3.2.4 (from the view source

Re: [Koha] Koha Upgrade

Hi! Is there a guide somewhere ? I have been searching the wiki and i was not able to find it. Please someone guide us in the right direction. A little while ago we have paid the liblibre folks (specifically: Paul Poulain) to do this migration job for us. Worked out well. I guess other su

Re: [Koha] Koha Upgrade

Hi. Welcome to Koha! My recollection from previous posts to the mailing list, and a very quick search, are that you have two options: 1. Upgrade to version 3.0, then upgrade to the latest version 3 release 2. Treat it as a migration, like you would from any other system, rather than as an upgrad