Hi shaz!
Did you migrate data into X-Cart 5 from other store? If so, who made these changes?
SignTorch is right, the problem is that xc_attribute_option_translations contains records that refer to records in the xc_attribute_options table that do not exist.
You can find these records if you call the following MySQL query:
Code:
SELECT * FROM xc_attribute_option_translations LEFT JOIN xc_attribute_options ON xc_attribute_option_translations.id = xc_attribute_options.id WHERE xc_attribute_options.id IS NULL;
Tony.