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@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
