My site was working fine locally I uploaded it to the server and the setup process ran some mssql upgrade scripts and now I am receiving am error that has stopped the site.  

The config log entry is;
2011-06-26 22:01:38,015 INFO mojoPortal.Web.Global - Global.asax.cs Application_End
2011-06-26 22:01:59,921 INFO mojoPortal.Web.Global - Application Started.
2011-06-26 22:02:00,531 ERROR mojoPortal.Web.mojoBasePage - 78.121.97.159-en-GB - /Default.aspx
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
   at System.Guid..ctor(String g)
   at mojoPortal.Business.PageSettings.LoadFromReader(IDataReader reader)
   at mojoPortal.Business.PageSettings.GetPage(Int32 siteId, Int32 pageId)
   at mojoPortal.Business.PageSettings..ctor(Int32 siteId, Int32 pageId)
   at mojoPortal.Business.WebHelpers.CacheHelper.LoadCurrentPage()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentPage()
   at mojoPortal.Web.SiteUtils.GetMasterPage(Page page, SiteSettings siteSettings, Boolean allowOverride)
   at mojoPortal.Web.UI.CmsPage.SetupMasterPage()
   at mojoPortal.Web.UI.CmsPage.OnPreInit(EventArgs e)
   at System.Web.UI.Page.PerformPreInit()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2011-06-26 22:02:00,546 ERROR mojoPortal.Web.Global - 78.121.97.159-en-GB - /Default.aspx
System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
   at System.Guid..ctor(String g)
   at mojoPortal.Business.PageSettings.LoadFromReader(IDataReader reader)
   at mojoPortal.Business.PageSettings.GetPage(Int32 siteId, Int32 pageId)
   at mojoPortal.Business.PageSettings..ctor(Int32 siteId, Int32 pageId)
   at mojoPortal.Business.WebHelpers.CacheHelper.LoadCurrentPage()
   at mojoPortal.Business.WebHelpers.CacheHelper.GetCurrentPage()
   at mojoPortal.Web.SiteUtils.GetMasterPage(Page page, SiteSettings siteSettings, Boolean allowOverride)
   at mojoPortal.Web.UI.CmsPage.SetupMasterPage()
   at mojoPortal.Web.UI.CmsPage.OnPreInit(EventArgs e)
   at System.Web.UI.Page.PerformPreInit()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Any ideas, Thanks.

Vince.

Hi IndigoTea,

The site is at www.fpan.net, or it was until I tried to upgrade it.  The site literally fell apart during the upgrade to 2.3.6.6, the database is now corrupt, I can't log in and no pages are being displayed.  I do have a very limited amount of custom functionality, but surely not enough to cause this mayhem.  The latest series of errors relate to "Unknown server tag 'portal:OuterWrapperPanel'.   

Thanks again for your reply, but I think this is a case of hacking my way through it.

Best Regards,

Vince.

Hi Joe,

Yes I know, but I didn't think the upgrade would cause this problem, the database is obviously corrupt as I am still getting the Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) error.

I didn't touch the database, mojoPortal decided all by itself to run the setup scripts, it wouldn't let get pass the please set "disablesetup" in web.config.

I uploaded the 2.3.6.6 files, amended the web.config, user.config and off it went.  If I swap back to the backed up database, that doesn't work either, I have to go back to a previous version and lose some pages. That does work, but then I am faced with a plethora script errors, such as the Outer Wrapper one and for example;
2011-06-27 10:39:56,375 ERROR mojoPortal.Web.Global - 207.46.195.231-en-US - /house-buying-is-seasonal.aspx
System.Web.HttpParseException: The base class includes the field 'gmap', but its type (mojoPortal.Web.UI.LocationMap) is not compatible with the type of control (mojoPortal.Web.Controls.google.LocationMap).

Which is strange because as far as I know I don't use a Google map anywhere.

I appreciate your response Joe, I will just have to work my way through it, the real pain is that I had some prospective clients who were going to look at the site today. Still, it will not happen again, measure twice and cut once etc.

Best Regards,

Vince.

Hi Joe,

Sorry if I gave that impression, it was certainly not my intention, mojoPortal is a fantastic CMS system and I really do appreciate how much effort you put into the project.

With regard to the database, I didn't move the local database to the server, I just updated the file system on the server with the new mojoPortal files and left the database as it was.

I was in a hurry and that has caused these issues, as soon as I have resolved it I will let you know how.

Best Regards,

Vince.

Hi Joe,

The error is being produced at line 587 in PageSettings.cs in LoadFromReader()

this.pubTeamId = new Guid(reader["PubTeamId"].ToString());

Format Exception - Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

Is this rectifiable?

Best Regards,

Vince.

Hi Joe,

All is well now, I took a copy of the latest source code, linked my local project to the remote database and worked through it.

My problems arose due to my workflow, the local and remote databases were synchronised in terms of objects, but not data, so I had the correct columns in the table, but not the default data. The GUID error was caused by a NULL return as opposed to the expected empty GUID, a result of not running the upgrade scripts on both the local and remote databases.   

Lesson learnt!

Thanks for all help.

Vince.