informundo
commented
8 years ago This is the error with flat Catalog = "Yes":
SELECT SUM(order_items.qty_ordered) AS ordered_qty, order_items.name AS order_items_name, order_items.product_id AS entity_id, e.entity_type_id, e.attribute_set_id, e.type_id, e.sku, e.has_options, e.required_options, e.created_at, e.updated_at, e.entity_id, e.attribute_set_id, e.type_id, e.activation_information, e.color, e.color_value, e.computer_manufacturers, e.computer_manufacturers_value, e.contrast_ratio, e.contrast_ratio_value, e.cost, e.country_orgin, e.cpu_speed, e.cpu_speed_value, e.created_at, e.custom_design_from, e.custom_design_to, e.custom_layout_update, e.description, e.dimension, e.finish, e.gallery, e.gender, e.gender_value, e.gift_message_available, e.harddrive_speed, e.hardrive, e.has_options, e.image, e.image_label, e.in_depth, e.is_recurring, e.links_exist, e.links_purchased_separately, e.links_title, e.manufacturer, e.manufacturer_value, e.max_resolution, e.media_gallery, e.megapixels, e.megapixels_value, e.memory, e.meta_description, e.meta_keyword, e.meta_title, e.minimal_price, e.model, e.msrp, e.msrp_display_actual_price_type, e.msrp_enabled, e.name, e.news_from_date, e.news_to_date, e.old_id, e.price, e.price_type, e.price_view, e.processor, e.ram_size, e.recurring_profile, e.required_options, e.response_time, e.room, e.room_value, e.samples_title, e.screensize, e.shape, e.shipment_type, e.shirt_size, e.shirt_size_value, e.shoe_size, e.shoe_size_value, e.shoe_type, e.shoe_type_value, e.short_description, e.sku, e.sku_type, e.small_image, e.small_image_label, e.special_from_date, e.special_price, e.special_to_date, e.tax_class_id, e.thumbnail, e.thumbnail_label, e.updated_at, e.url_key, e.url_path, e.visibility, e.weight, e.weight_type, e.em_deal, e.em_featured, e.em_hot, e.status FROM sales_flat_order_item AS order_items
INNER JOIN sales_flat_order AS order ON order.entity_id = order_items.order_id AND order.state <> 'canceled'
LEFT JOIN catalog_product_entity AS e ON (e.type_id NOT IN ('grouped', 'configurable', 'bundle')) AND e.entity_id = order_items.product_id AND e.entity_type_id = 10 WHERE (parent_item_id IS NULL) AND (((e.entity_id = 'in') OR (((e.entity_id = '209') OR (e.entity_id = '210') OR (e.entity_id = '211') OR (e.entity_id = '212') OR (e.entity_id = '213') OR (e.entity_id = '214') OR (e.entity_id = '215') OR (e.entity_id = '216') OR (e.entity_id = '217') OR (e.entity_id = '218') OR (e.entity_id = '219') OR (e.entity_id = '220') OR (e.entity_id = '221') OR (e.entity_id = '222') OR (e.entity_id = '223') OR (e.entity_id = '224') OR (e.entity_id = '225') OR (e.entity_id = '226') OR (e.entity_id = '227') OR (e.entity_id = '228') OR (e.entity_id = '229'))))) GROUP BY order_items.product_id HAVING (SUM(order_items.qty_ordered) > 0) ORDER BY ordered_qty desc
rishiraj87
After setting "Yes" to Use Flat Catalog Product, Vendor profile page shows all products from site and Items for Sale page shows Magento error message.