Database problems with installer

Thomas

Database problems with installer

Posted:11 Sep 2013 (08:49 UTC)
When installing Bitweaver on my Debian Squeeze system,
(PHP Version => 5.3.3-7+squeeze17
System => Linux web1 2.6.32-5-amd64 #1 SMP Fri May 10 08:43:19 UTC 2013 x86_64
mysql Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (x86_64) using readline 6.1)
I get a bunch of errors when installing the packages. I tried with 3.1 stable as well as with the 4.0.0 from github. Any ideas?

The following database operations failed

Failed to add constraint liberty_content_perm_group_ref to table liberty_content_permissions:
ALTER TABLE `liberty_content_permissions` ADD CONSTRAINT `liberty_content_perm_group_ref` FOREIGN KEY (`group_id`) REFERENCES `users_groups` (`group_id`)

Failed to add constraint liberty_process_queue_ref to table liberty_process_queue:
ALTER TABLE `liberty_process_queue` ADD CONSTRAINT `liberty_process_queue_ref` FOREIGN KEY (`content_id`) REFERENCES `liberty_content`( `content_id` )

Failed to create index content_title_idx on liberty_content:
ALTER TABLE liberty_content ADD INDEX content_title_idx (title)

Failed to create index content_user_idx on liberty_content:
ALTER TABLE liberty_content ADD INDEX content_user_idx (user_id)

Failed to create index content_moduser_idx on liberty_content:
ALTER TABLE liberty_content ADD INDEX content_moduser_idx (modifier_user_id)

Failed to create index content_content_hits_idx on liberty_content_hits:
ALTER TABLE liberty_content_hits ADD INDEX content_content_hits_idx (content_id)

Failed to create index content_status_idx on liberty_content:
ALTER TABLE liberty_content ADD INDEX content_status_idx (content_status_id)

Failed to create index content_alias_title_idx on liberty_aliases:
ALTER TABLE liberty_aliases ADD INDEX content_alias_title_idx (alias_title)

Failed to create index comments_object_idx on liberty_comments:
ALTER TABLE liberty_comments ADD INDEX comments_object_idx (content_id)

Failed to create index comments_parent_idx on liberty_comments:
ALTER TABLE liberty_comments ADD INDEX comments_parent_idx (parent_id)

Failed to create index attachments_hits_idx on liberty_attachments:
ALTER TABLE liberty_attachments ADD INDEX attachments_hits_idx (hits)

Failed to create index attachments_user_id_idx on liberty_attachments:
ALTER TABLE liberty_attachments ADD INDEX attachments_user_id_idx (user_id)

Failed to create index st_co_foreign_guid_idx on liberty_attachments:
ALTER TABLE liberty_attachments ADD UNIQUE INDEX st_co_foreign_guid_idx (foreign_id, attachment_plugin_guid)

Failed to create index structures_root_idx on liberty_structures:
ALTER TABLE liberty_structures ADD INDEX structures_root_idx (root_structure_id)

Failed to create index structures_parent_idx on liberty_structures:
ALTER TABLE liberty_structures ADD INDEX structures_parent_idx (parent_id)

Failed to create index structures_content_idx on liberty_structures:
ALTER TABLE liberty_structures ADD INDEX structures_content_idx (content_id)

Failed to create index to_content_id_idx on liberty_content_links:
ALTER TABLE liberty_content_links ADD INDEX to_content_id_idx (to_content_id)

Failed to create index links_from_content_id_idx on liberty_content_links:
ALTER TABLE liberty_content_links ADD INDEX links_from_content_id_idx (from_content_id)

Failed to create index links_title_content_id_idx on liberty_content_links:
ALTER TABLE liberty_content_links ADD INDEX links_title_content_id_idx (to_title)

Failed to create index liberty_content_perm_group_idx on liberty_content_permissions:
ALTER TABLE liberty_content_permissions ADD INDEX liberty_content_perm_group_idx (group_id)

Failed to create index liberty_content_perm_perm_idx on liberty_content_permissions:
ALTER TABLE liberty_content_permissions ADD INDEX liberty_content_perm_perm_idx (perm_name)

