Error after enable the use_flat_Catalog_category option in admin catalog,

After enable the use_flat_Catalog_category option in admin catalog , and i did reindex, then catalog_category_flat_store_1 table was create.

And then when i try to launch the store, it's show below SQL error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.thumbnail' in 'field list', query was: SELECT `main_table`.`entity_id`, `main_table`.`level`, `main_table`.`path`, `main_table`.`position`, `main_table`.`is_active`, `main_table`.`is_anchor`, `main_table`.`name`, `main_table`.`url_key`, `main_table`.`thumbnail`, `main_table`.`cattop_thumb` FROM `tt_catalog_category_flat_store_1` AS `main_table` WHERE (is_active = '1') AND (catslider = '1') ORDER BY name ASC

because catalog flat table does not have thumbnail column.

And i understand that catalog_flat_table column are created based on below sql query

SELECT `tt_eav_attribute`.* FROM `tt_eav_entity_type` INNER JOIN `tt_eav_attribute` ON tt_eav_attribute.entity_type_id = tt_eav_entity_type.entity_type_id WHERE  (tt_eav_entity_type.entity_type_code = 'catalog_category')

even this query also does not have attribute name like 'thumbnail'

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

asked Aug 27 '15 at 16:12

Syed Diwan

162

bumped to the homepage by Community♦ 8 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

Have you rebuilt the flat catalog indexes?

– Yiorgos Moschovitis
Aug 27 '15 at 16:17

What does SHOW COLUMNS FROM tt_catalog_category_flat_store_1 show you?

– Fabian Schmengler
Aug 28 '15 at 6:30

Thanks fschmengler, i found and correct the problem, it because of my Installed theme mistake.

– Syed Diwan
Aug 28 '15 at 14:18

Feel free to add your solution as an answer and accept it, so that this does not count as unanswered anymore

– Fabian Schmengler
Dec 18 '15 at 15:22

add a comment |

After enable the use_flat_Catalog_category option in admin catalog , and i did reindex, then catalog_category_flat_store_1 table was create.

And then when i try to launch the store, it's show below SQL error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.thumbnail' in 'field list', query was: SELECT `main_table`.`entity_id`, `main_table`.`level`, `main_table`.`path`, `main_table`.`position`, `main_table`.`is_active`, `main_table`.`is_anchor`, `main_table`.`name`, `main_table`.`url_key`, `main_table`.`thumbnail`, `main_table`.`cattop_thumb` FROM `tt_catalog_category_flat_store_1` AS `main_table` WHERE (is_active = '1') AND (catslider = '1') ORDER BY name ASC

because catalog flat table does not have thumbnail column.

And i understand that catalog_flat_table column are created based on below sql query

SELECT `tt_eav_attribute`.* FROM `tt_eav_entity_type` INNER JOIN `tt_eav_attribute` ON tt_eav_attribute.entity_type_id = tt_eav_entity_type.entity_type_id WHERE  (tt_eav_entity_type.entity_type_code = 'catalog_category')

even this query also does not have attribute name like 'thumbnail'

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

asked Aug 27 '15 at 16:12

Syed Diwan

162

bumped to the homepage by Community♦ 8 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

Have you rebuilt the flat catalog indexes?

– Yiorgos Moschovitis
Aug 27 '15 at 16:17

What does SHOW COLUMNS FROM tt_catalog_category_flat_store_1 show you?

– Fabian Schmengler
Aug 28 '15 at 6:30

Thanks fschmengler, i found and correct the problem, it because of my Installed theme mistake.

– Syed Diwan
Aug 28 '15 at 14:18

Feel free to add your solution as an answer and accept it, so that this does not count as unanswered anymore

– Fabian Schmengler
Dec 18 '15 at 15:22

add a comment |

After enable the use_flat_Catalog_category option in admin catalog , and i did reindex, then catalog_category_flat_store_1 table was create.

And then when i try to launch the store, it's show below SQL error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.thumbnail' in 'field list', query was: SELECT `main_table`.`entity_id`, `main_table`.`level`, `main_table`.`path`, `main_table`.`position`, `main_table`.`is_active`, `main_table`.`is_anchor`, `main_table`.`name`, `main_table`.`url_key`, `main_table`.`thumbnail`, `main_table`.`cattop_thumb` FROM `tt_catalog_category_flat_store_1` AS `main_table` WHERE (is_active = '1') AND (catslider = '1') ORDER BY name ASC

because catalog flat table does not have thumbnail column.

