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