Thanks, I found 2.02rc4 on the page you passed on, does anyone else have older versions we can get to do the incremental upgrade? Steve. -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of MJ Ray Sent: April-03-08 9:54 AM To: koha@lists.katipo.co.nz Subject: Re: [Koha] koha upgrade 1.2.2 to 2.2.9... "Steve Bradwell" <sbradwell@perimeterinstitute.ca> wrote: [...]

My guess is the easiest way is to upgrade at this point is a fresh install, then look to migrate data? I read a post from a while back about moving from 1.2.x to 2.0 using an upgrade script, would this work still for us as we are so far behind?

If I were you, I'd try moving from 1.2.x to a 2.0 and then to 2.2 - and maybe then to 3.0 if it's fully-released by then. Also, take lots of backups and maybe do this on another server with a mysql dump of the 1.2 database imported. I can't remember how easy it is to find 2.0 releases any more. There's a 2.0 download on http://www.mjr.dsl.pipex.com/ (which I no longer have access to, so I've no idea how long it will remain - can someone copy it onto www.koha.org easily?) and I probably have later ones on an old CD or hard drive somewhere. I don't know where all the 2.0 uploads to Sourceforge have gone, as only 1.2.3 is shown there. Good luck! -- MJ Ray (slef) Webmaster for hire, statistician and online shop builder for a small worker cooperative http://www.ttllp.co.uk/ http://mjr.towers.org.uk/ (Notice http://mjr.towers.org.uk/email.html) tel:+44-844-4437-237 _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha

We're currently at 1.2.2, it was suggested we could move from there to 2.0, then to 2.2, if you have 2.0 and 2.2 we could try that. Thanks, Steve. -----Original Message----- From: Rob Weir [mailto:robweir@alum.drexel.edu] Sent: April-03-08 10:41 AM To: Steve Bradwell Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] koha upgrade 1.2.2 to 2.2.9... I think I still have all the old versions. If you let me know which ones you need, I can post a download link for them. Rob Steve Bradwell wrote:

Thanks, I found 2.02rc4 on the page you passed on, does anyone else have older versions we can get to do the incremental upgrade?

Steve.

Hi All, So we appear to be making great progress in our upgrade from version 1.2.2 to 2.2.9. We have 2.2.9 partially up and running. We are now trying to build the marc data using koha2marc.pl and are getting errors for every record we have. We used the sql in the sql_datas dir, and our marc check has a status of "ok". When running koha2marc.pl we get the errors below, as well as issues with empty framework field. When looking at the defualt framework in the koha interface, we see all our marc tags, but get errors like below. example: DBD::mysql::st execute failed: Column 'bibid' cannot be null at /web/intranet/koha/modules/C4/Biblio.pm line 1306. ERROR ==> insert into marc_word (bibid, tagsubfield, tagorder, subfieldorder, word, sndx_word) values (,concat(952,v),1,6,05,soundex(05)) So we're not sure how to generate the marc data now, maybe we should have done it pre 2.2.9? We didn't use marc data in 1.2.2. Any guidance you can provide is welcome. Thanks, Steve. ________________________________ From: Rob Weir [mailto:robweir@alum.drexel.edu] Sent: Thu 4/3/2008 1:19 PM To: Steve Bradwell Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] koha upgrade 1.2.2 to 2.2.9... http://koha.rwjr.com/downloads/index.html Steve Bradwell wrote:

We're currently at 1.2.2, it was suggested we could move from there to 2.0, then to 2.2, if you have 2.0 and 2.2 we could try that.

Thanks,

Steve.