CartMart
CartMart copied to clipboard
syammohanmp
Flat product breaks vendor profile and Items for Sale pages
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.
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
I'm facing the same issue. Please provide a solution to this as soon as possible.
