x First time here? Check out the FAQ
  • Avatar464posts711karma

    Limit on number of countries?

    Paul Blair started this topic February 24, 2012 @ 03:51 , this topic was edited at: Saturday, February 25, 2012 11:44 PM, Go directly to the topic solution

    Is there a limit on the number of countries that can be loaded. Upon loading the 110th country I get the following error:

    Exception Details: System.InvalidOperationException: Operation is not valid due to the current state of the object.

    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:

    [InvalidOperationException: Operation is not valid due to the current state of the object.]
       System.Web.HttpValueCollection.ThrowIfMaxHttpCollectionKeysExceeded() +2420258
       System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) +58
       System.Web.HttpRequest.FillInFormCollection() +159
    
    [HttpException (0x80004005): The URL-encoded form data is not valid.]
       System.Web.HttpRequest.FillInFormCollection() +217
       System.Web.HttpRequest.get_Form() +104
       System.Web.HttpRequest.get_HasForm() +9038047
       System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) +97
       System.Web.UI.Page.DeterminePostBackMode() +69
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +13

    I'm loading via a SQL script, but the error occurs whether I load the 110th item through the script or manually through the admin section. My script looks like:

    declare @sh int;
    declare @sort int;

    set @Sh=2;

    INSERT INTO [TeaCommerce_Country]
               ([StandardCurrencyId]
               ,[Name]
               ,[CountryCode]
               ,[IsDefault]
               ,[IsDeleted]
               ,[VATGroupId]
               ,[Sort])
    VALUES
    (@sh, 'Sweden', 'SE', 0, 0, 1, 1),
    (@sh, 'United Kingdom', 'UK', 0, 0, 1, 1), ....

    Thanks

    Paul


  • Replies

  • Anders Burla Johansen posted this reply February 24, 2012 @ 08:15

    Hi Paul

    I think taht you have hit the new error than an update to .NET gives you. Please these two links:

    our.umbraco.org/.../28915-Error-when-attempting-to-edit-a-payment-provider-setting
    stackoverflow.com/.../asp-net-ms11-100-how-can-i-change-the-limit-on-the-maximum-number-of-posted-for

    Kind regards
    Anders


  • Avatar464posts711karma
    Comment with ID: 109097
    Paul Blair posted this reply February 25, 2012 @ 11:44

    nice one. Thanks Anders


Please login or Sign up To post replies