HomeHome Product Discus... Product Discus...SmithCartSmithCartException Error when editing orderException Error when editing order
Previous
 
Next
New Post
9/20/2010 10:29 AM
 

I am using SmithCard in the UK so the date format is dd/mm/yyyy which would appear to be causing an issue when you try and edit an Open order because the following exception error occurs when you press the Save button.

RawURL: /BuyNow/tabid/343/ctl/ManageOrderDetail/mid/1104/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.1.13) Gecko/20100914 Firefox/3.5.13 ( .NET CLR 3.5.30729; .NET4.0C)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: af42c19b-02ec-4544-b31b-275b1afb0818
InnerException: Failed to convert parameter value from a String to a DateTime.
Method: System.DateTimeParse.Parse
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Failed to convert parameter value from a String to a DateTime. ---> System.FormatException: Failed to convert parameter value from a String to a DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value, IFormatProvider provider) at System.String.System.IConvertible.ToDateTime(IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) --- End of inner exception stack trace --- at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType) at System.Data.SqlClient.SqlParameter.GetCoercedValue() at System.Data.SqlClient.SqlParameter.Validate(Int32 index, Boolean isCommandProc) at System.Data.SqlClient.SqlCommand.SetUpRPCParameters(_SqlRPC rpc, Int32 startCount, Boolean inSchema, SqlParameterCollection parameters) at System.Data.SqlClient.SqlCommand.BuildRPC(Boolean inSchema, SqlParameterCollection parameters, _SqlRPC& rpc) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.UpdateStoreOrders(Int32 orderID, Int32 customerID, DateTime orderDate, Int32 payHistID, Decimal ShippingTotal, Decimal taxTotal, Decimal HandlingCharge, String ShipFirstName, String ShipLastName, String ShipAddress1, String ShipAddress2, String ShipCity, String ShipState, String ShipZipcode, String ShipCountry, String Status, String ShipMethod, String AffiliateId, Int32 couponId, Decimal discount, Decimal memberDiscount, String memberRole, String TrackingNumber, String SpecialInstructions, Decimal Surcharge, DateTime ShipDate, String UDF1, String UDF2, String UDDropDown, String UDDate, String PDTextbox) at Smith.DNN.Modules.BuyNow.ProductsController.UpdateStoreOrders(StoreOrdersInfo objStoreOrders) at Smith.DNN.Modules.BuyNow.ManageOrderDetail.btnSave_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

 
New Post
9/21/2010 9:35 PM
 

We are working on language localization and its about 4-6 weeks out. There may be something we can do to localize dates in the interim to fix the issue you reported I will post back if we can locaize dates before language localization is released.

Dave


At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
9/21/2010 11:39 PM
 

Thanks.

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartException Error when editing orderException Error when editing order