shopping cart error

2 posts, 0 answers
  1. Zhong
    Zhong avatar
    1 posts
    Member since:
    Jul 2013

    Posted 05 Aug 2013 Link to this post

    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: 
    ----------------------------------------
  2. Grisha 'Greg' Karanikolov
    Admin
    Grisha 'Greg' Karanikolov avatar
    5 posts

    Posted 08 Aug 2013 Link to this post

    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
  3. DevCraft banner
Back to Top