problem on host

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.

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

9/17/2008 6:24:54 AM

jaber1361

Total Posts 2

View Posts

problem on host

2008-09-17 15:36:51,187 [4544] ERROR mojoPortal.Web.Global [(null)] - 10.4.10.33-fa-IR - /Admin/PageSettings.aspx?start=0
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'PageID', table 'newnoornet.dbo.mp_Pages'; column does not allow nulls. INSERT fails.
The statement has been terminated.
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(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at mojoPortal.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at mojoPortal.Data.DBPageSettings.Create(Int32 siteId, Int32 parentId, String pageName, String pageTitle, String skin, Int32 pageOrder, String authorizedRoles, String editRoles, String createChildPageRoles, Boolean requireSsl, Boolean allowBrowserCache, Boolean showBreadcrumbs, Boolean showChildPageBreadcrumbs, String pageKeyWords, String pageDescription, String pageEncoding, String additionalMetaTags, Boolean useUrl, String url, Boolean openInNewWindow, Boolean showChildPageMenu, Boolean hideMainMenu, Boolean includeInMenu, String menuImage, String changeFrequency, String siteMapPriority, Guid pageGuid, Guid parentGuid, Boolean hideAfterLogin, Guid siteGuid, String compiledMeta, DateTime compiledMetaUtc)
at mojoPortal.Business.PageSettings.Create()
at mojoPortal.Business.PageSettings.Save()
at mojoPortal.Web.AdminUI.PageProperties.SavePageData()
at mojoPortal.Web.AdminUI.PageProperties.Apply_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.admin_pagesettings_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

9/17/2008 6:38:17 AM

Joe Audette

Total Posts 18439

View Posts

Re: problem on host

Let me guess, you did something like import the tables from one database to another. Sorry but by doing that you lost a lot of important things in the database schema like the mp_Pages table has an auto identity column to generate the pageid, indexes, foriegn keys etc are all lost. So now you get this error because its not generating the id.

The only way to move a database and keep it intact is to back it up and then restore it on the new machine. The only other option is to delete every table and stored procedure and then let setup page re-create them, but you will lose all data that way and will be starting with a new site.

Hope it helps,

Joe

9/17/2008 11:55:16 PM

jaber1361

Total Posts 2

View Posts

Re: problem on host

thanks,

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