Over 1000 of these errors in 2 days.

[chuckdvc]

The DELETE statement conflicted with the REFERENCE constraint "******************
". The conflict occurred in database "*****************", table "***********************", column 'UserId'. The statement has been terminated.


Any idea whats causing this?

[dgoranov]

This looks like an error generated by AbleCommerce automated cleanup procedure that removes all 'Anonymous' users. If an user has places an order and is still
being recognized as "Guest - Anonymous" user the cleanup script will not be able to delete the user because there are related order records in the database.

If you are still getting the same error check the \App_Data\Logs\app.log and see if you can find the UserId for this user. Then you have to manually fix the record.

[WylieE]

We've started getting these errors out of the blue. Never had them before.

AbleCommerce for ASP.NET
VERSION: 7.0.7.14588
MSSQL v2005
AC SCHEMA v2005
.NET CLR v2.0.50727.5466

What did you do to fix the records or did the error go away on its own?