[Koha] database import from 2.2.8 in 3.0.4-fixed

mourik jan c heupink heupink at merit.unu.edu
Fri Dec 11 11:30:11 NZDT 2009


Hi Rick, list,

> 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.
After solving the second problem (see below) everything seems to run 
beautifully now. I'll look into this some more, but at the moment it 
doesn't seem critical.

> 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'.
Thanks, I found out that MinPasswordLength was set to '5', and it should 
have been a yes/no (1/0). So that was exactly the problem! :-)

Thanks very much!

Mourik Jan


More information about the Koha mailing list