database import from 2.2.8 in 3.0.4-fixed
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
mourik jan c heupink a écrit :
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
This one is easy to fix: set to 0 any value that is supposed to be boolean (YesNo) in systempreferences and that is not: SELECT * FROM systempreferences WHERE type='YesNo'; -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc Tel : (33) 4 91 81 35 08
Hi Paul, Thanks for your suggestion. It worked out: MinPasswordLength was set to 5, and that turned out to be wrong. :-) Thanks, and hopefully I'll get a bit further now! MJ
This one is easy to fix: set to 0 any value that is supposed to be boolean (YesNo) in systempreferences and that is not: SELECT * FROM systempreferences WHERE type='YesNo';
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
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
participants (3)
-
mourik jan c heupink -
Paul Poulain -
Rick Welykochy