installation failed

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
9/1/2008 8:46:58 PM
Total Posts 28

installation failed

Hi joe , I got an error when I run the setup/default.aspx

the error message is:

Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - - 00:00:00.2403456
System.Data.SqlClient.SqlException: in the sub query or ...,text、ntext and image not available。 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at mojoPortal.Data.SqlHelper.ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters) in F:\mojoportal-2-2-6-8-sourcecode\sourcecode\mojoportal\mojoPortal.Data.MSSQL\SQLHelper.cs:line 448 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in F:\mojoportal-2-2-6-8-sourcecode\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 568 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in F:\mojoportal-2-2-6-8-sourcecode\sourcecode\mojoportal\mojoPortal.Data.MSSQL\dbPortal.cs:line 504 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in F:\mojoportal-2-2-6-8-sourcecode\sourcecode\mojoportal\mojoPortal.Business\DatabaseHelper.cs:line 313 - 00:00:01.8226208
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

the system language environment is simple chinese


9/2/2008 4:49:54 AM
Total Posts 18439

Re: installation failed


You didn't mention your database version but I'm guessing it must be SQL 2000 not SQL 2005.

There is one place in the script that I found that I think is a problem for SQL 2000. SQL 2000 doesn't like to use any aggregate functions like "SELECT TOP 1 ..." if you are selecting a text or ntext field.

If you open the script in a text editor (/Setup/applications/mojoportal-core/SchemaInstallScripts/mssql/ and search for "mp_ModuleSettings_SyncDefinitions", you will find the offending procedure. The problem statement within the procedure is:

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

mds.RegexValidationExpression is an ntext field and this poses a problem for SQL 2000. I'm not sure of a good solution. You can chop out that part of the script and it should be able to complete the installation and the site will work, but some of the validation expressions for module setings will be missing or at least it won't be possible to change them on upgrades. I think this procedure is only invoked during upgrades.

If you have any ideas for a good solution I'd be glad to hear them, otherwise I think we may be getting to the end of the line for SQL 2000 support.

If you have SQL 2005 or SQL 2005 Express available I would use one of those.

Hope it helps,


9/2/2008 8:14:59 AM
Total Posts 28

Re: installation failed

Thanks very much.  I will test it tomorrow.

9/9/2008 11:33:32 AM
Total Posts 18439

Re: installation failed

I found that the section of script can be changed like this and it is compatible with MS SQL 2000:

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

Thanks to my friend Dennnis Deming for solving this. It will be fixed in the next release of mojoPortal but you can fix it now with the above change.



9/14/2008 8:17:59 AM
Total Posts 28

Re: installation failed

Thanks very much

You must sign in to post in the forums. This thread is closed to new posts.