error creating a new page

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.

3/20/2014 4:03:47 AM

mic.ciotti@live.com

Total Posts 122

View Posts

error creating a new page

Hi Joe, I do have a GREAT problem...

My site runs on Arvixe, sql 2012, aspnet v4.0.30319 Running in Full Trust, Mojo 2.3.9.9 MSSQL

It all works great but suddenly, if I try to create a page, i got the following error
How can I work out ?

PS.. last month I did upgraded to the last version of mojo, but my client did not like new Tiny, so I did downgraded it back to 2.3.9.9.. can this be the problem ?..

help!!!!

thank you so much in advance
Michele from Italy

2014-03-20 01:44:19,942 ERROR (null) - (null) - (null) - mojoPortal.Web.Global - Referrer(http://www.geneskin.org/Admin/PageSettings.aspx?start=873) useragent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0
System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'ShowPageHeading', table 'geneskindb.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, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   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, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   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, Int32 commandTimeout, 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 draftEditRoles, String draftApprovalRoles, String createChildPageRoles, String createChildDraftRoles, 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, Boolean includeInSiteMap, Boolean isClickable, Boolean showHomeCrumb, Boolean isPending, String canonicalOverride, Boolean includeInSearchMap, Boolean enableComments, Boolean includeInChildSiteMap, Boolean expandOnSiteMap, Guid pubTeamId, String bodyCssClass, String menuCssClass, Int32 publishMode, Guid createdBy, String createdFromIp, String menuDescription)
   at mojoPortal.Business.PageSettings.Create()
   at mojoPortal.Web.AdminUI.PageProperties.SavePageData()
   at mojoPortal.Web.AdminUI.PageProperties.Apply_Click(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ClientConnectionId:b97589a3-5b72-4140-a4b8-550445674af4

3/20/2014 5:09:58 AM

mic.ciotti@live.com

Total Posts 122

View Posts

Re: error creating a new page

Hi Joe, after some ivestigation i found a similar question in 1/5/2014 9:49:24 PM

the up and down of version may be coused the problem...

but... how can I work out ???

best

Michele

3/20/2014 8:13:54 AM

Joe Audette

Total Posts 18439

View Posts

Re: error creating a new page

"last month I did upgraded to the last version of mojo, but my client did not like new Tiny, so I did downgraded it back to 2.3.9.9.. can this be the problem ?.."

yes of course that caused the problem, you cannot downgrade because you already upgraded and that made changes to the database that will not be reversed.

To fix the problem upgrade again to the latest version of mojoPortal. If you don't like the new TinyMCE after that then ask a new question about it. It is possible to change back to an older version of TinyMCE without downgrading mojoPortal.

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