Magento 2.3.4 - Missing records in the Content->Design->Configuration

We couldnt find any records

Can't add favicon in the Magento2.

In Admin panel -> Content -> Design -> Configuration.

Shows We couldn't found any records


First take a back this design_config_grid_flat table

Now clear table data

TRUNCATE TABLE design_config_grid_flat;

Now insert data

INSERT INTO 'design_config_grid_flat' ('entity_id', 'store_website_id', 'store_group_id', 'store_id', 'theme_theme_id') VALUES
(0, ZERO, ZERO, ZERO, '3'),
(1, 1, ZERO, ZERO, '3'),
(2, 1, 1, 1, '3');

Now run this command

php bin/magento setup:upgrade

Now check it.

  • Let me inform above SQL Queries are works for you ?? – Msquare Feb 11 '20 at 14:38
  • SQL Queries are fine. Still it repeats the same "We couldn't find any records". – Sathya Feb 12 '20 at 4:39
  • 1
    After I did setup:upgrade the design configurations are correctly fetched from the database. – Sathya Feb 12 '20 at 5:30
  • @Sathya I add that in answer – Msquare Feb 12 '20 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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