View Single Post
  #27  
Old 11-28-2014, 03:54 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,431
 

Default Re: Re-building cache not complete

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.
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote