First I tried to upgrade from SugarCRM 6.5.14 with SugarCE Migration 6.5.x to SuiteCRM 7.1.8.zip, but got some error messages. Then I tried to use Sugar 6.5.16, 6.5.18 and 6.5.22 as a basis, but nothing worked.
After that I read this thread https://suitecrm.com/forum/installation-upgrade-help/5569-sugarcrm-6-5-21-to-suitecrm-using-sugarce-migration-6-5-x-to-suitecrm-7-1-7-not-working
telling that “SuiteCRM currently runs off of the SugarCRM 6.5.20 core.”
I updated my SugarCRM 6.5.14 to 6.5.20 and again used the same migration package as mentioned above.
Got error message again: “Database failure. Please refer to sugarcrm.log for details.”
sugar.log tells:
11/18/15 22:15:30 [5392][all-13][FATAL] Query Failed: UPDATE aos_pdf_templates SET type = ‘AOS_Quotes’ WHERE type = ‘Quotes’: MySQL error 1146: Table ‘sugarcrm.aos_pdf_templates’ doesn’t exist
11/18/15 22:15:30 [5392][all-13][FATAL] Query Failed: UPDATE aos_pdf_templates SET type = ‘AOS_Invoices’ WHERE type = ‘Invoices’: MySQL error 1146: Table ‘sugarcrm.aos_pdf_templates’ doesn’t exist
11/18/15 22:15:30 [5392][all-13][FATAL] Query Failed: (SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role
FROM acl_actions
INNER JOIN acl_roles_users ON acl_roles_users.user_id = ‘all-13’ AND acl_roles_users.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )
UNION
(SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
FROM acl_actions
INNER JOIN securitygroups_users ON securitygroups_users.user_id = 'all-13' AND securitygroups_users.deleted = 0
INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )
UNION
(SELECT acl_actions.*, 0 as access_override, -1 as user_role
FROM acl_actions
WHERE acl_actions.deleted = 0 )
ORDER BY user_role desc, category,name,access_override desc: MySQL error 1146: Table 'sugarcrm.securitygroups_users' doesn't exist
11/18/15 22:15:31 [5392][all-13][FATAL] Query Failed: CREATE TABLE accounts_cstm (id_c char(36) NOT NULL , PRIMARY KEY (id_c)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1050: Table ‘sugarcrm.accounts_cstm’ already exists
11/18/15 22:15:31 [5392][all-13][FATAL] Cannot create column Query Failed: ALTER TABLE accounts_cstm add COLUMN jjwg_maps_lng_c float(11,8) NULL : MySQL error 1146: Table ‘sugarcrm.accounts_cstm’ doesn’t exist
What´s going wrong?
Regards