This is a migrated thread and some comments may be shown as answers.

shopping cart error

1 Answer 41 Views
Getting Started
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Zhong
Top achievements
Rank 1
Zhong asked on 05 Aug 2013, 06:26 AM
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: 
----------------------------------------

1 Answer, 1 is accepted

Sort by
0
Grisha 'Greg' Karanikolov
Telerik team
answered on 08 Aug 2013, 08:19 AM
Hello Zhong,

Thank you for contacting us! I am investigating the issue as we speak. Could you tell me what locale you have set on your machine?

Regards,
Grisha 'Greg' Karanikolov
Telerik
Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Getting Started
Asked by
Zhong
Top achievements
Rank 1
Answers by
Grisha 'Greg' Karanikolov
Telerik team
Share this question
or