I have a set of 200+ countries which the postal service delivers to, so instead of creating each country manually in the front-end I inserted them through SQL.
I watched the SQL profiler to see which tables it "touched" and replicated it for the 200+ countries.
The issue now is that when I update the Shipping Methods in the front-end the following error occurs and the records are not saved.
What am I missing?
Here's the stack-trace.
At /umbraco/plugins/teacommerce/settings/orders/EditShippingMethod.aspx?id=4 (Referred by: http://localhost/umbraco/plugins/teacommerce/settings/orders/EditShippingMethod.aspx?id=4): System.Web.HttpException (0x80004005): The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
It seems like it's either a record that's causing it or simply the number of records because when I reduced the number to 100 countries it worked fine.
I will investigate it further, my feeling is that it could be an encoding issue.
Inserting countries by SQL
Hi,
I have a set of 200+ countries which the postal service delivers to, so instead of creating each country manually in the front-end I inserted them through SQL.
I watched the SQL profiler to see which tables it "touched" and replicated it for the 200+ countries.
The issue now is that when I update the Shipping Methods in the front-end the following error occurs and the records are not saved.
What am I missing?
Here's the stack-trace.
At /umbraco/plugins/teacommerce/settings/orders/EditShippingMethod.aspx?id=4 (Referred by: http://localhost/umbraco/plugins/teacommerce/settings/orders/EditShippingMethod.aspx?id=4): System.Web.HttpException (0x80004005): The URL-encoded form data is not valid. ---> System.InvalidOperationException: Operation is not valid due to the current state of the object. at System.Web.HttpValueCollection.FillFromEncodedBytes(Byte[] bytes, Encoding encoding) at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.FillInFormCollection() at System.Web.HttpRequest.get_Form() at System.Web.HttpRequest.get_HasForm() at System.Web.UI.Page.GetCollectionBasedOnMethod(Boolean dontReturnNull) at System.Web.UI.Page.DeterminePostBackMode() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Hi Bernard,
Did you recycle the website after inserting the countries? There might be a difference between the DB and the Tea Commerce cache.
All in all there should be no problem in importing countries like you do. In fact we did it ourselves and I wrote this small blog post about it:
http://rune.gronkjaer.dk/en-US/2011/04/12/tea-commerce-dynamic-vat/
/Rune
Hi Rune,
It seems like it's either a record that's causing it or simply the number of records because when I reduced the number to 100 countries it worked fine.
I will investigate it further, my feeling is that it could be an encoding issue.
Cheers,
Ahh, yes. Encoding sounds probable as well. Bad data somehow. Please let us know if you find the source of the problem.
/Rune
is working on a reply...