Problem while upgrade mojo portal version from 2.3.9.7 to

Problem while upgrade mojo portal version from 2.3.9.7 to 2.4.0.2

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.

1/8/2014 3:25:23 AM

prafullpokale

Total Posts 18

View Posts

Problem while upgrade mojo portal version from 2.3.9.7 to 2.4.0.2

Hi Joe,

I am currently using mojo portal version 2.3.9.7 and sql database 2005.

I want to upgrade mojo portal version from 2.3.9.7 to latest version 2.4.0.2.

I took backup of old sql database (for mojo portal code - 2.3.9.7) and restore into new database wherever using mojo portal code 2.4.0.2 and run the setup script such as setup/default.aspx page.But i am getting error as follows,

System.IndexOutOfRangeException: DraftApprovalRoles
"this.draftApprovalRoles = reader["DraftApprovalRoles"].ToString();"

stack trace :

[IndexOutOfRangeException: DraftApprovalRoles]
   System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +5328314
   System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +61
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +15
   mojoPortal.Business.PageSettings.LoadFromReader(IDataReader reader) in d:\Demos\mojoPortal.Business\PageSettings.cs:686
   mojoPortal.Business.PageSettings.GetPage(Int32 siteId, Int32 pageId) in d:\Demos\mojoPortal.Business\PageSettings.cs:654
   mojoPortal.Business.PageSettings..ctor(Int32 siteId, Int32 pageId) in d:\Demos\mojoPortal.Business\PageSettings.cs:47
   mojoPortal.Business.WebHelpers.CacheHelper.LoadPage(Int32 pageID) in d:\Demos\Web\Components\CacheHelper.cs:739
   mojoPortal.Business.WebHelpers.CacheHelper.LoadCurrentPage() in d:\Demos\Web\Components\CacheHelper.cs:696
   mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentPage() in d:\Demos\Web\Components\CacheHelper.cs:666
   mojoPortal.Web.SiteUtils.GetSkinName(Boolean allowPageOverride, Page page) in d:\Demos\Web\Components\SiteUtils.cs:2047
   mojoPortal.Web.mojoBasePage.SetupMasterPage() in d:\Demos\Web\Components\mojoBasePage.cs:1059
   mojoPortal.Web.mojoBasePage.OnPreInit(EventArgs e) in d:\Demos\Web\Components\mojoBasePage.cs:1009
mojoPortal.Web.UI.CmsPage.OnPreInit(EventArgs e) in d:\Demos\Web\Default.aspx.cs:51
   System.Web.UI.Page.PerformPreInit() +31
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +335

Thanks in advance for your help.

Prafull

1/8/2014 11:47:30 AM

Joe Audette

Total Posts 18439

View Posts

Re: Problem while upgrade mojo portal version from 2.3.9.7 to 2.4.0.2

The setup page should run the upgrade scripts and that would add any missing columns. This error means it did not run all the upgrade scripts. The mp_Pages table is missing the column DraftApprovalRoles which should have been added by one of the upgrade scripts.

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