https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19259
--- Comment #4 from Marc Véron <[email protected]> --- Reading: https://dev.mysql.com/doc/refman/5.5/en/rename-table.html ------- RENAME TABLE changes internally generated foreign key constraint names and user-defined foreign key constraint names that contain the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign key constraint names that contain the string “tbl_name_ibfk_” as internally generated names. Foreign key constraint names that point to the renamed table are automatically updated unless there is a conflict, in which case, the statement fails with an error. A conflict occurs if the renamed constraint name already exists. In such cases, you must drop and re-create the foreign keys in order for them to function properly. ------- Line 11590 in updatedatabase.pl renames table overduerules to old_overduerules, then it creates a new table overduerules. The renaming action changed / renamed REFERENCES in constraints of overduerules_transport_types (maybe in other tables as well?). That would explain that the error can not be reproduced on a fresh install (i.e. an install later than 3.23.00.007). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ 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/
