Hi All,

I did a upgrade of Mojo from 2.3.1.9 to 2.3.3.2

The setup script executed without errors but after that I got following error:

==============================================

Server Error in '/' Application.
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.ToBoolean(IFormatProvider provider) +56
System.Convert.ToBoolean(Object value) +28
mojoPortal.Business.PageSettings.LoadFromReader(IDataReader reader) +1695
mojoPortal.Business.PageSettings.GetPage(Int32 siteId, Int32 pageId) +56
mojoPortal.Business.PageSettings..ctor(Int32 siteId, Int32 pageId) +403
mojoPortal.Business.WebHelpers.CacheHelper.LoadCurrentPage() +163
mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentPage() +69
mojoPortal.Web.SiteUtils.SetMasterPage(Page page, SiteSettings siteSettings, Boolean allowOverride) +29
mojoPortal.Web.UI.CmsPage.SetupMasterPage() +195
mojoPortal.Web.UI.CmsPage.OnPreInit(EventArgs e) +56
System.Web.UI.Page.PerformPreInit() +31
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282


Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.4049


=============================================

Please help.

Thanks and Regards,

Deepak

Hi Joe,

Sorry I forgot to mention about the DB platform. I am using MS SQL 2008 Server

Yes I did visit /setup/Default.aspx and the script ran without errors:

===================================================================

mojoPortal Content Management System
Welcome to mojoPortal Setup
Probing system...
File system permissions ok.
MSSQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
3 site(s) found.
Running script mojoportal-core - 2.3.3.0 - 00:00:00.1376865
Running script mojoportal-core - 2.3.3.1 - 00:00:00.1972530
Running script mojoportal-core - 2.3.3.2 - 00:00:00.2880675
Configuring feature Html Content - 00:00:00.3710700
Configuring feature Site Statistics - 00:00:00.4208715
Configuring feature Web Part - 00:00:00.4267305
Configuring feature Newsletter Sign Up Form - 00:00:00.4286835
Running script blog - 0.0.1.2 - 00:00:00.4501665
Configuring feature Blog - 00:00:00.4677435
Configuring feature Contact Form - 00:00:00.5331690
Configuring feature Event Calendar - 00:00:00.5478165
Configuring feature Feed Manager - 00:00:00.5653935
Configuring feature Flickr Slide Show - 00:00:00.5946885
Configuring feature Image Gallery (Simple Folder Version) - 00:00:00.6064065
Running script forums - 0.0.0.9 - 00:00:00.6171480
Running script forums - 0.0.1.0 - 00:00:00.6259365
Running script forums - 0.0.1.1 - 00:00:00.6317955
Configuring feature Forums - 00:00:00.6376545
Configuring feature Google Map - 00:00:00.6513255
Configuring feature Google Translate - 00:00:00.6708555
Configuring feature Html Fragment Include - 00:00:00.6864795
Configuring feature IFrame - 00:00:00.6923385
Running script imagegallery - 0.0.0.4 - 00:00:00.7138215
Configuring feature Image Gallery - 00:00:00.7343280
Configuring feature Links - 00:00:00.7587405
Configuring feature Live Messenger Chat - 00:00:00.7685055
Configuring feature Poll - 00:00:00.7802235
Running script sharedfiles - 0.0.0.5 - 00:00:00.7890120
Running script sharedfiles - 0.0.0.6 - 00:00:00.8124480
Configuring feature Shared Files - 00:00:00.8222130
Configuring feature Survey - 00:00:00.8310015
Configuring feature Twitter Profile Widget - 00:00:00.8368605
Configuring feature Twitter Search Widget - 00:00:00.8485785
Running script webstore - 0.0.6.0 - 00:00:00.8768970
Running script webstore - 0.0.6.1 - 00:00:00.9179100
Configuring feature Web Store - 00:00:00.9579465
Configuring feature Xml/Xsl - 00:00:00.9657585
Ensuring all features are installed in server admin sites... - 00:00:00.9686880
Setup is complete, click the link below to go to the home page.
Site Home Page

Database PlatformMSSQL
Version2.3.3.2
StatusYour installation is up to date.

Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

====================================================================

Thanks for the quick response.

Regards,

Deepak

Hello Joe,

I checked EnableComment column in mp_page table and they were all set to '0'. I still ran "UPDATE [dbo].mp_Pages
SET EnableComments = 0" in the query analyser and I continue to get the same error.

Thanks,

Deepak

Hello Joe,

I did an upgrade from 2.3.1.9 to 2.3.3.2 and I also checked the script files and they are all present from 2.3.2.0 up to 2.3.3.9.

I wonder what exactly the issue was. I will keep you posted if I find something that answers the problem.

Thanks,

Deepak