• Forums
  • Bug Reports
  • Page Crash (When I click on edit or access a page with contact form)

Page Crash (When I click on edit or access a page with contact form)

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.
12/10/2010 3:30:13 PM
valzero
Gravatar
Total Posts 16
View Posts

Page Crash (When I click on edit or access a page with contact form)

System Information
mojoPortal Version 2.3.5.5 MSSQL
Operating System Microsoft Windows NT 6.0.6002 Service Pack 2
ASP.NET Info v4.0.30319 Running in Partial Trust
Server Time Zone Mountain Standard Time
Server Local Time (GMT -7) 12/10/2010 2:26:15 PM
Greenwich Mean Time (GMT/UTC) 12/10/2010 9:26:15 PM
Feature Versions
Feature Schema Version
blog 0.0.1.9
contactform 0.0.0.5
eventcalendar 0.0.0.5
feed-manager 0.0.0.9
forums 0.0.1.8
imagegallery 0.0.0.7
linksmodule 0.0.0.7
pollfeature-byChristianFredh 0.0.0.5
sharedfiles 0.0.0.9
surveyfeature 0.0.1.7
webstore 0.0.7.0
 

I could not resist to upgrade but I am now getting all kinds of errors. I am sure is something I did terribly wrong. here is my log file:

2010-12-09 16:22:39,169 INFO mojoPortal.Web.Global - Application Started.
2010-12-09 16:22:39,450 ERROR mojoPortal.Web.WebTaskManager - System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'mp_TaskQueue_DeleteCompleted'.
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()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at mojoPortal.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at mojoPortal.Data.DBTaskQueue.DeleteCompleted()
at mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted)
2010-12-09 16:22:40,183 ERROR mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2010-12-09 16:22:40,183 ERROR mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2010-12-09 16:22:40,183 ERROR mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2010-12-09 16:22:40,277 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:22:40,448 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-12-09 16:22:40,448 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:22:40,557 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-12-09 16:22:40,557 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:22:40,698 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-12-09 16:22:40,698 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:22:40,791 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:22:40,854 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:30:26,798 ERROR mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2010-12-09 16:30:26,907 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:30:27,047 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-12-09 16:30:27,125 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:39:48,464 ERROR mojoPortal.Web.BannedIPBlockingHttpModule - handled exception:
System.InvalidOperationException: The stored procedure 'mp_BannedIPAddresses_Exists' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at mojoPortal.Data.DBBannedIP.IsBanned(String ipAddress)
at mojoPortal.Web.BannedIPBlockingHttpModule.BeginRequest(Object sender, EventArgs e)
2010-12-09 16:39:48,557 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:39:48,588 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-12-09 16:39:48,620 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:39:48,807 ERROR mojoPortal.Web.PageNotFoundHttpModule - 207.46.13.47 PageNotFoundHttpModule handled error.
System.Web.HttpException (0x80004005): The file '/hot-on-brickell.aspx' does not exist.
at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path)
at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
2010-12-09 16:40:50,599 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:50,770 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:50,833 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:50,926 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:50,989 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:51,036 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:51,067 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings
System.InvalidOperationException: The stored procedure 'mp_Sites_SelectOneByHost' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at mojoPortal.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at mojoPortal.Data.SqlParameterHelper.InitializeArray()
at mojoPortal.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
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-12-09 16:40:51,129 ERROR mojoPortal.Business.WebHelpers.CacheHelper - Error trying to obtain siteSettings t System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)


 

12/10/2010 3:52:18 PM
Asad Samarian
Gravatar
Total Posts 550
View Posts

Re: Page Crash (When I click on edit or access a page with contact form)

Hi,

It seems may of stored procedure deleted from your database. Adding stored procedures to your database manualy via SQL Server management Studio may solve your problem.

Hope Helps,

Asad

 

 

12/10/2010 3:58:15 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Page Crash (When I click on edit or access a page with contact form)

Those errors will always be logged during a new installation because database objects did not exist until after the setup runs. It has nothing to do with the problem you describe about the contact form in the title of this thread.

  1. clear the log
  2. cause the problem with the contact form
  3. check the log again and now you may see the real error

Hope it helps,

Joe

12/10/2010 4:17:08 PM
valzero
Gravatar
Total Posts 16
View Posts

Re: Page Crash (When I click on edit or access a page with contact form)

I did make a backup of the database on a different server and uploaded on the new sql server.

Clear the log and repeated the error, Here it is:

2010-12-10 15:15:03,024 ERROR mojoPortal.Web.mojoBasePage - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=29&pageid=0
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:03,102 ERROR mojoPortal.Web.Global - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=29&pageid=0
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:06,456 ERROR mojoPortal.Web.mojoBasePage - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=32&pageid=0
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:06,534 ERROR mojoPortal.Web.Global - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=32&pageid=0
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:12,166 ERROR mojoPortal.Web.mojoBasePage - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=58&pageid=11
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:12,353 ERROR mojoPortal.Web.Global - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=58&pageid=11
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:17,907 ERROR mojoPortal.Web.mojoBasePage - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=24&pageid=10
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2010-12-10 15:15:17,969 ERROR mojoPortal.Web.Global - 174.61.118.225-en-US - /HtmlEdit.aspx?mid=24&pageid=10
System.NullReferenceException: Object reference not set to an instance of an object.
at mojoPortal.Web.SiteUtils.SetupEditor(EditorControl editor, Boolean useSkinCss, String preferredProvider)
at mojoPortal.Web.ContentUI.EditHtml.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 

12/11/2010 6:19:33 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Page Crash (When I click on edit or access a page with contact form)

I would try uploading all the files again, possibly not all the files made it when you uploaded them.

6/19/2011 5:39:40 PM
msc
Gravatar
Total Posts 3
View Posts

Re: Page Crash (When I click on edit or access a page with contact form)

This solved an issue for me.  When I uploaded the new files I forgot to do the root folder.  Thanks for the post.

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