And i understand that catalog_flat_table column are created based on below sql query

SELECT `tt_eav_attribute`.* FROM `tt_eav_entity_type` INNER JOIN `tt_eav_attribute` ON tt_eav_attribute.entity_type_id = tt_eav_entity_type.entity_type_id WHERE  (tt_eav_entity_type.entity_type_code = 'catalog_category')

even this query also does not have attribute name like 'thumbnail'

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

asked Aug 27 '15 at 16:12

Syed Diwan

162

After enable the use_flat_Catalog_category option in admin catalog , and i did reindex, then catalog_category_flat_store_1 table was create.

And then when i try to launch the store, it's show below SQL error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'main_table.thumbnail' in 'field list', query was: SELECT `main_table`.`entity_id`, `main_table`.`level`, `main_table`.`path`, `main_table`.`position`, `main_table`.`is_active`, `main_table`.`is_anchor`, `main_table`.`name`, `main_table`.`url_key`, `main_table`.`thumbnail`, `main_table`.`cattop_thumb` FROM `tt_catalog_category_flat_store_1` AS `main_table` WHERE (is_active = '1') AND (catslider = '1') ORDER BY name ASC

because catalog flat table does not have thumbnail column.

And i understand that catalog_flat_table column are created based on below sql query

SELECT `tt_eav_attribute`.* FROM `tt_eav_entity_type` INNER JOIN `tt_eav_attribute` ON tt_eav_attribute.entity_type_id = tt_eav_entity_type.entity_type_id WHERE  (tt_eav_entity_type.entity_type_code = 'catalog_category')

even this query also does not have attribute name like 'thumbnail'

magento-1.9 error catalog indexing

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

asked Aug 27 '15 at 16:12

Syed Diwan

162

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

asked Aug 27 '15 at 16:12

Syed Diwan

162

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

edited Jan 1 '16 at 18:15

Fabian Schmengler

54.4k20130343

asked Aug 27 '15 at 16:12

Syed Diwan

162

asked Aug 27 '15 at 16:12

Syed Diwan

162

asked Aug 27 '15 at 16:12

Syed Diwan

162

bumped to the homepage by Community♦ 8 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

bumped to the homepage by Community♦ 8 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

Have you rebuilt the flat catalog indexes?

– Yiorgos Moschovitis
Aug 27 '15 at 16:17

What does SHOW COLUMNS FROM tt_catalog_category_flat_store_1 show you?

– Fabian Schmengler
Aug 28 '15 at 6:30

Thanks fschmengler, i found and correct the problem, it because of my Installed theme mistake.

– Syed Diwan
Aug 28 '15 at 14:18

Feel free to add your solution as an answer and accept it, so that this does not count as unanswered anymore

– Fabian Schmengler
Dec 18 '15 at 15:22

add a comment |

Have you rebuilt the flat catalog indexes?

– Yiorgos Moschovitis
Aug 27 '15 at 16:17

What does SHOW COLUMNS FROM tt_catalog_category_flat_store_1 show you?

– Fabian Schmengler
Aug 28 '15 at 6:30

Thanks fschmengler, i found and correct the problem, it because of my Installed theme mistake.

– Syed Diwan
Aug 28 '15 at 14:18

Feel free to add your solution as an answer and accept it, so that this does not count as unanswered anymore

– Fabian Schmengler
Dec 18 '15 at 15:22

Have you rebuilt the flat catalog indexes?

– Yiorgos Moschovitis
Aug 27 '15 at 16:17

What does SHOW COLUMNS FROM tt_catalog_category_flat_store_1 show you?

– Fabian Schmengler
Aug 28 '15 at 6:30

Thanks fschmengler, i found and correct the problem, it because of my Installed theme mistake.

– Syed Diwan
Aug 28 '15 at 14:18

Feel free to add your solution as an answer and accept it, so that this does not count as unanswered anymore

– Fabian Schmengler
Dec 18 '15 at 15:22

add a comment |

1 Answer
1

active

oldest

votes

Attributes of the media type like thumbnail are always included in the flat index (unlike other attributes where it depends on the "Use in product listing" setting).

So since you just enabled the flat index for the first time, this probably means that it has not been built correctly. Go to System > Index Management in the admin panel and rebuild the index.

If that does not help, try to flush the DDL cache with the following PHP script (burn after executing):

<?php

require 'app/Mage.php';

Mage::app();

Mage::getSingleton('core/resource')

    ->getConnection('core_write')

    ->resetDdlCache();

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

