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?
DELETE statement conflicted with COLUMN REFERENCE constraint
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
What is your application version? You can found this information under Administration -> Help -> About AbleCommerce
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
AbleCommerce for ASP.NET
VERSION: 7.0.4.14026
MSSQL v2000
AC SCHEMA v2000
VERSION: 7.0.4.14026
MSSQL v2000
AC SCHEMA v2000
Re: DELETE statement conflicted with COLUMN REFERENCE constraint
Please read following thread
viewtopic.php?f=42&t=12518
viewtopic.php?f=42&t=12518
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' is not a recognized function name.
Server: Msg 156, Level 15, State 1, Line 43
Incorrect syntax near the keyword 'end'.
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
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?