HomeHome Product Discus... Product Discus...SmithCartSmithCartDate Localization - Exception Error when saving orderDate Localization - Exception Error when saving order
Previous
 
Next
New Post
10/26/2010 12:12 AM
 

I know this is a problem due to my server being UK etc but I really do need a patch. If I view an order and make any changes on the screen and then press Save I get the following error. This is a real pain because I cannot change the status of orders etc which is starting to be a real problem. Is their any chance you can provide a patch to correct this. Thanks.

Exception Date: 26/10/2010 08:00:08
AssemblyVersion: 5.2.1
ActiveTabName: Buy Now
RawURL: /BuyNow/tabid/343/ctl/ManageOrderDetail/mid/1104/Default.aspx
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
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
10/26/2010 5:02 PM
 

We would need to do date localization for that screen. We just completed the language localization which is about to roll out to beta and currency localization has been in the cart for some time now. Date localization is on the dev list but not scheduled for programming yet but is high on the list I will post back to the forum when it has an eta.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
10/27/2010 3:37 PM
 

Ok Scott, but how do you suggest (as my orders increase) that I keep a record of which ones have been shipped and which ones are still pending?

 
New Post
10/27/2010 3:44 PM
 

Until we get the date localization prioritized into programming here are a few options:

1. Change the status in sql mgmt studio by editing the orders table

2. Use the Indoogrid dnn module

3. Purcchase a couple support credits to get it into programming right away. We have this on the list to do but purchasing support credits prioritizes it up the queue to start right away.

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartDate Localization - Exception Error when saving orderDate Localization - Exception Error when saving order