Search found 4 matches

by PC77375
Tue Jul 27, 2010 9:29 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DELETE statement conflicted with COLUMN REFERENCE constraint
Replies: 5
Views: 3294

Re: DELETE statement conflicted with COLUMN REFERENCE constraint

I guess what we are also missing is that bug appears to have been resolved many versions ago. We are running the most current version, are we seeing a new bug?
by PC77375
Tue Jul 27, 2010 9:24 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DELETE statement conflicted with COLUMN REFERENCE constraint
Replies: 5
Views: 3294

Re: DELETE statement conflicted with COLUMN REFERENCE constraint

Already been there and tried that, I get the following when I run the script: Server: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near 'try'. Server: Msg 156, Level 15, State 1, Line 29 Incorrect syntax near the keyword 'end'. Server: Msg 195, Level 15, State 1, Line 34 'ERROR_NUMBER...
by PC77375
Tue Jul 27, 2010 8:18 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DELETE statement conflicted with COLUMN REFERENCE constraint
Replies: 5
Views: 3294

Re: DELETE statement conflicted with COLUMN REFERENCE constraint

AbleCommerce for ASP.NET
VERSION: 7.0.4.14026
MSSQL v2000
AC SCHEMA v2000
by PC77375
Tue Jul 20, 2010 7:37 am
Forum: AbleCommerce 7.0 Asp.Net Shopping Cart
Topic: DELETE statement conflicted with COLUMN REFERENCE constraint
Replies: 5
Views: 3294

DELETE statement conflicted with COLUMN REFERENCE constraint

I see the following in the error logs generating every 20-30 seconds: Error in user maintenance DELETE statement conflicted with COLUMN REFERENCE constraint 'ac_Addresses_ac_BasketShipments_FK1'. The conflict occurred in database 'Cart', table 'ac_BasketShipments', column 'AddressId'. The statement ...