• Forums
  • Bug Reports
  • Exception trying to install mojoportal with web platform installer with MSSQL 2000

Exception trying to install mojoportal with web platform installer with MSSQL 2000

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

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.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
4/21/2009 3:47:16 AM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Exception trying to install mojoportal with web platform installer with MSSQL 2000

EXCEPTION: Microsoft.Web.Deployment.DeploymentException: The database 'mojoportal_globizz' could not be created. ---> System.Data.SqlClient.SqlException: Invalid object name 'sys.databases'.
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 Microsoft.Web.Deployment.DBInfo.CreateDatabase()
--- End of inner exception stack trace ---
at Microsoft.Web.Deployment.DeploymentObject.Add(DeploymentObject source, DeploymentSyncContext syncContext)
at Microsoft.Web.Deployment.DeploymentSyncContext.HandleUpdate(DeploymentObject destObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildrenOrder(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.SyncChildren(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.ProcessSync(DeploymentObject destinationObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentObject.SyncToInternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(String provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.PlatformInstaller.MsDeployProxy.Install(InstallerItemInstallContext context, RemoteCredentials remoteCredentials)
 

4/21/2009 5:55:18 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Exception trying to install mojoportal with web platform installer with MSSQL 2000

Hi Alexander,

I guess the platform installer doesn't support SQL 2000. Its not a mojoPortal bug, there is nothing I can do about it. The stack trace does not refer to any mojoPortal code, it looks like code internal to the deployment tool.

It doesn't really surprise me if they only support SQL 2005-2008.

All I do to package mojoPortal for MsDeploy is to make a few config files. It would be nice if they suported a switch to skip db creation, then you could at least use it to install the files and set permission and IIS config. If I learn of a way to configure it to do that I will certainly do it.

mojoPortal does still support SQL 2000 but I guess you will have to install it the old fashioned way.

Or, you could install the SQLite package and then replace the *Data.dll files with the ones from MS SQL version then set the connection string yourself in user.config.

Best,

Joe 

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