[Koha-devel] Upgrade Koha/2.2.9 to Koha/3

[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."