Upgrade Koha/2.2.9 to Koha/3

[Rick Welykochy]

HI all

I am looking for doco on upgrading a Koha/2.2.9 install to Koha 3.
Well, actually just the database.

I note this from the INSTALL file:

    UPGRADE
    =======
    If you are upgrading from a previous installation of Koha 3, you can
    use the following:

     perl Makefile.PL --prev-install-log /path/to/koha-install-log
     make
     make test
     sudo make upgrade

Searching the wiki.koha.org doesn't turn up any more info about the
upgrade process.

Could someone pls point me at some more info about this?

Thanks,
Rick W


--
_________________________________
Rick Welykochy || Praxis Services

"A Ministry of Defence guide to preventing information leaking into
the public domain has leaked into the public domain."

_______________________________________________
Koha-devel mailing list
Koha-devel@...
http://lists.koha.org/mailman/listinfo/koha-devel

[Chris Cormack-6]

2009/10/9 Rick Welykochy <rick@...>:

> HI all
>
> I am looking for doco on upgrading a Koha/2.2.9 install to Koha 3.
> Well, actually just the database.
>
> I note this from the INSTALL file:
>
>    UPGRADE
>    =======
>    If you are upgrading from a previous installation of Koha 3, you can
>    use the following:
>
>     perl Makefile.PL --prev-install-log /path/to/koha-install-log
>     make
>     make test
>     sudo make upgrade
>
> Searching the wiki.koha.org doesn't turn up any more info about the
> upgrade process.
>
> Could someone pls point me at some more info about this?

I found
http://wiki.koha.org/doku.php#koha_2.2.x

which linked to

http://wiki.koha.org/doku.php?id=22_to_30

Chris
_______________________________________________
Koha-devel mailing list
Koha-devel@...
http://lists.koha.org/mailman/listinfo/koha-devel

[Rick Welykochy]

Chris Cormack wrote:

> I found
> http://wiki.koha.org/doku.php#koha_2.2.x
>
> which linked to
>
> http://wiki.koha.org/doku.php?id=22_to_30

Thanks Chris. Will give it a try.

One concern I have is the 2.2.9 database uses charset Latin1.
But the Koha3 database will be UTF-8.

One punter on this list recommended the following to change over
to UTF-8.

1. set charset (?) to BINARY
2. then set it to URF-8

dunno how that will affect a proper changeover to URF-8.


cheers
rickw


--
_________________________________
Rick Welykochy || Praxis Services

"A Ministry of Defence guide to preventing information leaking into
the public domain has leaked into the public domain."

_______________________________________________
Koha-devel mailing list
Koha-devel@...
http://lists.koha.org/mailman/listinfo/koha-devel

[Chris Cormack-6]

2009/10/10 Rick Welykochy <rick@...>:

> Chris Cormack wrote:
>
>> I found
>> http://wiki.koha.org/doku.php#koha_2.2.x
>>
>> which linked to
>>
>> http://wiki.koha.org/doku.php?id=22_to_30
>
> Thanks Chris. Will give it a try.
>
> One concern I have is the 2.2.9 database uses charset Latin1.
> But the Koha3 database will be UTF-8.
>
> One punter on this list recommended the following to change over
> to UTF-8.
>
> 1. set charset (?) to BINARY
> 2. then set it to URF-8
>
> dunno how that will affect a proper changeover to URF-8.
>

I think the instructions on the wiki contain all the steps needed to
change the database.
At least they did last year when I last tried

Chris
_______________________________________________
Koha-devel mailing list
Koha-devel@...
http://lists.koha.org/mailman/listinfo/koha-devel

[Rick Welykochy]

Rick Welykochy wrote:

> Chris Cormack wrote:
>>
>> http://wiki.koha.org/doku.php?id=22_to_30
>
> Thanks Chris. Will give it a try.
>
> One concern I have is the 2.2.9 database uses charset Latin1.
> But the Koha3 database will be UTF-8.
>
> One punter on this list recommended the following to change over
> to UTF-8.
>
> 1. set charset (?) to BINARY
> 2. then set it to URF-8
>
> dunno how that will affect a proper changeover to URF-8.

It appears I was worried about nothing. I began the upgrade from
a Koha/2.2.9 database to Koha/3.00.02.012 and voila! UTF-8.

But other probs have arisen.

e.g. here is a cleaned up list of poignant error msgs

DBD::mysql::st execute failed: Unknown column 'faxnumber' in 'deletedborrowers' at ./update22to30.pl line 3071.
DBD::mysql::db do failed: Duplicate column name 'B_zipcode' at ./update22to30.pl line 3104.
DBD::mysql::st execute failed: Table 'aftest.marc_breeding' doesn't exist at ./update22to30.pl line 3178.
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3271.
DBD::mysql::db do failed: Unknown column 'volumeddesc' in 'biblioitems' at ./update22to30.pl line 3271.
DBD::mysql::st execute failed: Table 'aftest.bookshelf' doesn't exist at ./update22to30.pl line 3206.
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3271.
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3271.
DBD::mysql::st execute failed: Table 'aftest.shelfcontents' doesn't exist at ./update22to30.pl line 3206.
DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3408.
DBD::mysql::st execute failed: Table 'aftest.marc_biblio' doesn't exist at ./update22to30.pl line 3476.
DBD::mysql::db do failed: Can't DROP 'borrowernumber'; check that column/key exists at ./update22to30.pl line 3531.

My guess is that I should not be upgrading directly to 3.00.02.012
using the ./update22to30.pl script.

I am taking this path since we have a Koha/3.00.02.012 instance already
installed and awaiting the 2.2.9 data.


Perhaps I should upgrade to a 3.00.00 instance of the database
and then apply the incremental database upgrades to get me to
3.00.02.

Thoughts?


cheers
rickw



--
_________________________________
Rick Welykochy || Praxis Services

"A Ministry of Defence guide to preventing information leaking into
the public domain has leaked into the public domain."

_______________________________________________
Koha-devel mailing list
Koha-devel@...
http://lists.koha.org/mailman/listinfo/koha-devel

[Rick Welykochy]

Rick Welykochy wrote:

> It appears I was worried about nothing. I began the upgrade from
> a Koha/2.2.9 database to Koha/3.00.02.012 and voila! UTF-8.
>
> But other probs have arisen.
>
> e.g. here is a cleaned up list of poignant error msgs

My badness! I was using the wrong database as the basis for
the upgrade. Disregard :)

The migration process from Koha 2.2.9 to Koha 3.0.2 went pretty well
except there were a few hitches converting over to Unicode in the
MARC data. The consequences of which we will investigate.

Thanks so much to the Koha team who managed, scripted and wrote up
the entire migration process. It was a lot of work and well done.

cheers
rickw



--
_________________________________
Rick Welykochy || Praxis Services

"A Ministry of Defence guide to preventing information leaking into
the public domain has leaked into the public domain."

_______________________________________________
Koha-devel mailing list
Koha-devel@...
http://lists.koha.org/mailman/listinfo/koha-devel