Error after upgrading to 2.3.6.7

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

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

7/29/2011 4:26:12 PM

TRIAD - Next Level

Total Posts 17

View Posts

Error after upgrading to 2.3.6.7

After upgrading a site from 2.3.6.5 to 2.3.6.7, we are getting the following error. This is using an MSSQL database. Any ideas on how to fix?

Object cannot be cast from DBNull to other types.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Object cannot be cast from DBNull to other types.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidCastException: Object cannot be cast from DBNull to other types.]
   System.DBNull.System.IConvertible.ToInt32(IFormatProvider provider) +68
   System.Convert.ToInt32(Object value) +48
   mojoPortal.Business.WebHelpers.CacheHelper.LoadMenuPages() +3594
   mojoPortal.Business.WebHelpers.CacheHelper.GetMenuPagesFromContext() +105
   mojoPortal.Web.mojoSiteMapProvider.BuildSiteMap() +109
   mojoPortal.Web.mojoSiteMapProvider.GetRootNodeCore() +20
   System.Web.SiteMapProvider.get_RootNode() +14
   mojoPortal.Web.layout.Page_Load(Object sender, EventArgs e) +339
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +42
   System.Web.UI.Control.OnLoad(EventArgs e) +132
   System.Web.UI.Control.LoadRecursive() +66
   System.Web.UI.Control.LoadRecursive() +191
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2428

Version Information: Microsoft .NET Framework Version:2.0.50727.4961; ASP.NET Version:2.0.50727.4955

7/29/2011 6:29:47 PM

IndigoTea

Total Posts 355

View Posts

Re: Error after upgrading to 2.3.6.7

Your error message is listing .Net 2.0 Framework - are you sure your server settings are correct?

7/30/2011 7:44:21 AM

Joe Audette

Total Posts 18439

View Posts

Re: Error after upgrading to 2.3.6.7

It sounds like somehow the part of the upgrade script that populates the new columns did not run.

I would run this manually:

UPDATE mp_Pages
SET PublishMode = 0

UPDATE mp_Modules
SET PublishMode = 0

the above is taken directly from the upgrade script at

/Setup/applications/mojoportal-core/SchemaUpgradeScripts/mssql/2.3.6.7.config

so it should have run during the upgrade.

Hope that helps,

Joe

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