[SignTorch]

shaz, the Integrity constraint violation is not an x-cart error it is an error in the database where one row references another row in another table and the row that is being referenced does not exist

in this case there must be an extra or incorrect row in table xc_attribute_option_translations which has an id field value that does not match any existing row with the same id field value in table xc_attribute_options,

the only way to fix that error is to correct all mis-matches between all rows in all associated tables, hopefully you don't have too many so that it can be corrected manually without much trouble