[Koha] database import from 2.2.8 in 3.0.4-fixed

[Rick Welykochy]

mourik jan c heupink wrote:

> I have started all over again, and hope someone can help out this time.
> I successfully installed koha 3.0.4-fixed (no ldap, nozebra)

We have successfully migrated a system from Koha 2.2.9 to 3.0.4_fixed.
I'll answer what I can below.



> This succeeded, but here I received the following 8 errors:
>
>       *  [Thu Dec 10 16:08:07 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Duplicate entry 'DebugLevel' for key 1 at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 107.
>
>       * [Thu Dec 10 16:08:07 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Table 'tags' already exists at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 114.
>
>       * [Thu Dec 10 16:08:09 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Duplicate entry '000493' for key 2 at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 284.
>
>       * [Thu Dec 10 16:08:13 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Duplicate entry 'minPasswordLength' for key 1 at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 730.
>
>       * [Thu Dec 10 16:08:13 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Duplicate entry 'uppercasesurnames' for key 1 at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 811.
>
>       * [Thu Dec 10 16:08:15 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Can't create table './merit/printers_profile.frm' (errno: 150)
> at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 1006.

In our experience and according to the doco, you can safely ignore the
above. They seem to be artifacts of the upgrade process.


>       * [Thu Dec 10 16:08:16 2009] updatedatabase.pl: DBD::mysql::db do
> failed: Unknown column 'printingtype' in 'labels_conf' at
> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
> line 1326.
>
>       * [Thu Dec 10 16:08:16 2009] updatedatabase.pl: ERROR 1452 (23000)
> at line 1: Cannot add or update a child row: a foreign key constraint
> fails (`merit/message_transports`, CONSTRAINT
> `message_transports_ibfk_3` FOREIGN KEY (`letter_module`, `letter_code`)
> REFERENCES `letter` (`module`, `code`) ON DELETE CASCADE ON UPDATE CASCADE)

We encountered a number of FK problems in the 2.2.9 data we were using,
since relational integrity was not introduced until Koha 3.0. You can discover
where the FK relationship breaks by searching for records in the child table that
refer to a (module,code) combination that does not exist in the parent table.
I cannot tell which tables are involved from the above message, but a bit
of snooping around should find it for you.


> I'm guessing that these errors are serious, because certain things don't
> function anymore, specifically: the 'Patrons' menu under
> 'Administration', 'Global system preferences' gives "production mode -
> trapped fatal error".
>
> In my apache error log, I see:
> [Thu Dec 10 16:26:26 2009] [error] [client 192.87.143.125] [Thu Dec 10
> 16:26:26 2009] systempreferences.pl: The given value does not seem to be
> interpretable as a Boolean value at /usr/share/koha/lib/C4/Boolean.pm
> line 102., referer:
> http://192.87.143.104:8080/cgi-bin/koha/admin/systempreferences.pl
>
> Any suggestions how to fix this..?

I suspect that your systempreferences in Koha 2.2.8 had an invalid value
for a Boolean type. You can discover the valid Boolean values in C4/Boolean.pm.
Couple that with a search through the systempreferences for those entries
that have type='YesNo'.


HTH

cheers
rickw



-- 
_________________________________
Rick Welykochy || Praxis Services

C makes it easy to shoot yourself in the foot. C++ makes it harder,
but when you do, it blows away your whole leg.
      -- Bjarne "Stumpy" Stroustrup