Slightly odd install/upgrade request
Folks, I find myself in a slightly odd position. Up until a couple of months ago I was running Koha 1.2.3 very satisfactorily. At that point I rebuilt the box it was running on and installed Ubuntu. Koha wasn't too high on my urgency list (getting my ecommerce site back was rather more urgent). However, I had taken a database dump so thought I could easily rebuild Koha when I had the time. My game plan was going to be to re-install 1.2.3 from scratch, overwrite the database with my saved copy, and then progress up through Koha releases until I got to the current one. I sat down last night to start the process and found, horror!, that koha 1.2.3 is no longer available for download, so my game plan was scuppered. As an experiment, I tried installing 2.2.6 with the existing database in place, and got a number of complaints from the installation and a general feeling that things hadn't gone properly. I now know about the mysql4/5 problem, and will rewind the database server to mysql4 before I start again, but can someone give me an idea of how I should proceed? Have there been database changes between 1.2.3 and 2.2.6? How should I get my 1.2.3 data into a new install of 2.2.6? Just a general hint or two would be helpful. I'm reasonably competent with databases, perl and unix cli. Help! Nigel
On Thu, 2006-11-23 at 16:54 +0000, Nigel Titley wrote:
I now know about the mysql4/5 problem, and will rewind the database server to mysql4 before I start again, but can someone give me an idea of how I should proceed? Have there been database changes between 1.2.3 and 2.2.6? How should I get my 1.2.3 data into a new install of 2.2.6? Just a general hint or two would be helpful. I'm reasonably competent with databases, perl and unix cli.
OK, since no one is able to offer any assistance, can someone who knows tell me where the database changed between 1.2.3 and the present? At least like that I can work out where to checkpoint the database. Or if you can't tell me, then let me know where to look. I'd really like to get Koha up and running again. Just a reminder, my database is 1.2.3 and I'd like to update to 2.2.7. All I need to know is (for example) that the database changed between 1.2.3 and 2.0.1 but has been stable since. Thanks Nigel
Nigel Titley a écrit :
On Thu, 2006-11-23 at 16:54 +0000, Nigel Titley wrote:
I now know about the mysql4/5 problem, and will rewind the database server to mysql4 before I start again, but can someone give me an idea of how I should proceed? Have there been database changes between 1.2.3 and 2.2.6? How should I get my 1.2.3 data into a new install of 2.2.6? Just a general hint or two would be helpful. I'm reasonably competent with databases, perl and unix cli.
OK, since no one is able to offer any assistance, can someone who knows tell me where the database changed between 1.2.3 and the present? At least like that I can work out where to checkpoint the database. Or if you can't tell me, then let me know where to look. I'd really like to get Koha up and running again.
Just a reminder, my database is 1.2.3 and I'd like to update to 2.2.7. All I need to know is (for example) that the database changed between 1.2.3 and 2.0.1 but has been stable since.
Hi Nigel, we can't help you precisely, because the description of your problem is not precise enough. The installer, from 1.2.3 to 2.0 should work & take care of all database updates. Once it's done, expecting you have a marc21 setup, with complete mappings of koha fields => MARC fields, you just have to run misc/koha2marc.pl to move your biblios to MARC structure. It may not work at 1st try, as this script was builded for 2.0, and the API slighlty changed for 2.2 (but no one updated this script, as I don't think anybody tried 1.2.3 => 2.2) Just 1 thing I see : $bibid = &MARCaddbiblio($dbh,$MARC,$biblionumber); should be written : $bibid = &MARCaddbiblio($dbh,$MARC,$biblionumber,''); (affecting all biblios to default framework, a new concept in 2.2) -- Paul POULAIN et Henri Damien LAURENT Consultants indépendants en logiciels libres et bibliothéconomie (http://www.koha-fr.org) Tel : 04 91 31 45 19
Paul POULAIN wrote:
Nigel Titley a écrit :
On Thu, 2006-11-23 at 16:54 +0000, Nigel Titley wrote:
I now know about the mysql4/5 problem, and will rewind the database server to mysql4 before I start again, but can someone give me an idea of how I should proceed? Have there been database changes between 1.2.3 and 2.2.6? How should I get my 1.2.3 data into a new install of 2.2.6? Just a general hint or two would be helpful. I'm reasonably competent with databases, perl and unix cli.
OK, since no one is able to offer any assistance, can someone who knows tell me where the database changed between 1.2.3 and the present? At least like that I can work out where to checkpoint the database. Or if you can't tell me, then let me know where to look. I'd really like to get Koha up and running again.
Just a reminder, my database is 1.2.3 and I'd like to update to 2.2.7. All I need to know is (for example) that the database changed between 1.2.3 and 2.0.1 but has been stable since.
Hi Nigel,
we can't help you precisely, because the description of your problem is not precise enough. That's fine. I'm very happy to give more details.
The installer, from 1.2.3 to 2.0 should work & take care of all database updates. Once it's done, expecting you have a marc21 setup, with complete mappings of koha fields => MARC fields, you just have to run misc/koha2marc.pl to move your biblios to MARC structure.
It may not work at 1st try, as this script was builded for 2.0, and the API slighlty changed for 2.2 (but no one updated this script, as I don't think anybody tried 1.2.3 => 2.2) Just 1 thing I see : $bibid = &MARCaddbiblio($dbh,$MARC,$biblionumber); should be written : $bibid = &MARCaddbiblio($dbh,$MARC,$biblionumber,''); (affecting all biblios to default framework, a new concept in 2.2)
OK, so what I think you are saying is that If I do the upgrade in two steps 1.2.3 -> 2.0.n 2.0.n -> 2.2.7 Then I should be fine (or at least on the right track). That was really all that I think I needed. I'll give it a shot and let people know if I need more help. Many thanks for getting back to me Nigel
On Tue, Nov 28, 2006 at 10:24:03AM +0000, Nigel Titley wrote:
On Thu, 2006-11-23 at 16:54 +0000, Nigel Titley wrote:
I now know about the mysql4/5 problem, and will rewind the database server to mysql4 before I start again, but can someone give me an idea of how I should proceed? Have there been database changes between 1.2.3 and 2.2.6? How should I get my 1.2.3 data into a new install of 2.2.6? Just a general hint or two would be helpful. I'm reasonably competent with databases, perl and unix cli.
OK, since no one is able to offer any assistance, can someone who knows tell me where the database changed between 1.2.3 and the present? At least like that I can work out where to checkpoint the database. Or if you can't tell me, then let me know where to look. I'd really like to get Koha up and running again. You can check out the sourceforge versions here:
http://sourceforge.net/projects/koha/ Starting with 2.2.5 we moved to Savannah: http://savannah.nongnu.org/projects/koha Comparing the database definition file (koha.sql) in version 1.2.3 to 2.0 and then 2.2 you will see several changes of critical importance to having a stable 2.2.7 system up and running.
Just a reminder, my database is 1.2.3 and I'd like to update to 2.2.7. All I need to know is (for example) that the database changed between 1.2.3 and 2.0.1 but has been stable since. It changed from 1.2.3 to 2.0.1, and then again in 2.2.0. Only minor changes since 2.2.0. AFAIK, updatedatabse should catch all of them. Of course, make sure to back up your db, etc. ;-).
I hope that helps. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
It changed from 1.2.3 to 2.0.1, and then again in 2.2.0. Only minor
changes since 2.2.0. AFAIK, updatedatabse should catch all of them. Of course, make sure to back up your db, etc. ;-).
I hope that helps.
It does indeed. This is exactly the sort of infomation I was looking for. I think I'm set to make an attempt at it now. Nigel
On Tue, 2006-11-28 at 21:27 +0000, Nigel Titley wrote:
It changed from 1.2.3 to 2.0.1, and then again in 2.2.0. Only minor
changes since 2.2.0. AFAIK, updatedatabse should catch all of them. Of course, make sure to back up your db, etc. ;-).
I hope that helps.
It does indeed. This is exactly the sort of infomation I was looking for. I think I'm set to make an attempt at it now.
Well, that seems to have done it. Koha back up and running at version 2.2.7, with my database intact. A couple of books checked in just to check it, and everything seems OK. Many thanks to Joshua and Paul for coming to my aid. Nigel
participants (3)
-
Joshua Ferraro -
Nigel Titley -
Paul POULAIN