texxasrulez / calendar

GNU Affero General Public License v3.0
15 stars 14 forks source link

Duplicate constraints when creating mysql tables #7

Closed ScrumpyJack closed 4 years ago

ScrumpyJack commented 4 years ago

I get this when using mysql.initial.sql

ERROR 1005 (HY000) at line 113: Can't create tableroundcubemail.database_calendars(errno: 121 "Duplicate key on write or update")

Here are the foreign keys on my database

MariaDB [roundcubemail]> SELECT constraint_name, table_name FROM information_schema.table_constraints WHERE constraint_type = 'FOREIGN KEY' AND table_schema = DATABASE() ORDER BY constraint_name;

constraint_name table_name
additional_imap_ibfk_1 additional_imap
additional_imap_ibfk_2 additional_imap
additional_smtp_ibfk_1 additional_smtp
additional_smtp_ibfk_2 additional_smtp
carddav_addressbooks_ibfk_1 carddav_addressbooks
carddav_contacts_ibfk_1 carddav_contacts
carddav_groups_ibfk_1 carddav_groups
carddav_group_user_ibfk_1 carddav_group_user
carddav_group_user_ibfk_2 carddav_group_user
carddav_xsubtypes_ibfk_1 carddav_xsubtypes
contactgroup_id_fk_contactgroups contactgroupmembers
contact_id_fk_contacts contactgroupmembers
fk_attachments_event_id attachments
fk_caldav_attachments_event_id caldav_attachments
fk_caldav_calendars_user_id caldav_calendars
fk_caldav_events_calendar_id caldav_events
fk_calendars_user_id calendars
fk_events_calendar_id events
fk_itipinvitations_user_id itipinvitations
user_id_fk_cache cache
user_id_fk_cache_index cache_index
user_id_fk_cache_messages cache_messages
user_id_fk_cache_thread cache_thread
user_id_fk_contactgroups contactgroups
user_id_fk_contacts contacts
user_id_fk_dictionary dictionary
user_id_fk_filestore filestore
user_id_fk_identities identities
user_id_fk_searches searches

29 rows in set (0.002 sec)

Looks like there already is a fk_calendars_user_id contraint

ScrumpyJack commented 4 years ago

Got this working with SET FOREIGN_KEY_CHECKS=0; , deleting all the tables then reimporting the sql