Page 1 of 1
DELETE statement conflicted with COLUMN REFERENCE constraint
Posted: Tue Jul 20, 2010 7:37 am
by PC77375
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 has been terminated.
Does anyone know how to eliminate this error?
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
Posted: Tue Jul 20, 2010 9:52 am
by mazhar
What is your application version? You can found this information under Administration -> Help -> About AbleCommerce
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
Posted: Tue Jul 27, 2010 8:18 am
by PC77375
AbleCommerce for ASP.NET
VERSION: 7.0.4.14026
MSSQL v2000
AC SCHEMA v2000
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
Posted: Tue Jul 27, 2010 8:49 am
by mazhar
Please read following thread
viewtopic.php?f=42&t=12518
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
Posted: Tue Jul 27, 2010 9:24 am
by PC77375
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' is not a recognized function name.
Server: Msg 156, Level 15, State 1, Line 43
Incorrect syntax near the keyword 'end'.
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
Posted: Tue Jul 27, 2010 9:29 am
by PC77375
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?