Failed to create index liberty_content_perm_cont_idx on liberty_content_permissions:
ALTER TABLE liberty_content_permissions ADD INDEX liberty_content_perm_cont_idx (content_id)

Failed to create index process_id_idx on liberty_process_queue:
ALTER TABLE liberty_process_queue ADD INDEX process_id_idx (content_id)

Failed to create index lib_attachment_meta_idx on liberty_attachment_meta_data:
ALTER TABLE liberty_attachment_meta_data ADD INDEX lib_attachment_meta_idx (attachment_id)

Failed to create index lib_attachment_meta_type_idx on liberty_attachment_meta_data:
ALTER TABLE liberty_attachment_meta_data ADD INDEX lib_attachment_meta_type_idx (meta_type_id)

Failed to create index lib_attachment_meta_title_idx on liberty_attachment_meta_data:
ALTER TABLE liberty_attachment_meta_data ADD INDEX lib_attachment_meta_title_idx (meta_title_id)

Failed to create index themes_layouts_module_idx on themes_layouts:
ALTER TABLE themes_layouts ADD INDEX themes_layouts_module_idx (module_id)

Failed to create index users_users_email_idx on users_users:
ALTER TABLE users_users ADD UNIQUE INDEX users_users_email_idx (email)

Failed to create index users_users_login_idx on users_users:
ALTER TABLE users_users ADD UNIQUE INDEX users_users_login_idx (login)

Failed to create index users_users_avatar_atment_idx on users_users:
ALTER TABLE users_users ADD INDEX users_users_avatar_atment_idx (avatar_attachment_id)

Failed to create index users_fav_con_idx on users_favorites_map:
ALTER TABLE users_favorites_map ADD INDEX users_fav_con_idx (favorite_content_id)

Failed to create index users_fav_user_idx on users_favorites_map:
ALTER TABLE users_favorites_map ADD INDEX users_fav_user_idx (user_id)

Failed to create index users_groups_user_idx on users_groups:
ALTER TABLE users_groups ADD INDEX users_groups_user_idx (user_id)

Failed to create index users_groups_user_name_idx on users_groups:
ALTER TABLE users_groups ADD UNIQUE INDEX users_groups_user_name_idx (user_id, group_name)

Failed to create index users_group_perm_group_idx on users_group_permissions:
ALTER TABLE users_group_permissions ADD INDEX users_group_perm_group_idx (group_id)

Failed to create index users_group_perm_perm_idx on users_group_permissions:
ALTER TABLE users_group_permissions ADD INDEX users_group_perm_perm_idx (perm_name)

Failed to create index users_groups_map_user_idx on users_groups_map:
ALTER TABLE users_groups_map ADD INDEX users_groups_map_user_idx (user_id)

Failed to create index users_groups_map_group_idx on users_groups_map:
ALTER TABLE users_groups_map ADD INDEX users_groups_map_group_idx (group_id)

Failed to create index i18n_masters_pkg_idx on i18n_masters:
ALTER TABLE i18n_masters ADD INDEX i18n_masters_pkg_idx (package)

Failed to create index i18n_masters_created_idx on i18n_masters:
ALTER TABLE i18n_masters ADD INDEX i18n_masters_created_idx (created)

Failed to create index i18n_strings_lang_idx on i18n_strings:
ALTER TABLE i18n_strings ADD INDEX i18n_strings_lang_idx (source_hash)

Failed to create index i18n_strings_modif_idx on i18n_strings:
ALTER TABLE i18n_strings ADD INDEX i18n_strings_modif_idx (last_modified)

Failed to create index i18n_version_src_idx on i18n_version_map:
ALTER TABLE i18n_version_map ADD INDEX i18n_version_src_idx (source_hash)

Failed to create index i18n_version_ver_idx on i18n_version_map:
ALTER TABLE i18n_version_map ADD INDEX i18n_version_ver_idx (version)

Failed to create index wiki_pages_content_idx on wiki_pages:
ALTER TABLE wiki_pages ADD INDEX wiki_pages_content_idx (content_id)

Failed to create index wiki_page_footnotes_page_idx on wiki_footnotes:
ALTER TABLE wiki_footnotes ADD INDEX wiki_page_footnotes_page_idx (page_id)