Hi,
Can you execute this from query anaylzer and then try setup page again:
ALTER PROCEDURE [dbo].[mp_ModuleSettings_SyncDefinitions]
AS
UPDATE mp_ModuleSettings
SET ControlSrc = (SELECT TOP 1 mds.ControlSrc
FROM mp_ModuleDefinitionSettings mds
WHERE mds.ModuleDefId IN (SELECT ModuleDefId
FROM mp_Modules m
WHERE m.ModuleID = mp_ModuleSettings.ModuleID)
AND mds.SettingName = mp_ModuleSettings.SettingName
)
UPDATE mp_ModuleSettings
SET ControlType = (SELECT TOP 1 mds.ControlType
FROM mp_ModuleDefinitionSettings mds
WHERE mds.ModuleDefId IN (SELECT ModuleDefId
FROM mp_Modules m
WHERE m.ModuleID = mp_ModuleSettings.ModuleID)
AND mds.SettingName = mp_ModuleSettings.SettingName
)
UPDATE mp_ModuleSettings
SET SortOrder = COALESCE((SELECT TOP 1 mds.SortOrder
FROM mp_ModuleDefinitionSettings mds
WHERE mds.ModuleDefId IN (SELECT ModuleDefId
FROM mp_Modules m
WHERE m.ModuleID = mp_ModuleSettings.ModuleID)
AND mds.SettingName = mp_ModuleSettings.SettingName
),9000)
UPDATE ms
SET ms.RegexValidationExpression = mds.RegexValidationExpression
FROM mp_ModuleSettings ms
JOIN mp_Modules m
ON ms.ModuleID = m.ModuleID
JOIN mp_ModuleDefinitionSettings mds
ON ms.SettingName = mds.SettingName
AND m.ModuleDefId = mds.ModuleDefId
UPDATE mp_ModuleSettings
SET HelpKey = (SELECT TOP 1 mds.HelpKey
FROM mp_ModuleDefinitionSettings mds
WHERE mds.ModuleDefId IN (SELECT ModuleDefId
FROM mp_Modules m
WHERE m.ModuleID = mp_ModuleSettings.ModuleID)
AND mds.SettingName = mp_ModuleSettings.SettingName
)
GO
Please let me know if that solves it.
Best,
Joe