How do I make MFX work with flat categories / flat products?

Home » Question » How do I make MFX work with flat categories / flat products?
AnswersCategory: FAQHow do I make MFX work with flat categories / flat products?
Kratt Kaarel Staff asked 2 years ago

I have flat category or products enabled. I get an error “SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘mf_guid’ in ‘field list'”
when I try to save a category. How to fix that?
 
 

1 Answers
Marju Mihkelsoo Staff answered 2 years ago

If you have flat categories enabled you need to take these steps after installing MFX to make MFX work with flat categories:

  1. create a backup of your database;
  2. drop “flat category” database tables that have names like: catalog_category_flat_store_1 where 1 is tore ID (it may vary);
  3. update and save your category and “flat category” tables will be regenerated.

The same applies for flat products:

  1. create a backup of your database;
  2. drop “flat product” database tables that have names like: catalog_product_flat_store_1 where 1 is tore ID (it may vary);
  3. update and save your product and “flat product” tables will be regenerated.