Error upgrading from SugarCRM 6.5.13 t Suite 7.0.1

📦 Install & Upgrade Help
1

Hi,

Tried to upgrade on a Windows 7 system running MSSQL 2005.
At end of install, received an error message to do with “function” however I did not record it. Silly move.
Now when I try to log in, I received the following error message in Chrome: “SQL Error : Invalid object name ‘securitygroups_users’.Database failure. Please refer to sugarcrm.log for details.”

SugarCRM log has the following:
11/13/13 22:10:08 [2548][-none-][FATAL] Invalid object name ‘securitygroups_users’.: (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 = ‘’ 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 = '' 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

11/13/13 22:10:08 [2548][-none-][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 = ‘’ 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 = '' 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: SQL Server error: Invalid object name 'securitygroups_users'.

11/13/13 22:10:08 [2548][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config WHERE category = N’MySettings’: SQL Server error: Invalid object name ‘securitygroups_users’.

Any help is greatly appreciated.

Thanks

Joe

2

Hi Joe,

Please see this topic which details an issue with the function keyword.

Thanks,

Will.

3

Thanks Will,

Has there been any progress with the function keyword issue?

Kind regards,

Joe

4

Hi Joe,

If you scan the last topic it mentions that this will be addressed in the next release of AOR. There is no set release date.

Thanks,

Will.