Hi

I have moved a site and made an upgrade from version 2.3.3.4 to version 2.3.4.1.

Setup have run smootly and declare schema and everything ready.

But when I hit any url it gives me this invaluable error description below. Any clues to what to do?

Server Error in '/' Application.
--------------------------------------------------------------------------------

Could not find specified column in results
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.IndexOutOfRangeException: Could not find specified column in results

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:

[IndexOutOfRangeException: Could not find specified column in results]
MySql.Data.MySqlClient.MySqlDataReader.GetOrdinal(String name) +150
MySql.Data.MySqlClient.MySqlDataReader.get_Item(String name) +15
mojoPortal.Business.PageSettings.LoadFromReader(IDataReader reader) +1773
mojoPortal.Business.PageSettings.GetPage(Int32 siteId, Int32 pageId) +56
mojoPortal.Business.PageSettings..ctor(Int32 siteId, Int32 pageId) +411
mojoPortal.Business.WebHelpers.CacheHelper.LoadCurrentPage() +162
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.3082; ASP.NET Version:2.0.50727.3082

Best regards, Lars

Thanks - this is maybe the way to go.

I did already run that script and therefore CreateChildDraftRoles column stopped with an error of already being there.

But that made me rember that during the upgrade the setup scripts requested a missing (empty) table mp_SavedQuery. Looking into the scripts that table was created already in version 2.3.3.3, which indicates that I missed some earlier scripts. I can also see I miss one coloumn in mp_Pages called EnableComments. This is absolutely my fault I would imagine - I may have missed some scripts during previous upgrades.

Anyway, is there a safe way to upgrade from earlier versions after a maybe partial upgrade to 2.3.3.4. Or do I have to adjust line by line manually?

Best regards

Lars

YES!!

I looked into the table for SchemaScriptHistory and for some reason it had only updated until version 2.3.3.0 earlier. But the marked version in table ScemaVersion said 2.3.3.4. Then I checked the versions for the other features as well - those were ok.

So I took the chance to change ScemaVersion value to 2.3.3.0 and then run Setup. This time there were no missing table errors or anything, the setup went through smoothly and wupti, the site was up running with version 2.3.4.1. Fantastic!

Please keep that table SchemaScriptHistory in there for future releases - that's a life safer :)

Thanks, Joe

Lars