http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11390
--- Comment #9 from David Cook <[email protected]> --- (In reply to David Cook from comment #8) > 10) DBIC wasn't able to create tables > > DBD::mysql::db do failed: Can't create table 'kohadev38.items_search_fields' > (errno: 150) at /usr/lib/perl5/site_perl/5.16.2/DBIx/Class/Storage/DBI.pm > line 3053. > DBD::mysql::db do failed: Incorrect table definition; there can be only one > auto column and it must be defined as a key at > /usr/lib/perl5/site_perl/5.16.2/DBIx/Class/Storage/DBI.pm line 3053 > > AFFECTED: > `items_search_fields` > `message_queue` > Muahahaha! Solved! 1) `items_search_fields` Foreign keys must reference indexed columns. In kohastructure.sql, `authorised_values`.`category` has an index. However, that index is missing when using DBIC, so we get an errno 150, when we try to add `items_search_fields` because the constraint can't be generated. The fix? Add an index to `authorised_values`.`category`. DONE! (http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html) 2) `message_queue` This error is also because of a missing key. In kohastructure.sql, `message_queue`.`message_id` has an index. In theory, it should be a primary key, but it's not. It's just a regular key. Anyway, it's enough not to generate errors. However, with DBIC, that index is missing, so we get an error when trying to add `message_queue`. --- In summary, add indexes for `authorised_values`.`category` and `message_queue`.`message_id`, and both tables will be created properly. -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