Thanks fschmengler, I have found the problem, "thumbnail" is not core magento property for catalog_category. Because it was created from my installed theme.

– Syed Diwan
Aug 28 '15 at 9:24

Oh, I totally missed the fact that you were talking about the category flat index, not the product flat index.

– Fabian Schmengler
Aug 28 '15 at 9:25

add a comment |

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');

var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);

});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f80122%2ferror-after-enable-the-use-flat-catalog-category-option-in-admin-catalog%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

Attributes of the media type like thumbnail are always included in the flat index (unlike other attributes where it depends on the "Use in product listing" setting).

So since you just enabled the flat index for the first time, this probably means that it has not been built correctly. Go to System > Index Management in the admin panel and rebuild the index.

If that does not help, try to flush the DDL cache with the following PHP script (burn after executing):

<?php

require 'app/Mage.php';

Mage::app();

Mage::getSingleton('core/resource')

    ->getConnection('core_write')

    ->resetDdlCache();

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

Thanks fschmengler, I have found the problem, "thumbnail" is not core magento property for catalog_category. Because it was created from my installed theme.

– Syed Diwan
Aug 28 '15 at 9:24

Oh, I totally missed the fact that you were talking about the category flat index, not the product flat index.

– Fabian Schmengler
Aug 28 '15 at 9:25

add a comment |

Attributes of the media type like thumbnail are always included in the flat index (unlike other attributes where it depends on the "Use in product listing" setting).

So since you just enabled the flat index for the first time, this probably means that it has not been built correctly. Go to System > Index Management in the admin panel and rebuild the index.

If that does not help, try to flush the DDL cache with the following PHP script (burn after executing):

<?php

require 'app/Mage.php';

Mage::app();

Mage::getSingleton('core/resource')

    ->getConnection('core_write')

    ->resetDdlCache();

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

Thanks fschmengler, I have found the problem, "thumbnail" is not core magento property for catalog_category. Because it was created from my installed theme.

– Syed Diwan
Aug 28 '15 at 9:24

Oh, I totally missed the fact that you were talking about the category flat index, not the product flat index.

– Fabian Schmengler
Aug 28 '15 at 9:25

add a comment |

Attributes of the media type like thumbnail are always included in the flat index (unlike other attributes where it depends on the "Use in product listing" setting).

So since you just enabled the flat index for the first time, this probably means that it has not been built correctly. Go to System > Index Management in the admin panel and rebuild the index.

If that does not help, try to flush the DDL cache with the following PHP script (burn after executing):

<?php

require 'app/Mage.php';

Mage::app();

Mage::getSingleton('core/resource')

    ->getConnection('core_write')

    ->resetDdlCache();

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

Attributes of the media type like thumbnail are always included in the flat index (unlike other attributes where it depends on the "Use in product listing" setting).

So since you just enabled the flat index for the first time, this probably means that it has not been built correctly. Go to System > Index Management in the admin panel and rebuild the index.

If that does not help, try to flush the DDL cache with the following PHP script (burn after executing):

<?php

require 'app/Mage.php';

Mage::app();

Mage::getSingleton('core/resource')

    ->getConnection('core_write')

    ->resetDdlCache();

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

answered Aug 27 '15 at 16:35

Fabian Schmengler

54.4k20130343

Thanks fschmengler, I have found the problem, "thumbnail" is not core magento property for catalog_category. Because it was created from my installed theme.

– Syed Diwan
Aug 28 '15 at 9:24

Oh, I totally missed the fact that you were talking about the category flat index, not the product flat index.

– Fabian Schmengler
Aug 28 '15 at 9:25

add a comment |

Thanks fschmengler, I have found the problem, "thumbnail" is not core magento property for catalog_category. Because it was created from my installed theme.

– Syed Diwan
Aug 28 '15 at 9:24

Oh, I totally missed the fact that you were talking about the category flat index, not the product flat index.

– Fabian Schmengler
Aug 28 '15 at 9:25

Thanks fschmengler, I have found the problem, "thumbnail" is not core magento property for catalog_category. Because it was created from my installed theme.

– Syed Diwan
Aug 28 '15 at 9:24

Oh, I totally missed the fact that you were talking about the category flat index, not the product flat index.

– Fabian Schmengler
Aug 28 '15 at 9:25

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Magento Stack Exchange!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

Post as a guest

Name

Required, but never shown

Sign up or log in

Post as a guest

Name

Required, but never shown

Sign up or log in

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Orsdxy