Hi,

Version: 2.3.3.9
DataBase: MSSQL

I am stumped. I have installed many a web application in my time but I just figure this one out. I have other web apps installed which access the same database with the same connection string with no issues.

The install on my development machine was a breeze. No problems at all. However I am trying to install it on in my web hosting environment and it just won't!

This is what I did:

1. Downloaded the zip file with the latest version (no source)
2. Uploaded to the site and it all the files were happily extracted to wwwroot.
3. I edited the connection string in the web.config.medium file and renamed it to web.config.
4. I gave the IIS user write permissions to every subdirectory under wwwroot (just in case).
5. I access the /setup/Default.aspx file and this is what I get in the currentlog.config file:

2010-03-25 23:13:54,662 ERROR mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.Data.SqlClient.SqlException: Could not find stored procedure 'mp_BannedIPAddresses_Exists'.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at mojoPortal.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at mojoPortal.Data.SqlParameterHelper.ExecuteScalar()
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Business.BannedIPAddress.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2010-03-25 23:13:54,678 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.Data.SqlClient.SqlException: Could not find stored procedure 'mp_Sites_SelectOneByHost'.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at mojoPortal.Data.SqlParameterHelper.ExecuteReader()
at mojoPortal.Data.DBSiteSettings.GetSite(String hostName)
at mojoPortal.Business.SiteSettings.GetSiteSettings(String hostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2010-03-25 23:13:54,678 ERROR mojoPortal.Web.UrlRewriter - System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.UrlRewriter.GetRedirectUrl(String targetUrl)
at mojoPortal.Web.UrlRewriter.RewriteUrl(HttpApplication app)
2010-03-25 23:13:54,678 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.Data.SqlClient.SqlException: Could not find stored procedure 'mp_Sites_SelectOneByHost'.
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.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at mojoPortal.Data.SqlParameterHelper.ExecuteReader()
at mojoPortal.Data.DBSiteSettings.GetSite(String hostName)
at mojoPortal.Business.SiteSettings.GetSiteSettings(String hostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()

Help!
 

The setup page displayed:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator to inform of the time the error occurred and of anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Now I have switched the directory and web.config to Full Trust and I get the same result.

Ha! Ok, I am a bit confused now. I have edited the web.config in wwwroot (root of mojoPortal) and set 

<customErrors mode="Off" />

and I am still not seeing the actual error, only the generic IIS error.

I will buy you a few beers if we can solve this. :-)

OMG!

I changed a few settings in the web.config/IIS:

1. Changed site culture and UI culture to Invariant.

2. I turned this option on: Allow application execution in MTA (multi-threaded apartment) mode

3. I might have changed a couple of others which I don't remember now...it's VERY late here in Australia.

and the damn thing worked!

For everyone else's benefit I would love to find out which change did it. I am going to bed now but if I have time tommorrow I will try to replicate it.

Thank you for your help Joe. You have created a great product.

Greg.