Re: [Koha] Upgrading Koha from 3.06 to 3.14
Thank Robin and all for your response. I tried the way Robin suggested and it worked, however I got the following error while issuing the koha-mysql instancename sqlfile command: ERROR 1005 (HY000) at line 2752: Can't create table 'koha_library.letter' (errno: 150) Also, I couldn't find the saved Koha reports after importing the earlier Koha database. It is not a big issue as I can manually create reports from the SQL.But I am wondering, why the saved reports were not imported even after issuing koha-upgrade-schema command. Apart from these issue, I found catalogues, holdings info and patron information imported correctly. I quickly checked the circulation info and I think it has also been imported. Regards, Dibyendra On 3/28/14, Robin Sheat ro...@catalyst.net.nz wrote: Paul A schreef op do 27-03-2014 om 09:36 [-0400]: Perhaps not germane to this Koha question, but your suggestion sudo apt-get dist-upgrade _may_ cause unintended consequences with the o/s. It possibly will, though probably not. It will also not really upgrade koha, as it doesn't cover moving the data. My suggestion (and I've done this a few times) is to install Koha from the packages (already done), take a database dump of the old one using mysqldump, create an instance in the new install (koha-create), and then load the data into the new instance. This last part can be done with: sudo koha-mysql instancename dumpfile.sql Then you can run: sudo koha-upgrade-schema instancename wait a while (if you have a lot of data and history), and you'll have an up-to-date installation. -- 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 -- Dibyendra Hyoju ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading Koha from 3.06 to 3.14
On 30 March 2014 23:00, Dibyendra Hyoju dibyen...@gmail.com wrote: Thank Robin and all for your response. I tried the way Robin suggested and it worked, however I got the following error while issuing the koha-mysql instancename sqlfile command: ERROR 1005 (HY000) at line 2752: Can't create table 'koha_library.letter' (errno: 150) Also, I couldn't find the saved Koha reports after importing the earlier Koha database. It is not a big issue as I can manually create reports from the SQL.But I am wondering, why the saved reports were not imported even after issuing koha-upgrade-schema command. Apart from these issue, I found catalogues, holdings info and patron information imported correctly. I quickly checked the circulation info and I think it has also been imported. You will have other hidden issues, it will have stopped at the letter table and not created tables after that (including the reports which you have noticed). You will to search what an error 150 is, and then try your import again fixing whatever you need to get the letter table to be created. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading Koha from 3.06 to 3.14
Thanks Chris and all! I dropped all the database tables and imported the earlier 3.06 database and performed import and upgrade command and it worked perfectly! Regards, Dibyendra On 3/30/14, Chris Cormack ch...@bigballofwax.co.nz wrote: On 30 March 2014 23:00, Dibyendra Hyoju dibyen...@gmail.com wrote: Thank Robin and all for your response. I tried the way Robin suggested and it worked, however I got the following error while issuing the koha-mysql instancename sqlfile command: ERROR 1005 (HY000) at line 2752: Can't create table 'koha_library.letter' (errno: 150) Also, I couldn't find the saved Koha reports after importing the earlier Koha database. It is not a big issue as I can manually create reports from the SQL.But I am wondering, why the saved reports were not imported even after issuing koha-upgrade-schema command. Apart from these issue, I found catalogues, holdings info and patron information imported correctly. I quickly checked the circulation info and I think it has also been imported. You will have other hidden issues, it will have stopped at the letter table and not created tables after that (including the reports which you have noticed). You will to search what an error 150 is, and then try your import again fixing whatever you need to get the letter table to be created. Chris ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Dibyendra Hyoju ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading Koha from 3.06 to 3.14
Not only will this routine upgrade all packages installed, but it is not what the original poster asked for. If I understand correctly, the scenario is either now that we've tested the new version in a test installation, how do we go upgrading the older source-based installation, keeping the older hardware in place or will a recent by-packages installation automatically upgrade the older db once it is restored to the new machine?. To provide a useful note, may I add that I used to have a git-based 3.08 installation myself and restored its db to a packages-based 3.14 one with no real problems. Koha applied all needed modifications to the db schema to bring it up to 3.14 level. kind regards, MP On 27 Μαρ 2014, at 3:36 μ.μ., Paul A pau...@navalmarinearchive.com wrote: At 11:25 AM 3/27/2014 +, Vinod Kumar Mishra wrote: Dear, Please use the following commands one by one to upgrade to latest old stable version: 1. echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d koha.list 2. wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - 3. sudo apt-get update 4. sudo apt-get upgrade 5. sudo apt-get dist-upgrade Perhaps not germane to this Koha question, but your suggestion sudo apt-get dist-upgrade _may_ cause unintended consequences with the o/s. Regards -- 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
[Koha] Upgrading Koha from 3.06 to 3.14
Hi all, I installed Koha 3.06 from the source few years back. Recently, I have also installed Koha 3.14 using koha-common into another machine. My queries are: 1. I was wondering if there is a way to upgrade the database of Koha 3.06 to 3.14. 2. Or can we upgrade the Koha 3.06 to 3.14 using Koha 3.14 source? Thanking you, Dibyendra Hyoju ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading Koha from 3.06 to 3.14
Dear, Please use the following commands one by one to upgrade to latest old stable version: 1. echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d koha.list 2. wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - 3. sudo apt-get update 4. sudo apt-get upgrade 5. sudo apt-get dist-upgrade This will update koha to latest stable version and then check the emails. On Thu, 27 Mar 2014 15:14:44 +0530 wrote Hi all, I installed Koha 3.06 from the source few years back. Recently, I have also installed Koha 3.14 using koha-common into another machine. My queries are: 1. I was wondering if there is a way to upgrade the database of Koha 3.06 to 3.14. 2. Or can we upgrade the Koha 3.06 to 3.14 using Koha 3.14 source? Thanking you, Dibyendra Hyoju ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Upgrading Koha from 3.06 to 3.14
At 11:25 AM 3/27/2014 +, Vinod Kumar Mishra wrote: Dear, Please use the following commands one by one to upgrade to latest old stable version: 1. echo deb http://debian.koha-community.org/koha oldstable main | sudo tee /etc/apt/sources.list.d koha.list 2. wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add - 3. sudo apt-get update 4. sudo apt-get upgrade 5. sudo apt-get dist-upgrade Perhaps not germane to this Koha question, but your suggestion sudo apt-get dist-upgrade _may_ cause unintended consequences with the o/s. Regards -- Paul ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
