AbleCommerce Shopping Cart Software

Is there a fix (patch) available for this bug? On our site, it's happening for some users checking out with PayPal Express. We have PayPal authorization mode set to "sale" and handlefailedpayments on the receipt page set to true. Is this the fix: http://bugs.ablecommerce.com/show_bug.cgi?id=8351 Tha...

Thanks for your reply Mazhar. I think I actually found the issue. The ac_Baskets_ac_BasketShipments_FK1 foreign key was missing which as you probably know causes a cascade delete in the ac_BasketShipments table. By profiling the database, I found that the user maintenance routine deletes expired rec...

This is in our error log: The DELETE statement conflicted with the REFERENCE constraint "ac_Addresses_ac_BasketShipments_FK1". The conflict occurred in database "Roku.AbleCommerce", table "dbo.ac_BasketShipments", column 'AddressId'. The statement has been terminated. Is anybody else seeing this? I ...