Hi Dale,
This is because you are running MS SQL 2000 and there is an incompatible sql statement in the script.
You can fix it by using a text editor and opening the file /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql/2.2.6.0.config
Look for this:
UPDATE mp_ModuleSettings
SET RegexValidationExpression = (SELECT TOP 1 mds.RegexValidationExpression
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
)
and replace it with this:
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
Then visit the setup page again and it should be fixed. I already fixed this for clean installs on SQL 2000, and I will fix this upgrade script now.
Hope it helps,
Joe