errors after updating to new version, then falling back to older version

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
3/20/2015 9:59:47 AM
Gravatar
Total Posts 49
TRIAD/Next Level Interactive

errors after updating to new version, then falling back to older version

Hi all ---

I attempted to upgrade my 2.3.6.5 site to mojoPortal 2.3.9.7. After experiencing some issues, we decided it would be best to revert back to 2.3.6.5.

Now, I am receiving many database column related issues when adding new pages, content, blog articles, etc.

Example: "Cannot insert the value NULL into column 'ExcludeFromRecentContent'"

I don't have an old database copy that I can restore (I wish!). What can I do to get my DB back where it needs to be?

Thanks, thanks, and thanks!

3/20/2015 11:00:57 AM
Gravatar
Total Posts 1196
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: errors after updating to new version, then falling back to older version

If you didn't take a backup of your 2.3.6.5 site before you started the upgrade, then how did you attempt to revert? The only reliable way to undo an upgrade would be to replace the web file tree (except most files under /Data), and restore a database backup.

3/20/2015 1:07:49 PM
Gravatar
Total Posts 49
TRIAD/Next Level Interactive

Re: errors after updating to new version, then falling back to older version

I upgraded by dragging the 2.3.9.7 files over via FTP and overwriting the old ones. And then later, I overwrite the codebase again with the 2.3.6.5 files. I never manually touched the database during any of this.

Now, I get this message on setup: "You need to upgrade the Web Site and Database Code to the same version as the Database Schema."

How can I get my database in order? Thanks for the response... I appreciate the advice!

 

3/20/2015 5:19:55 PM
Gravatar
Total Posts 1196
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: errors after updating to new version, then falling back to older version

You don't have to have manually done anything in the database. As soon as the new schema upgrade scripts were uploaded to the web site, and the site encountered a SQL exception in a mojoPortal core table, it would have immediately run the DB upgrade process (the same one that runs when you visit  /setup/default.aspx after uploading new release files, as documented in the Upgrading From Previous Versions document).

Once the DB upgrade process has been run, the only way to go backward would be to go through all of the SQL scripts under /Setup/Applications/.../SchemaUpgradeScripts/[dbtype], and try to figure out a way to manually reverse what each one of them did, starting with 2.3.9.7 and working backwards through 2.3.6.6. It's theoretically possible to do this, unless any of the scripts include one-way transformations or data conversions that can't be undone. Just to give you an idea of what would be involved, mojoportal-core alone has 32 SQL scripts that would have run during an upgrade from 2.3.6.5 to 2.3.9.7.

I used "..." in the above path, because in addition to mojoportal-core, you'd have to go through the same process for every other feature delivered by mojoPortal. And of course, your site will have to be kept down while this process is worked through.

Because of the colossal amount of worked involved, and no guarantee of ultimate success, my recommendation would be to restore the files for 2.3.9.7 and try to work through any issues you have found, by posting specific problems here on the forum. Don't forget to make any necessary skin changes as listed in the Important Skin Changes document.

Sorry I don't have better news for you.

3/27/2015 1:48:20 PM
Gravatar
Total Posts 49
TRIAD/Next Level Interactive

Re: errors after updating to new version, then falling back to older version

Thanks for the help, Jamie! We took your advice and restored 2.3.9.7. We then upgraded to the 2.3.9.8 files. Everything looks fine on setup, but when I visit any page I receive the following error:

[FormatException: Input string was not in a correct format.] System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +14232793 System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +305 mojoPortal.Business.PageSettings.LoadFromReader(IDataReader reader) +3358 mojoPortal.Business.PageSettings.GetPage(Int32 siteId, Int32 pageId) +54 mojoPortal.Business.PageSettings..ctor(Int32 siteId, Int32 pageId) +1244 mojoPortal.Business.WebHelpers.CacheHelper.LoadPage(Int32 pageID) +194 mojoPortal.Business.WebHelpers.CacheHelper.LoadCurrentPage() +122 mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentPage() +196 mojoPortal.Web.SiteUtils.GetSkinName(Boolean allowPageOverride, Page page) +65 mojoPortal.Web.mojoBasePage.SetupMasterPage() +291 mojoPortal.Web.mojoBasePage.OnPreInit(EventArgs e) +617 System.Web.UI.Page.PerformPreInit() +49 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1844

Any idea where the problem may lie?

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34009

 

 

3/27/2015 2:11:57 PM
Gravatar
Total Posts 18439

Re: errors after updating to new version, then falling back to older version

seems to me you have unexpected null values for integer columns in mp_Pages table that should not be null.

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