This question is locked. New answers and comments are not allowed.
When I studied Sitefinity, I got the problem.
I can't resolved them, could you help me?
I added a page with the the Ecommerce\ProductList widget and it can display productslist and detail,
but when I click 'Add to cart' button, I always get a error:This item cannot be added to your shopping cart at this time.
This is the log:
----------------------------------------
Timestamp: 08/05/2013 06:21:51
Message: Telerik.OpenAccess.Exceptions.DataStoreException: Insert of '218030711-6c9ec94c-d448-6d6e-aac0-ff0000b478a2' failed: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
INSERT INTO [sf_ec_cart_order] ([id], [rental_from], [rental_to], [application_name], [currency], [discount_total], [effective_tax_rate], [exchange_rate_discount_total], [exchange_rate_pre_tax_total], [exchange_rate_sub_total], [exchnge_rate_sub_total_display], [exchange_rate_tax], [exchange_rate_total], [last_modified], [order_attempts], [order_date], [order_number], [order_status], [pre_discount_tax], [pre_tax_price], [pre_tax_total], [shipping_carrier_name], [shipping_method_id], [shipping_service_name], [shipping_tax], [shipping_tax_rate], [shipping_total], [sub_total_display], [tax], [ttal], [weight], [voa_version]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
(set event logging to all to see parameter values) System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes) ---> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute()
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
--- End of inner exception stack trace ---
at DynamicModule.ns.Wrapped_OpenAccessOrdersDataProvider_55ae7dccfca94aaab61711f382ce54f9.CommitTransaction()
at Telerik.Sitefinity.Data.ManagerBase`1.SaveChanges(String eventOrigin)
at Telerik.Sitefinity.Data.ManagerBase`1.SaveChanges()
at Telerik.Sitefinity.Modules.Ecommerce.Orders.Business.TaxCalculator.UpdateCartDetailTaxInformation(CartOrder cartOrder, IEnumerable`1 taxes, IOrdersManager manager)
at Telerik.Sitefinity.Modules.Ecommerce.Orders.Business.TaxCalculator.UpdateCartDetailTaxInformation(CartOrder cartOrder)
at Telerik.Sitefinity.Modules.Ecommerce.Orders.OrdersManager.AddToCart(CartOrder cartOrder, Product product, OptionsDetails optionsDetails, Int32 quantity)
at Telerik.Sitefinity.Modules.Ecommerce.Orders.Business.ShoppingCartAdder.AddItemToShoppingCart(IOrdersControl ordersControl, ICartOrderManager ordersManager, Product product, OptionsDetails optionsDetails, Int32 quantity, String currency, Nullable`1 wishlistDetailId)
at Telerik.Sitefinity.Modules.Ecommerce.Orders.Web.UI.AddToCartWidget.AddToCartButton_Command(Object sender, CommandEventArgs e)
Category: ErrorLog
Priority: -1
EventId: 1
Severity: Information
Title:
Machine: YARDIUSER-PC
App Domain: b2b229e9-1-130201572455522551
ProcessId: 4520
Process Name: C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\WebDev.WebServer40.exe
Thread Name:
Win32 ThreadId:8716
Extended Properties:
----------------------------------------