Error Question

[igavemybest]

Anyone have any idea what would cause this?

11/19/2009 6:19:16 PM Error An error has occured at http://www.safetekusa.com/shopping/PayP ... 2M87EQPHUS Exception of type 'System.Web.HttpUnhandledException' was thrown.; The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "ac7_safetekusacom", table "dbo.ac_Countries", column 'CountryCode'. The statement has been terminated.

[mazhar]

What is your application version? You can check this info under Admin -> Help -> About AbleCommerce

[igavemybest]

PLATFORM: ASP.NET
VERSION: 7.0.3
BUILD: 12458
MSSQL v2008
AC SCHEMA v2005

AjaxControlToolkit: 3.0.20229.20843
CommerceBuilder: 7.3.12912.0
CommerceBuilder.AbleCommerceTax: 7.3.12396.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.BankOfCanada: 7.3.0.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.Configuration: 7.3.12065.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.Data: 7.3.12065.0
CommerceBuilder.DataClient.Api: 7.0.3.1
CommerceBuilder.DataClient.Csv: 7.0.34.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.GoogleCheckout: 7.0.10052.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.2.11284.0
CommerceBuilder.PayPal: 7.3.12238.0
CommerceBuilder.Protx: 7.3.12327.0
CommerceBuilder.Services: 7.3.12065.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.3.12065.0
ComponentArt.Web.UI: 2008.2.1267.35
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
FlashControl: 2.8.2902.1367
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
imageHandler: 1.0.0.0
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Practices.EnterpriseLibrary.Common: 2.0.0.0
Microsoft.Practices.EnterpriseLibrary.Data: 2.0.0.0
Microsoft.Practices.ObjectBuilder: 1.0.51205.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0

[napacabs]

Has this been resolved? Getting this error with 7.0.7 build 14600.

Anyone have any idea what would cause this?

11/19/2009 6:19:16 PM Error An error has occured at http://www.safetekusa.com/shopping/PayP ... 2M87EQPHUS Exception of type 'System.Web.HttpUnhandledException' was thrown.; The UPDATE statement conflicted with the FOREIGN KEY constraint "ac_Countries_ac_Addresses_FK1". The conflict occurred in database "ac7_safetekusacom", table "dbo.ac_Countries", column 'CountryCode'. The statement has been terminated.

[AbleMods]

Has anyone deleted any countries out of the Configure/Regions/Countries?

Sounds like there might be an address in the address book linked to a country code that no longer exists.