2

I am running Magento 1.9.3.8 and would like to enable Use Flat Catalog Product as I have over 100k skus.

After enabling it, rebuilding the indexes, and clearing cache, the frontend will not load. It continuously spins until the server crashes. There are no errors regarding this in any of the logs, and I believe that is because the page never finishes loading?

Magento Admin works fine after enabling.

Use Flat Catalog Category works without issue.

How can I debug this issue if I do not receive any errors and the pages never load? Does anyone have any idea where to start? I can provide additional details if needed.

Improve this question
6
  • I assume you are using some 3rd paty theme as you mentioned spinner in post, have you looked over XHR requests in Chrome console (if you are using chrome ) ? There should be request from the catalog products in there
    – Ilja
    Commented May 10, 2018 at 21:35
  • Did you check the apache server logs ? You will get more details about this issue.
    – magento2new
    Commented May 11, 2018 at 7:02
  • @Pravin - No errors in any of the logs includes the nginx server logs.
    – MagentoAaron
    Commented May 11, 2018 at 12:04
  • @llja - Yes, I am using the Athlete theme, however I'm not talking about a UI element spinning, I'm referring to the browser tab loading (spinning at the top). The console hasn't been any help as the page never loads.
    – MagentoAaron
    Commented May 11, 2018 at 12:10
  • @MagentoAaron have you tried ini_set('display_errors', 1); in index.php You can also open mysql and check the running queries. It might be possible that there are some sleeping queries . check "show processlist"
    – magento2new
    Commented May 11, 2018 at 12:16

1 Answer 1

Reset to default
1

Use Flat Catalog Product tells Magento to use the flat database table for the catalog/product model. This is a flattened database table that has every attribute this model uses, which makes it faster than the standard EAV tables for this data.

Likely what is happening is your templates or blocks are attempting to use an attribute that is not in this flat table.

Magento determines which attributes should be added to the flat table based on the attribute's configuration. To add attributes to the flat table, edit them in the admin and select Used in Product Listing.

Then, reindex the site and clear your cache.

If you add all of the used attributes to the flat table using this method the page should render properly.

Good luck!

Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.