Thread: V9 Admin site failing

When I click on the Configuration -> Advance - App Parameters I get this in version 9
Server Error in '/' Application.
--------------------------------------------------------------------------------

Cannot have multiple items selected in a DropDownList.
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.Web.HttpException: Cannot have multiple items selected in a DropDownList.

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:


[HttpException (0x80004005): Cannot have multiple items selected in a DropDownList.]
System.Web.UI.WebControls.DropDownList.VerifyMulti Select() +124
System.Web.UI.WebControls.ListControl.RenderConten ts(HtmlTextWriter writer) +10842421
System.Web.UI.WebControls.WebControl.Render(HtmlTe xtWriter writer) +42
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.HtmlControls.HtmlContainerControl.Re nder(HtmlTextWriter writer) +42
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.HtmlControls.HtmlTableRow.RenderChil dren(HtmlTextWriter writer) +57
System.Web.UI.HtmlControls.HtmlContainerControl.Re nder(HtmlTextWriter writer) +42
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.UpdatePanel.RenderChildren(HtmlTextW riter writer) +288
System.Web.UI.UpdatePanel.Render(HtmlTextWriter writer) +53
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.WebControls.WebControl.RenderContent s(HtmlTextWriter writer) +13
System.Web.UI.WebControls.WebControl.Render(HtmlTe xtWriter writer) +42
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.HtmlControls.HtmlForm.RenderChildren (HtmlTextWriter writer) +253
System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTex tWriter output) +87
System.Web.UI.HtmlControls.HtmlForm.RenderControl( HtmlTextWriter writer) +53
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +240
System.Web.UI.Page.Render(HtmlTextWriter writer) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.4200; ASP.NET Version:2.0.50727.4016

Anyone know the solution to this?

Connect to the database in SSMS and open up the Store table. See if you have more than one row in there, and if so remove the extras. Sometimes if an upgrade script is run against the DB multiple times due to failed attempts or errors, you can end up with duplicates.

Yeah there are more than 1 in there, how do I know which ones to remove, they all loo the same except the StoreGuid and the creation date.

Doesn't matter for ML9, just axe everything after row 1

can do, I'm good at axing stuff.....