Hi,
I've tried very hard to keep SQL 2000 compatibility, I always generate the scripts using SQL 2000 compatibility mode, but apparently something got in there that it isn't happy with. I don't have SQL 2000 running on any machine around here anymore myself so admittedly my testing doesn't cover it anymore.
I can give you a little strategy to try and resolve it. Basically the setup routine runs the scripts in version order and then records the new version in mp_SchemaVersion after running each script that doesn't throw an error. The scripts are located in the /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql folder. What I would do is open up the 2.2.6.0.config file in a text editor and then paste it into Query Analyzer one at a time and run them. When you come to the one or ones that error, let me know or if you are good with sql maybe you can come up with an alterate. My best guess at where the error is happening is in this update:
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
)
I think SQL 2000 might not like using the SELECT TOP with an ntext field. On a new install, I think you can skip this particluar update statement altogether with no side effects. So you could just chop that out and visit the setup page again instead of running anything manually in Query analyzer, but if it still errors then run them one by one and let me know where it breaks. Hopefully it will go through the rest without issues. If you do end up running any scripts manually, after running it set the version in mp_SchemaVersion for the mojoportal-core application row.
Best,
Joe