[Koha] database import from 2.2.8 in 3.0.4-fixed

[mourik jan c heupink]

Hi,

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)

Then:
- I imported my older 2.2.8 database into mysql
- Adjusted /etc/koha-conf.xml to connect to the old database
- Ran the installer/data/mysql/update22to30.pl
- Opened the :8080 web interface, where I arrived at step three of the 
installer: update the database from 3.00.00.001 to version 3.00.04.019.

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.

     * [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)

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..?

Regards,
Mourik Jan